CST_XLA_WO_VARIANCE_COSTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

WO_COST_VARIANCE_ID COST_ELEMENT_ID EXPENSE_POOL_ID ABSORPTION_TYPE WO_UPDATE_EVENT_TXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID INV_ORG_ID BASE_TXN_TYPE_ID BASE_TXN_SOURCE_TYPE_ID COST_PROFILE_ID UOM_CODE TXN_SOURCE_DOC_TYPE TXN_SOURCE_DOC_NUMBER TXN_SOURCE_REF_DOC_TYPE TXN_SOURCE_REF_DOC_NUMBER EXTERNAL_SYSTEM_REFERENCE UPDATE_EVENT_EXT_SYS_REF_ID WIP_WORK_ORDER_ID WO_SYSTEM_STATUS_CODE PRIOR_WO_SYSTEM_STATUS_CODE

Query

SQL_Statement

SELECT cvc.wo_cost_variance_id wo_cost_variance_id , cvc.cost_element_id cost_element_id , null expense_pool_id , null absorption_type , 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.base_txn_type_id base_txn_type_id , uet.base_txn_source_type_id base_txn_source_type_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 , cwo.external_system_reference external_system_reference , cwo.external_system_ref_id update_event_ext_sys_ref_id , cwo.external_system_ref_id wip_work_order_id , uet.wo_system_status_code wo_system_status_code , uet.prior_wo_system_status_code prior_wo_system_status_code FROM cst_wo_cost_variances cvc , cst_wo_update_event_txns uet , cst_work_orders cwo WHERE cvc.wo_update_event_txn_id = uet.wo_update_event_txn_id and cvc.cst_work_order_id = cwo.cst_work_order_id