CST_XLA_RESOURCE_COSTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

RESOURCE_COST_ID COST_ELEMENT_ID EXPENSE_POOL_ID ABSORPTION_TYPE RESOURCE_TRANSACTION_ID COST_ORG_ID COST_BOOK_ID RESOURCE_ID INVENTORY_ITEM_ID INV_ORG_ID BASE_TXN_TYPE_ID BASE_TXN_SOURCE_TYPE_ID COST_PROFILE_ID COST_METHOD_CODE UOM_CODE TXN_SOURCE_DOC_TYPE TXN_SOURCE_DOC_NUMBER TXN_SOURCE_REF_DOC_TYPE TXN_SOURCE_REF_DOC_NUMBER CST_WO_RESOURCE_TXN_ID EXTERNAL_SYSTEM_REFERENCE RESOURCE_TXN_EXT_SYSTEM_REF_ID TRANSACTION_UOM_CODE PRIMARY_UOM_CODE WIP_WORK_ORDER_ID WIP_WORK_ORDER_OPERATION_ID RESOURCE_BASIS_TYPE RESOURCE_CHARGE_TYPE TRANSACTION_TYPE_CODE

Query

SQL_Statement

SELECT crc.resource_cost_id resource_cost_id , crc.cost_element_id cost_element_id , crc.expense_pool_id expense_pool_id , cast(null as varchar2(30)) absorption_type , crt.resource_transaction_id resource_transaction_id , crt.cost_org_id cost_org_id , crt.cost_book_id cost_book_id , crt.resource_id resource_id , crt.inventory_item_id inventory_item_id , crt.inventory_organization_id inv_org_id , crt.base_txn_type_id base_txn_type_id , crt.base_txn_source_type_id base_txn_source_type_id , crt.cost_profile_id cost_profile_id , crt.cost_method_code cost_method_code , crt.primary_uom_code uom_code , crt.txn_source_doc_type txn_source_doc_type , crt.txn_source_doc_number txn_source_doc_number , crt.txn_source_ref_doc_type txn_source_ref_doc_type , crt.txn_source_ref_doc_number txn_source_ref_doc_number , cwrt.cst_wo_resource_txn_id cst_wo_resource_txn_id , cwrt.external_system_reference external_system_reference , cwrt.external_system_ref_id resource_txn_ext_system_ref_id , cwrt.transaction_uom_code transaction_uom_code , cwrt.primary_uom_code primary_uom_code , cwrt.work_order_id wip_work_order_id , cwrt.work_order_operation_id wip_work_order_operation_id , cwrt.basis_type resource_basis_type , cwrt.charge_type resource_charge_type , cwrt.transaction_type_code transaction_type_code FROM cst_resource_costs crc , cst_resource_transactions crt , cst_wo_resource_txns cwrt WHERE crt.resource_transaction_id = crc.resource_transaction_id AND cwrt.cst_wo_resource_txn_id(+) = crt.cst_wo_resource_txn_id