CMR_XLA_TRADE_REC_ACCT_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
TRADE_EVENT_ID FROM_LEGAL_ENTITY_CODE FROM_INVENTORY_ORG_CODE FROM_PROFIT_CENTER_BU_CODE TRADE_ACC_SRC_DOC_NUMBER SFO_AGREEMENT_NUMBER SUCCESSOR_LEGAL_ENTITY SUC_PROFIT_CENTER_BU SUC_INV_ORG_CODE BUY_SELL_REL_CODE TP_OPTION INCO_TERM INTER_CO_INVOICE_FLAG DFF_AT_FTR_LEVEL

Query

SQL_Statement

SELECT CTE.TRADE_EVENT_ID TRADE_EVENT_ID, PRIOR_LEGAL_ENTITY.NAME FROM_LEGAL_ENTITY_CODE, PRIOR_IOP.ORGANIZATION_CODE FROM_INVENTORY_ORG_CODE, HAOUS.NAME FROM_PROFIT_CENTER_BU_CODE, cast(null as varchar2(30)) TRADE_ACC_SRC_DOC_NUMBER, CTE.AGREEMENT_NUMBER SFO_AGREEMENT_NUMBER, SUC_LEGAL_ENTITY.NAME SUCCESSOR_LEGAL_ENTITY, SUC_PROFIT_CENTER.NAME SUC_PROFIT_CENTER_BU, SUC_INV_ORG.ORGANIZATION_CODE SUC_INV_ORG_CODE, cast(null as varchar2(30)) BUY_SELL_REL_CODE, cast(null as varchar2(30)) TP_OPTION, cast(null as varchar2(30)) INCO_TERM, cast(null as varchar2(1)) INTER_CO_INVOICE_FLAG, cast(null as varchar2(30)) DFF_AT_FTR_LEVEL FROM CST_TRADE_EVENTS CTE, INV_ORG_PARAMETERS PRIOR_IOP, HR_ALL_ORGANIZATION_UNITS HAOUS, XLE_ENTITY_PROFILES PRIOR_LEGAL_ENTITY, HR_ALL_ORGANIZATION_UNITS SUC_PROFIT_CENTER, INV_ORG_PARAMETERS SUC_INV_ORG, XLE_ENTITY_PROFILES SUC_LEGAL_ENTITY WHERE CTE.PRIOR_BU_ID = HAOUS.ORGANIZATION_ID(+) AND CTE.PRIOR_INVENTORY_ORG_ID = PRIOR_IOP.ORGANIZATION_ID(+) AND PRIOR_IOP.legal_entity_id = PRIOR_LEGAL_ENTITY.LEGAL_ENTITY_ID(+) AND CTE.SUCCESSOR_BU_ID = SUC_PROFIT_CENTER.ORGANIZATION_ID(+) AND CTE.SUCCESSOR_INV_ORG_ID = SUC_INV_ORG.ORGANIZATION_ID(+) AND SUC_INV_ORG.legal_entity_id = SUC_LEGAL_ENTITY.LEGAL_ENTITY_ID(+)