2 queries found for "Business Object Status"

Retrieve Business Object Status - Generic

SELECT OB.BUS_OBJ_CD,  OB.BO_STATUS_CD, SL.DESCR
 FROM F1_BUS_OBJ_STATUS OB,
      F1_BUS_OBJ_STATUS_L SL
WHERE OB.BUS_OBJ_CD = :INSERT_BO_TYPE_HERE
AND OB.BUS_OBJ_CD = SL.BUS_OBJ_CD 
AND OB.BO_STATUS_CD = SL.BO_STATUS_CD
AND SL.LANGUAGE_CD = :INSERT_LANGUAGE_HERE

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