CST_XLA_WO_VARIANCE_TXNS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
WO_UPDATE_EVENT_TXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID INV_ORG_ID CST_WORK_ORDER_ID BASE_TXN_TYPE_ID BASE_TXN_SOURCE_TYPE_ID BASE_TXN_ACTION_ID COST_PROFILE_ID UOM_CODE TXN_SOURCE_DOC_TYPE TXN_SOURCE_DOC_NUMBER TXN_SOURCE_REF_DOC_TYPE TXN_SOURCE_REF_DOC_NUMBER ASSEMBLY_ASSET_ID

Query

SQL_Statement

SELECT uet.wo_update_event_txn_id wo_update_event_txn_id, uet.cost_org_id cost_org_id, uet.cost_book_id cost_book_id, uet.inventory_item_id inventory_item_id, uet.inventory_organization_id inv_org_id, uet.cst_work_order_id cst_work_order_id, uet.base_txn_type_id base_txn_type_id, uet.base_txn_source_type_id base_txn_source_type_id, uet.base_txn_action_id base_txn_action_id, uet.cost_profile_id cost_profile_id, uet.uom_code uom_code, uet.txn_source_doc_type txn_source_doc_type, uet.txn_source_doc_number txn_source_doc_number, uet.txn_source_ref_doc_type txn_source_ref_doc_type, uet.txn_source_ref_doc_number txn_source_ref_doc_number, wo.min_asset_id assembly_asset_id FROM cst_wo_update_event_txns uet, (select cst_work_order_id, min(asset_id) min_asset_id from cst_work_orders cwo, wie_wo_assets wwa where cwo.external_system_ref_id = wwa.work_order_id group by cst_work_order_id) wo where uet.cst_work_order_id = wo.cst_work_order_id(+)