CST_XLA_WIP_RESOURCE_TXNS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
DISTRIBUTION_ID COST_ORG_NAME COST_BOOK_CODE INVENTORY_ORGANIZATION WORK_ORDER_NUMBER OPERATION_SEQUENCE WIP_RESOURCE_NAME QUANTITY UOM_CODE TRANSACTION_DATE TRANSACTION_TYPE_NAME

Query

SQL_Statement

SELECT DISTINCT ccd.distribution_id distribution_id ,cco.cost_org_name cost_org_name ,ccb.cost_book_code cost_book_code ,hr.name inventory_organization ,cwo.work_order_number work_order_number ,cwoo.operation_seq_number operation_sequence ,wwr.resource_name wip_resource_name ,crt.primary_quantity quantity ,uom.unit_of_measure uom_code ,crt.transaction_date transaction_date ,catv.base_txn_type_name transaction_type_name from cst_resource_transactions crt ,cst_cost_orgs_v cco ,cst_cost_books_b ccb ,hr_all_organization_units_tl hr ,cst_work_orders cwo ,cst_work_order_operations cwoo ,wis_resources_vl wwr ,inv_units_of_measure_vl uom ,cst_cost_distributions ccd ,cst_all_txn_types_v catv where ccd.transaction_id = crt.resource_transaction_id and crt.cost_org_id = cco.cost_org_id and crt.cost_book_id = ccb.cost_book_id and crt.inventory_organization_id = hr.organization_id and userenv('LANG') = hr.language and crt.cst_work_order_id = cwo.cst_work_order_id and crt.cst_work_order_operation_id = cwoo.cst_work_order_operation_id and crt.base_txn_source_type_id = catv.base_txn_source_type_id and crt.base_txn_type_id = catv.base_txn_type_id and crt.base_txn_action_id = catv.base_txn_action_id and crt.primary_uom_code = uom.uom_code and wwr.resource_id=crt.resource_id