View: CE_FC_OEO_DISC_V

Product:	CE - Cash Management
Description:
Implementation/DBA Data:	APPS.CE_FC_OEO_DISC_V

View Text

SELECT TO_CHAR(SRC.REFERENCE_ID)
, SRC.ORDER_NUMBER
, SRC.AMOUNT
, SRC.LINE_NUMBER
, L.MEANING
, SRC.PROFILE_CLASS
, SO.NAME
, NULL
, HR.NAME FROM CE_SO_FC_ORDERS_V SRC
, FND_LOOKUP_VALUES L
, SO_ORDER_TYPES_ALL SO
, HR_OPERATING_UNITS HR
WHERE L.LOOKUP_TYPE = 'LINE_FLOW_STATUS'
AND L.LOOKUP_CODE = SRC.LINE_FLOW_STATUS_CODE
AND L.LANGUAGE = USERENV('LANG') AND SO.ORDER_TYPE_ID = SRC.ORDER_TYPE_ID
AND HR.ORGANIZATION_ID(+) = SRC.ORG_ID
AND (SRC.ORG_ID IS NULL OR EXISTS (SELECT NULL
FROM CE_SECURITY_PROFILES_V SEC
WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID
AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT')) UNION ALL SELECT TO_CHAR(SRC.REFERENCE_ID)
, SRC.ORDER_NUMBER
, SRC.AMOUNT
, SRC.LINE_NUMBER
, L.MEANING
, SRC.PROFILE_CLASS
, SO.NAME
, RA.NAME
, HR.NAME FROM CE_SO_FC_ORDERS_TERMS_V SRC
, FND_LOOKUP_VALUES L
, SO_ORDER_TYPES_ALL SO
, RA_TERMS RA
, HR_OPERATING_UNITS HR
WHERE L.LOOKUP_TYPE = 'LINE_FLOW_STATUS'
AND L.LOOKUP_CODE = SRC.LINE_FLOW_STATUS_CODE
AND L.LANGUAGE = USERENV('LANG') AND SO.ORDER_TYPE_ID = SRC.ORDER_TYPE_ID
AND RA.TERM_ID = SRC.TERM_ID
AND HR.ORGANIZATION_ID(+) = SRC.ORG_ID
AND (SRC.ORG_ID IS NULL OR EXISTS (SELECT NULL
FROM CE_SECURITY_PROFILES_V SEC
WHERE SEC.ORGANIZATION_ID = SRC.ORG_ID
AND SEC.ORGANIZATION_TYPE = 'OPERATING_UNIT'))

Columns