CST_XLA_WIP_MATERIAL_TXNS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
DISTRIBUTION_ID COST_ORG_NAME COST_BOOK_CODE INVENTORY_ORGANIZATION WORK_ORDER_NUMBER OPERATION_SEQUENCE ITEM_NUMBER QUANTITY UOM_CODE TRANSACTION_DATE VAL_UNIT_CODE

Query

SQL_Statement

SELECT DISTINCT ccd.distribution_id ,cco.cost_org_name cost_org_name ,ccb.cost_book_code cost_book_code ,hr.name inventory_organization ,cwo.work_order_number work_order_number ,cwoo.operation_seq_number operation_sequence ,esi.item_number item_number ,ct.quantity quantity ,uom.unit_of_measure uom_code ,ct.transaction_date transaction_date ,vu.val_unit_code val_unit_code from cst_transactions ct ,cst_cost_orgs_v cco ,cst_cost_books_b ccb ,hr_all_organization_units_tl hr ,cst_work_orders cwo ,cst_work_order_operations cwoo ,egp_system_items_vl esi ,inv_units_of_measure_vl uom ,cst_val_units_vl vu ,cst_cost_distributions ccd where ccd.transaction_id = ct.transaction_id and ct.cost_org_id = cco.cost_org_id and ct.cost_book_id = ccb.cost_book_id and ct.inventory_org_id = hr.organization_id and USERENV('LANG') = hr.language and ct.cst_work_order_id = cwo.cst_work_order_id and ct.cst_work_order_operation_id = cwoo.cst_work_order_operation_id and ct.inventory_org_id = esi.organization_id and ct.inventory_item_id = esi.inventory_item_id and ct.val_unit_id = vu.val_unit_id and ct.uom_code = uom.uom_code