5 queries found for "Business Object"

Get all from Business Object

select * 
from F1_BUS_OBJ

uploaded by Nuno Rodrigues

Get specific Business Object

select * 
from F1_BUS_OBJ
where 
BUS_OBJ_CD = 'XXXX'

uploaded by Nuno Rodrigues

Get Business Object parent child relationship

SELECT A.PARENT_BO_CD, A.BUS_OBJ_CD AS DESCR
 FROM F1_BUS_OBJ A, F1_BUS_OBJ B
WHERE A.PARENT_BO_CD = B.BUS_OBJ_CD
  AND B.PARENT_BO_CD like '%PARENT_BO_CODE_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

Retrieve Business Object List

SELECT A.BUS_OBJ_CD, B.DESCR , A.*
  FROM F1_BUS_OBJ A, F1_BUS_OBJ_L B
WHERE 
    A.BUS_OBJ_CD = B.BUS_OBJ_CD
    AND B.LANGUAGE_CD = :LANGUAGE
    --AND trim(A.MAINT_OBJ_CD) = 'INSERT_MAINTENANCE_OBJECT_CD'

uploaded by Nuno Rodrigues