CST_XLA_RESOURCE_TXNS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

RESOURCE_TRANSACTION_ID COST_ORG_ID COST_BOOK_ID WIP_RESOURCE_ID INVENTORY_ITEM_ID INV_ORG_ID CST_WORK_ORDER_ID CST_WORK_ORDER_OPERATION_ID WORK_CENTER_ID WO_OPERATION_RESOURCE_ID RESOURCE_ACTIVITY_CODE BASE_TXN_TYPE_ID BASE_TXN_SOURCE_TYPE_ID COST_PROFILE_ID COST_METHOD_CODE UOM_CODE CST_WO_RESOURCE_TXN_ID TXN_SOURCE_DOC_TYPE TXN_SOURCE_DOC_NUMBER TXN_SOURCE_REF_DOC_TYPE TXN_SOURCE_REF_DOC_NUMBER PROJECT_ID TASK_ID EXPENDITURE_TYPE_ID EXPENDITURE_ITEM_DATE EXPENDITURE_ORGANIZATION_ID WORK_TYPE_ID CONTRACT_ID CONTRACT_LINE_ID FUNDING_ALLOCATION_ID BILLABLE_FLAG CAPITALIZABLE_FLAG CONTEXT_CATEGORY USER_DEF_ATTRIBUTE1 USER_DEF_ATTRIBUTE2 USER_DEF_ATTRIBUTE3 USER_DEF_ATTRIBUTE4 USER_DEF_ATTRIBUTE5 USER_DEF_ATTRIBUTE6 USER_DEF_ATTRIBUTE7 USER_DEF_ATTRIBUTE8 USER_DEF_ATTRIBUTE9 USER_DEF_ATTRIBUTE10 RESERVED_ATTRIBUTE1 RESERVED_ATTRIBUTE2 RESERVED_ATTRIBUTE3 RESERVED_ATTRIBUTE4 RESERVED_ATTRIBUTE5 RESERVED_ATTRIBUTE6 RESERVED_ATTRIBUTE7 RESERVED_ATTRIBUTE8 RESERVED_ATTRIBUTE9 RESERVED_ATTRIBUTE10 PROJECT_NUMBER PROJECT_NAME TASK_NUMBER TASK_NAME EXPENDITURE_TYPE_NAME PROJECT_ATTRIBUTE_CATEGORY PROJECT_ATTRIBUTE1 PROJECT_ATTRIBUTE2 PROJECT_ATTRIBUTE3 PROJECT_ATTRIBUTE4 PROJECT_ATTRIBUTE5 PROJECT_ATTRIBUTE6 PROJECT_ATTRIBUTE7 PROJECT_ATTRIBUTE8 PROJECT_ATTRIBUTE9 PROJECT_ATTRIBUTE10 PROJECT_ATTRIBUTE11 PROJECT_ATTRIBUTE12 PROJECT_ATTRIBUTE13 PROJECT_ATTRIBUTE14 PROJECT_ATTRIBUTE15 PROJECT_ATTRIBUTE16 PROJECT_ATTRIBUTE17 PROJECT_ATTRIBUTE18 PROJECT_ATTRIBUTE19 PROJECT_ATTRIBUTE20 PROJECT_ATTRIBUTE21 PROJECT_ATTRIBUTE22 PROJECT_ATTRIBUTE23 PROJECT_ATTRIBUTE24 PROJECT_ATTRIBUTE25 PROJECT_ATTRIBUTE26 PROJECT_ATTRIBUTE27 PROJECT_ATTRIBUTE28 PROJECT_ATTRIBUTE29 PROJECT_ATTRIBUTE30 PROJECT_ATTRIBUTE31 PROJECT_ATTRIBUTE32 PROJECT_ATTRIBUTE33 PROJECT_ATTRIBUTE34 PROJECT_ATTRIBUTE35 PROJECT_ATTRIBUTE36 PROJECT_ATTRIBUTE37 PROJECT_ATTRIBUTE38 PROJECT_ATTRIBUTE39 PROJECT_ATTRIBUTE40 PROJECT_ATTRIBUTE41 PROJECT_ATTRIBUTE42 PROJECT_ATTRIBUTE43 PROJECT_ATTRIBUTE44 PROJECT_ATTRIBUTE45 PROJECT_ATTRIBUTE46 PROJECT_ATTRIBUTE47 PROJECT_ATTRIBUTE48 PROJECT_ATTRIBUTE49 PROJECT_ATTRIBUTE50 PROJECT_ATTRIBUTE1_NUMBER PROJECT_ATTRIBUTE2_NUMBER PROJECT_ATTRIBUTE3_NUMBER PROJECT_ATTRIBUTE4_NUMBER PROJECT_ATTRIBUTE5_NUMBER PROJECT_ATTRIBUTE6_NUMBER PROJECT_ATTRIBUTE7_NUMBER PROJECT_ATTRIBUTE8_NUMBER PROJECT_ATTRIBUTE9_NUMBER PROJECT_ATTRIBUTE10_NUMBER PROJECT_ATTRIBUTE11_NUMBER PROJECT_ATTRIBUTE12_NUMBER PROJECT_ATTRIBUTE13_NUMBER PROJECT_ATTRIBUTE14_NUMBER PROJECT_ATTRIBUTE15_NUMBER PROJECT_ATTRIBUTE1_DATE PROJECT_ATTRIBUTE2_DATE PROJECT_ATTRIBUTE3_DATE PROJECT_ATTRIBUTE4_DATE PROJECT_ATTRIBUTE5_DATE PROJECT_ATTRIBUTE6_DATE PROJECT_ATTRIBUTE7_DATE PROJECT_ATTRIBUTE8_DATE PROJECT_ATTRIBUTE9_DATE PROJECT_ATTRIBUTE10_DATE PROJECT_ATTRIBUTE11_DATE PROJECT_ATTRIBUTE12_DATE PROJECT_ATTRIBUTE13_DATE PROJECT_ATTRIBUTE14_DATE PROJECT_ATTRIBUTE15_DATE TASK_ATTRIBUTE_CATEGORY TASK_ATTRIBUTE1 TASK_ATTRIBUTE2 TASK_ATTRIBUTE3 TASK_ATTRIBUTE4 TASK_ATTRIBUTE5 TASK_ATTRIBUTE6 TASK_ATTRIBUTE7 TASK_ATTRIBUTE8 TASK_ATTRIBUTE9 TASK_ATTRIBUTE10 TASK_ATTRIBUTE11 TASK_ATTRIBUTE12 TASK_ATTRIBUTE13 TASK_ATTRIBUTE14 TASK_ATTRIBUTE15 PROJECT_EXPENDITURE_ORG_ID PROJECT_OWNING_ORG_ID ASSEMBLY_ASSET_ID

