CST_XLA_TRADE_EVENTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRADE_EVENT_ID SOURCE_DOCUMENT_TYPE SOURCE_DOCUMENT_NUMBER TRADE_ORG_CODE SFO_AGREEMENT_NUMBER FROM_PROFIT_CENTER_BU_ID PRIOR_TRADE_ORGANIZATION_ID FROM_INV_ORG_CODE FROM_PROFIT_CENTER_BU_NAME

Query

SQL_Statement

SELECT CTE.TRADE_EVENT_ID TRADE_EVENT_ID, CTE.TXN_SOURCE_DOC_TYPE SOURCE_DOCUMENT_TYPE , CTE.TXN_SOURCE_DOC_NUMBER SOURCE_DOCUMENT_NUMBER , IOP.ORGANIZATION_CODE TRADE_ORG_CODE, CTE.AGREEMENT_NUMBER SFO_AGREEMENT_NUMBER, CTE.PRIOR_BU_ID FROM_PROFIT_CENTER_BU_ID, CTE.PRIOR_INVENTORY_ORG_ID PRIOR_TRADE_ORGANIZATION_ID, IOP.ORGANIZATION_CODE FROM_INV_ORG_CODE, HAOU.NAME FROM_PROFIT_CENTER_BU_NAME FROM CST_TRADE_EVENTS CTE, INV_ORG_PARAMETERS IOP, HR_ALL_ORGANIZATION_UNITS HAOU WHERE CTE.PRIOR_INVENTORY_ORG_ID=IOP.ORGANIZATION_ID(+) AND HAOU.ORGANIZATION_ID(+) = IOP.BUSINESS_UNIT_ID