CST_XLA_PO_DELV_TO_WO_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 RECEIPT_NUMBER TRANSACTION_DATE UOM_CODE VAL_UNIT_CODE WORK_ORDER_NUMBER

Name

DISTRIBUTION_ID

COST_ORG_NAME

COST_BOOK_CODE

INV_ORG_CODE

ITEM_NUMBER

PO_NUMBER

QUANTITY

RECEIPT_NUMBER

TRANSACTION_DATE

UOM_CODE

VAL_UNIT_CODE

WORK_ORDER_NUMBER

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 , NVL2(ct.po_item_description,ct.po_item_description,esi.item_number) item_number , cpod.po_number po_number , ct.quantity quantity , cit.txn_source_doc_number receipt_number , ct.transaction_date transaction_date , NVL2(ct.transaction_currency_code,ct.transaction_currency_code,iuom.unit_of_measure) uom_code , cvu.val_unit_code val_unit_code , cwo.work_order_number work_order_number 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 , cst_cost_distributions ccd, inv_units_of_measure_vl iuom, cst_work_orders cwo 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 cpod.external_system_ref_id = to_char(cit.po_distribution_id) AND cpod.external_system_reference = decode(cit.external_system_reference, 'RCV_INTERNAL', 'FUSION', cit.external_system_reference) AND cpod.active_flag = 'Y' AND ccd.transaction_id = ct.transaction_id AND iuom.uom_code(+) = ct.uom_code AND ct.cst_work_order_id = cwo.cst_work_order_id(+)

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 ,

NVL2(ct.po_item_description,ct.po_item_description,esi.item_number) item_number ,

cpod.po_number po_number ,

ct.quantity quantity ,

cit.txn_source_doc_number receipt_number ,

ct.transaction_date transaction_date ,

NVL2(ct.transaction_currency_code,ct.transaction_currency_code,iuom.unit_of_measure) uom_code ,

cvu.val_unit_code val_unit_code ,

cwo.work_order_number work_order_number

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 ,

cst_cost_distributions ccd,

inv_units_of_measure_vl iuom,

cst_work_orders cwo

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 cpod.external_system_ref_id = to_char(cit.po_distribution_id)

AND cpod.external_system_reference = decode(cit.external_system_reference, 'RCV_INTERNAL', 'FUSION', cit.external_system_reference)

AND cpod.active_flag = 'Y'

AND ccd.transaction_id = ct.transaction_id

AND iuom.uom_code(+) = ct.uom_code

AND ct.cst_work_order_id = cwo.cst_work_order_id(+)