CST_XLA_TRADE_TXNS

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
DISTRIBUTION_ID TRADE_EVENT_ID SOURCE_DOCUMENT_TYPE SOURCE_DOCUMENT_NUMBER TRANSACTION_DATE QUANTITY UOM_CODE INVENTORY_ITEM_ID ITEM_NUMBER INV_ORG_ID TRADE_ORG_CODE BUSINESS_UNIT_ID BUSINESS_UNIT_NAME SFO_AGREEMENT_NUMBER PRIOR_TRADE_ORGANIZATION_ID FROM_INV_ORG_CODE FROM_PROFIT_CENTER_BU_ID FROM_PROFIT_CENTER_BU_NAME

Name

DISTRIBUTION_ID

TRADE_EVENT_ID

SOURCE_DOCUMENT_TYPE

SOURCE_DOCUMENT_NUMBER

TRANSACTION_DATE

QUANTITY

UOM_CODE

INVENTORY_ITEM_ID

ITEM_NUMBER

INV_ORG_ID

TRADE_ORG_CODE

BUSINESS_UNIT_ID

BUSINESS_UNIT_NAME

SFO_AGREEMENT_NUMBER

PRIOR_TRADE_ORGANIZATION_ID

FROM_INV_ORG_CODE

FROM_PROFIT_CENTER_BU_ID

FROM_PROFIT_CENTER_BU_NAME

Query

SQL_Statement
SELECT /+ LEADING(CCD CT CIT CTE ) / ccd.distribution_id, cte.trade_event_id trade_event_id, cte.txn_source_doc_type source_document_type, cte.txn_source_doc_number source_document_number, cte.transaction_date transaction_date, cte.source_doc_quantity quantity, iuom.unit_of_measure uom_code, cte.inventory_item_id inventory_item_id, esi.item_number item_number, cte.inventory_org_id inv_org_id, iop.organization_code trade_org_code, cte.business_unit_id business_unit_id, haous.name business_unit_name, cte.agreement_number sfo_agreement_number, cte.prior_inventory_org_id prior_trade_organization_id, frominvorg.organization_code from_inv_org_code, cte.prior_bu_id from_profit_center_bu_id, frombu.name from_profit_center_bu_name FROM cst_cost_distributions ccd, cst_transactions ct, cst_inv_transactions cit, cst_trade_events cte, egp_system_items_b_v esi, inv_org_parameters iop, hr_all_organization_units haous, inv_units_of_measure_vl iuom, inv_org_parameters frominvorg, hr_all_organization_units frombu WHERE cte.inventory_item_id = esi.inventory_item_id (+) AND iop.master_organization_id = esi.organization_id (+) AND iop.organization_id = cte.inventory_org_id AND iuom.uom_code = cte.source_doc_uom_code AND haous.organization_id = cte.business_unit_id AND cte.prior_inventory_org_id = frominvorg.organization_id (+) AND frombu.organization_id (+) = frominvorg.business_unit_id AND cit.external_system_reference = 'FOS_INTERNAL' AND cte.trade_event_id = to_number(cit.external_system_ref_id) AND ct.cst_inv_transaction_id = cit.cst_inv_transaction_id AND ct.transaction_id = ccd.transaction_id

SQL_Statement

SELECT /*+ LEADING(CCD CT CIT CTE ) */

ccd.distribution_id,

cte.trade_event_id trade_event_id,

cte.txn_source_doc_type source_document_type,

cte.txn_source_doc_number source_document_number,

cte.transaction_date transaction_date,

cte.source_doc_quantity quantity,

iuom.unit_of_measure uom_code,

cte.inventory_item_id inventory_item_id,

esi.item_number item_number,

cte.inventory_org_id inv_org_id,

iop.organization_code trade_org_code,

cte.business_unit_id business_unit_id,

haous.name business_unit_name,

cte.agreement_number sfo_agreement_number,

cte.prior_inventory_org_id prior_trade_organization_id,

frominvorg.organization_code from_inv_org_code,

cte.prior_bu_id from_profit_center_bu_id,

frombu.name from_profit_center_bu_name

FROM

cst_cost_distributions ccd,

cst_transactions ct,

cst_inv_transactions cit,

cst_trade_events cte,

egp_system_items_b_v esi,

inv_org_parameters iop,

hr_all_organization_units haous,

inv_units_of_measure_vl iuom,

inv_org_parameters frominvorg,

hr_all_organization_units frombu

WHERE

cte.inventory_item_id = esi.inventory_item_id (+)

AND iop.master_organization_id = esi.organization_id (+)

AND iop.organization_id = cte.inventory_org_id

AND iuom.uom_code = cte.source_doc_uom_code

AND haous.organization_id = cte.business_unit_id

AND cte.prior_inventory_org_id = frominvorg.organization_id (+)

AND frombu.organization_id (+) = frominvorg.business_unit_id

AND cit.external_system_reference = 'FOS_INTERNAL'

AND cte.trade_event_id = to_number(cit.external_system_ref_id)

AND ct.cst_inv_transaction_id = cit.cst_inv_transaction_id

AND ct.transaction_id = ccd.transaction_id