5 queries found for "Usage"

Get all from Usage

select * 
from C1_USAGE

uploaded by Nuno Rodrigues

Get specific Usage

select * 
from C1_USAGE
where 
USAGE_ID = 'XXXX'

uploaded by Nuno Rodrigues

Retrieve Bill Segment Usage

SELECT *
FROM C1_USAGE
WHERE BSEG_ID = 'INSERT_BSEG_ID'

uploaded by Nuno Rodrigues

Get Frozen Bill Segments For Usage

SELECT USG.BSEG_ID  
  FROM C1_USAGE USG,CI_BSEG BSEG
  WHERE USG.USAGE_ID = 'INSERT_USAGE_ID'
AND USG.BSEG_ID=BSEG.BSEG_ID 
AND BSEG.BSEG_STAT_FLG='50'

uploaded by Nuno Rodrigues

Get Usage Requests in Awaiting Data Sync Status by SP

SELECT 
USAGE.USAGE_ID
FROM 
CI_SA SA
, CI_SA_SP SASP
, C1_USAGE USAGE
, F1_BUS_OBJ_STATUS BOSTATUS
, F1_BUS_OBJ_STATUS_OPT OPT
, F1_BUS_OBJ BO
 WHERE SASP.SA_ID = SA.SA_ID AND SASP.SP_ID = 'INSERT_SP_ID' and SASP.START_DTTM <= SYSDATE AND (SASP.STOP_DTTM IS NULL OR SASP.STOP_DTTM > SYSDATE)
AND USAGE.SA_ID = SASP.SA_ID
AND USAGE.BUS_OBJ_CD = BO.BUS_OBJ_CD
AND BO.LIFE_CYCLE_BO_CD = BOSTATUS.BUS_OBJ_CD
AND USAGE.BO_STATUS_CD = BOSTATUS.BO_STATUS_CD
AND BOSTATUS.BUS_OBJ_CD = OPT.BUS_OBJ_CD
AND OPT.BO_OPT_FLG = 'F1SC' 
AND OPT.BO_OPT_VAL = 'C1AS'

uploaded by Nuno Rodrigues