CMR_XLA_TRADE_ACCRUAL_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 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(+) |