Query

SQL_Statement

SELECT crt.resource_transaction_id resource_transaction_id, crt.cost_org_id cost_org_id, crt.cost_book_id cost_book_id, crt.resource_id wip_resource_id, crt.inventory_item_id inventory_item_id, crt.inventory_organization_id inv_org_id, crt.cst_work_order_id cst_work_order_id, crt.cst_work_order_operation_id cst_work_order_operation_id, crt.work_center_id work_center_id, crt.wo_operation_resource_id wo_operation_resource_id, crt.resource_activity_code resource_activity_code, 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.cst_wo_resource_txn_id cst_wo_resource_txn_id, 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, crt.pjc_project_id project_id, crt.pjc_task_id task_id, crt.pjc_expenditure_type_id expenditure_type_id, crt.pjc_expenditure_item_date expenditure_item_date, crt.pjc_organization_id expenditure_organization_id, crt.pjc_work_type_id work_type_id, crt.pjc_contract_id contract_id, crt.pjc_contract_line_id contract_line_id, crt.pjc_funding_allocation_id funding_allocation_id, crt.pjc_billable_flag billable_flag, crt.pjc_capitalizable_flag capitalizable_flag, crt.pjc_context_category context_category, crt.pjc_user_def_attribute1 user_def_attribute1, crt.pjc_user_def_attribute2 user_def_attribute2, crt.pjc_user_def_attribute3 user_def_attribute3, crt.pjc_user_def_attribute4 user_def_attribute4, crt.pjc_user_def_attribute5 user_def_attribute5, crt.pjc_user_def_attribute6 user_def_attribute6, crt.pjc_user_def_attribute7 user_def_attribute7, crt.pjc_user_def_attribute8 user_def_attribute8, crt.pjc_user_def_attribute9 user_def_attribute9, crt.pjc_user_def_attribute10 user_def_attribute10, crt.pjc_reserved_attribute1 reserved_attribute1, crt.pjc_reserved_attribute2 reserved_attribute2, crt.pjc_reserved_attribute3 reserved_attribute3, crt.pjc_reserved_attribute4 reserved_attribute4, crt.pjc_reserved_attribute5 reserved_attribute5, crt.pjc_reserved_attribute6 reserved_attribute6, crt.pjc_reserved_attribute7 reserved_attribute7, crt.pjc_reserved_attribute8 reserved_attribute8, crt.pjc_reserved_attribute9 reserved_attribute9, crt.pjc_reserved_attribute10 reserved_attribute10, ppa.segment1 project_number, ppa.name project_name, pt.task_number task_number, pt.task_name task_name, pet.expenditure_type_name expenditure_type_name, ppa.attribute_category project_attribute_category, ppa.attribute1 project_attribute1, ppa.attribute2 project_attribute2, ppa.attribute3 project_attribute3, ppa.attribute4 project_attribute4, ppa.attribute5 project_attribute5, ppa.attribute6 project_attribute6, ppa.attribute7 project_attribute7, ppa.attribute8 project_attribute8, ppa.attribute9 project_attribute9, ppa.attribute10 project_attribute10, ppa.attribute11 project_attribute11, ppa.attribute12 project_attribute12, ppa.attribute13 project_attribute13, ppa.attribute14 project_attribute14, ppa.attribute15 project_attribute15, ppa.attribute16 project_attribute16, ppa.attribute17 project_attribute17, ppa.attribute18 project_attribute18, ppa.attribute19 project_attribute19, ppa.attribute20 project_attribute20, ppa.attribute21 project_attribute21, ppa.attribute22 project_attribute22, ppa.attribute23 project_attribute23, ppa.attribute24 project_attribute24, ppa.attribute25 project_attribute25, ppa.attribute26 project_attribute26, ppa.attribute27 project_attribute27, ppa.attribute28 project_attribute28, ppa.attribute29 project_attribute29, ppa.attribute30 project_attribute30, ppa.attribute31 project_attribute31, ppa.attribute32 project_attribute32, ppa.attribute33 project_attribute33, ppa.attribute34 project_attribute34, ppa.attribute35 project_attribute35, ppa.attribute36 project_attribute36, ppa.attribute37 project_attribute37, ppa.attribute38 project_attribute38, ppa.attribute39 project_attribute39, ppa.attribute40 project_attribute40, ppa.attribute41 project_attribute41, ppa.attribute42 project_attribute42, ppa.attribute43 project_attribute43, ppa.attribute44 project_attribute44, ppa.attribute45 project_attribute45, ppa.attribute46 project_attribute46, ppa.attribute47 project_attribute47, ppa.attribute48 project_attribute48, ppa.attribute49 project_attribute49, ppa.attribute50 project_attribute50, ppa.attribute1_number project_attribute1_number, ppa.attribute2_number project_attribute2_number, ppa.attribute3_number project_attribute3_number, ppa.attribute4_number project_attribute4_number, ppa.attribute5_number project_attribute5_number, ppa.attribute6_number project_attribute6_number, ppa.attribute7_number project_attribute7_number, ppa.attribute8_number project_attribute8_number, ppa.attribute9_number project_attribute9_number, ppa.attribute10_number project_attribute10_number, ppa.attribute11_number project_attribute11_number, ppa.attribute12_number project_attribute12_number, ppa.attribute13_number project_attribute13_number, ppa.attribute14_number project_attribute14_number, ppa.attribute15_number project_attribute15_number, ppa.attribute1_date project_attribute1_date, ppa.attribute2_date project_attribute2_date, ppa.attribute3_date project_attribute3_date, ppa.attribute4_date project_attribute4_date, ppa.attribute5_date project_attribute5_date, ppa.attribute6_date project_attribute6_date, ppa.attribute7_date project_attribute7_date, ppa.attribute8_date project_attribute8_date, ppa.attribute9_date project_attribute9_date, ppa.attribute10_date project_attribute10_date, ppa.attribute11_date project_attribute11_date, ppa.attribute12_date project_attribute12_date, ppa.attribute13_date project_attribute13_date, ppa.attribute14_date project_attribute14_date, ppa.attribute15_date project_attribute15_date, pt.attribute_category task_attribute_category, pt.attribute1 task_attribute1, pt.attribute2 task_attribute2, pt.attribute3 task_attribute3, pt.attribute4 task_attribute4, pt.attribute5 task_attribute5, pt.attribute6 task_attribute6, pt.attribute7 task_attribute7, pt.attribute8 task_attribute8, pt.attribute9 task_attribute9, pt.attribute10 task_attribute10, pt.attribute11 task_attribute11, pt.attribute12 task_attribute12, pt.attribute13 task_attribute13, pt.attribute14 task_attribute14, pt.attribute15 task_attribute15, ppa.carrying_out_organization_id project_expenditure_org_id, ppa.org_id project_owning_org_id, case when crt.assembly_asset_id is not null then crt.assembly_asset_id else wo.min_asset_id end assembly_asset_id FROM cst_resource_transactions crt, pjf_tasks_v pt, pjf_projects_all_vl ppa, pjf_exp_types_vl pet, (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 crt.pjc_project_id = ppa.project_id(+) AND crt.pjc_task_id = pt.task_id(+) AND crt.pjc_expenditure_type_id = pet.expenditure_type_id(+) AND crt.cst_work_order_id = wo.cst_work_order_id(+)