CST_XLA_WIP_OPERATION_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 SCRAP_REASON_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 ,cot.primary_quantity quantity ,uom.unit_of_measure uom_code ,cot.transaction_date transaction_date ,cot.reason_code scrap_reason_code from cst_operation_transactions cot ,cst_cost_orgs_v cco ,cst_cost_books_vl 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_cost_distributions ccd where ccd.transaction_id = cot.operation_transaction_id and cot.cost_org_id = cco.cost_org_id and cot.cost_book_id = ccb.cost_book_id and cot.inventory_organization_id = hr.organization_id and USERENV('LANG') = hr.language and cot.cst_work_order_id = cwo.cst_work_order_id and cot.cst_work_order_operation_id = cwoo.cst_work_order_operation_id and cot.inventory_organization_id = esi.organization_id and cot.inventory_item_id = esi.inventory_item_id and cot.primary_uom_code = uom.uom_code