CST_XLA_OPERATION_TXN_COSTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

OPERATION_TRANSACTION_COST_ID COST_ELEMENT_ID EXPENSE_POOL_ID ABSORPTION_TYPE OPERATION_TRANSACTION_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 CST_WO_OPERATION_TXN_ID EXTERNAL_SYSTEM_REFERENCE OPERATION_TXN_EXT_SYS_REF_ID TRANSACTION_UOM_CODE PRIMARY_UOM_CODE WIP_WORK_ORDER_ID WIP_WORK_ORDER_OPERATION_ID OPERATION_TXN_TYPE_CODE FROM_DISPATCH_STATE TO_DISPATCH_STATE

Query

SQL_Statement

SELECT cotc.operation_txn_cost_id operation_transaction_cost_id , cotc.cost_element_id cost_element_id , cotc.expense_pool_id expense_pool_id , cotc.absorption_type absorption_type , cot.operation_transaction_id operation_transaction_id , cot.cost_org_id cost_org_id , cot.cost_book_id cost_book_id , cot.inventory_item_id inventory_item_id , cot.inventory_organization_id inv_org_id , cot.base_txn_type_id base_txn_type_id , cot.base_txn_source_type_id base_txn_source_type_id , cot.cost_profile_id cost_profile_id , cot.primary_uom_code uom_code , cot.txn_source_doc_type txn_source_doc_type , cot.txn_source_doc_number txn_source_doc_number , cot.txn_source_ref_doc_type txn_source_ref_doc_type , cot.txn_source_ref_doc_number txn_source_ref_doc_number , cwot.cst_wo_operation_txn_id cst_wo_operation_txn_id , cwot.external_system_reference external_system_reference , cwot.external_system_ref_id operation_txn_ext_sys_ref_id , cwot.transaction_uom_code transaction_uom_code , cwot.primary_uom_code primary_uom_code , cwot.work_order_id wip_work_order_id , cwot.work_order_operation_id wip_work_order_operation_id , cwot.transaction_type_code operation_txn_type_code , cwot.from_dispatch_state from_dispatch_state , cwot.to_dispatch_state to_dispatch_state FROM cst_operation_txn_costs cotc , cst_operation_transactions cot , cst_wo_operation_txns cwot WHERE cot.operation_transaction_id = cotc.operation_transaction_id AND cwot.cst_wo_operation_txn_id(+) = cot.cst_wo_operation_txn_id