CST_XLA_CONSIGN_TXNS

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
DISTRIBUTION_ID COST_ORG_NAME COST_BOOK_CODE INV_ORG_CODE ITEM_NUMBER PO_NUMBER QUANTITY PURCHASE_ORDER_RECEIPT_NUMBER TRANSACTION_DATE UOM_CODE VAL_UNIT_CODE

Name

DISTRIBUTION_ID

COST_ORG_NAME

COST_BOOK_CODE

INV_ORG_CODE

ITEM_NUMBER

PO_NUMBER

QUANTITY

PURCHASE_ORDER_RECEIPT_NUMBER

TRANSACTION_DATE

UOM_CODE

VAL_UNIT_CODE

Query

SQL_Statement
SELECT DISTINCT ccd.distribution_id distribution_id, cco.cost_org_name cost_org_name , ccb.cost_book_code cost_book_code , iop.organization_code inv_org_code , esi.item_number item_number , cpod.po_number po_number , ct.quantity quantity , crt.RECEIPT_NUMBER purchase_order_receipt_number , ct.transaction_date transaction_date , iuom.unit_of_measure uom_code , cvu.val_unit_code val_unit_code FROM cst_transactions ct , cst_inv_transactions cit , cst_cost_orgs_v cco , cst_cost_books_b ccb , cst_val_units_b cvu , egp_system_items_vl esi , inv_org_parameters iop , cmr_purchase_order_dtls cpod , poz_suppliers_v psv , hr_all_organization_units haous , hr_all_organization_units haoud , cst_cost_distributions ccd, cmr_rcv_transactions crt, inv_units_of_measure_vl iuom WHERE ct.cst_inv_transaction_id = cit.cst_inv_transaction_id AND ct.cost_org_id = cco.cost_org_id AND ct.cost_book_id = ccb.cost_book_id AND ct.val_unit_id = cvu.val_unit_id AND esi.inventory_item_id = ct.inventory_item_id AND esi.organization_id = ct.inventory_org_id AND iop.organization_id = ct.inventory_org_id AND cit.ORIGINAL_RECEIPT_TXN_ID = crt.external_system_ref_id AND cit.external_system_reference = crt.external_system_reference AND cpod.external_system_ref_id = crt.po_distribution_id AND cpod.external_system_reference = cit.external_system_reference AND cpod.active_flag = 'Y' AND psv.vendor_id (+) = cpod.vendor_id AND haous.organization_id (+) = cpod.sold_to_business_unit_id AND haoud.organization_id (+) = cpod.deliver_to_business_unit_id AND ccd.transaction_id = ct.transaction_id AND iuom.uom_code = ct.uom_code

SQL_Statement

SELECT DISTINCT ccd.distribution_id distribution_id,

cco.cost_org_name cost_org_name ,

ccb.cost_book_code cost_book_code ,

iop.organization_code inv_org_code ,

esi.item_number item_number ,

cpod.po_number po_number ,

ct.quantity quantity ,

crt.RECEIPT_NUMBER purchase_order_receipt_number ,

ct.transaction_date transaction_date ,

iuom.unit_of_measure uom_code ,

cvu.val_unit_code val_unit_code

FROM cst_transactions ct ,

cst_inv_transactions cit ,

cst_cost_orgs_v cco ,

cst_cost_books_b ccb ,

cst_val_units_b cvu ,

egp_system_items_vl esi ,

inv_org_parameters iop ,

cmr_purchase_order_dtls cpod ,

poz_suppliers_v psv ,

hr_all_organization_units haous ,

hr_all_organization_units haoud ,

cst_cost_distributions ccd,

cmr_rcv_transactions crt,

inv_units_of_measure_vl iuom

WHERE ct.cst_inv_transaction_id = cit.cst_inv_transaction_id

AND ct.cost_org_id = cco.cost_org_id

AND ct.cost_book_id = ccb.cost_book_id

AND ct.val_unit_id = cvu.val_unit_id

AND esi.inventory_item_id = ct.inventory_item_id

AND esi.organization_id = ct.inventory_org_id

AND iop.organization_id = ct.inventory_org_id

AND cit.ORIGINAL_RECEIPT_TXN_ID = crt.external_system_ref_id

AND cit.external_system_reference = crt.external_system_reference

AND cpod.external_system_ref_id = crt.po_distribution_id

AND cpod.external_system_reference = cit.external_system_reference

AND cpod.active_flag = 'Y'

AND psv.vendor_id (+) = cpod.vendor_id

AND haous.organization_id (+) = cpod.sold_to_business_unit_id

AND haoud.organization_id (+) = cpod.deliver_to_business_unit_id

AND ccd.transaction_id = ct.transaction_id

AND iuom.uom_code = ct.uom_code