CMR_XLA_TRADE_ACCRUAL

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 BUY_SELL_REL_CODE TP_OPTION INCO_TERM INTER_CO_INVOICE_FLAG DFF_AT_FTR_LEVEL DEFAULT_TAXATION_COUNTRY TRX_BUSINESS_CATEGORY DOCUMENT_FISCAL_CLASSIFICATION USER_DEFINED_FISC_CLASS FIRST_PTY_REG_ID THIRD_PTY_REG_ID PRODUCT_FISC_CLASSIFICATION PRODUCT_CATEGORY INTENDED_USE_CLASSIFICATION_ID SUCCESSOR_BUSINESS_UNIT_ID

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

BUY_SELL_REL_CODE

TP_OPTION

INCO_TERM

INTER_CO_INVOICE_FLAG

DFF_AT_FTR_LEVEL

DEFAULT_TAXATION_COUNTRY

TRX_BUSINESS_CATEGORY

DOCUMENT_FISCAL_CLASSIFICATION

USER_DEFINED_FISC_CLASS

FIRST_PTY_REG_ID

THIRD_PTY_REG_ID

PRODUCT_FISC_CLASSIFICATION

PRODUCT_CATEGORY

INTENDED_USE_CLASSIFICATION_ID

SUCCESSOR_BUSINESS_UNIT_ID

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(cte.txn_source_doc_number AS VARCHAR2(240)) trade_acc_src_doc_number, cte.agreement_number sfo_agreement_number, 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, cte.default_tax_country default_taxation_country, cte.trx_business_category trx_business_category, cte.document_sub_type document_fiscal_classification, cte.user_defined_fisc_class user_defined_fisc_class, cte.first_pty_reg_id first_pty_reg_id, cte.third_pty_reg_id third_pty_reg_id, cte.product_fisc_classif product_fisc_classification, cte.product_category product_category, cte.intend_use_classif_id intended_use_classification_id, CTE.SUCCESSOR_BU_ID SUCCESSOR_BUSINESS_UNIT_ID FROM cst_trade_events cte, inv_org_parameters prior_iop, hr_all_organization_units haous, xle_entity_profiles prior_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(+)

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(cte.txn_source_doc_number AS VARCHAR2(240)) trade_acc_src_doc_number,

cte.agreement_number sfo_agreement_number,

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,

cte.default_tax_country default_taxation_country,

cte.trx_business_category trx_business_category,

cte.document_sub_type

document_fiscal_classification,

cte.user_defined_fisc_class user_defined_fisc_class,

cte.first_pty_reg_id first_pty_reg_id,

cte.third_pty_reg_id third_pty_reg_id,

cte.product_fisc_classif

product_fisc_classification,

cte.product_category product_category,

cte.intend_use_classif_id

intended_use_classification_id,

CTE.SUCCESSOR_BU_ID SUCCESSOR_BUSINESS_UNIT_ID

FROM cst_trade_events cte,

inv_org_parameters prior_iop,

hr_all_organization_units haous,

xle_entity_profiles prior_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(+)