[Home] [Help]
6090: WOR.resource_id resource_id,
6091: BOM.resource_type,
6092: WOR.uom_code uom_code,
6093: WOR.usage_rate_or_amount usage_rate_or_amount
6094: FROM BOM_RESOURCES BOM,
6095: WIP_OPERATION_RESOURCES WOR,
6096: AHL_WORKORDER_OPERATIONS WOP,
6097: AHL_WORKORDERS CWO,
6098: WIP_SCHED_RELATIONSHIPS REL
6135: WOR.resource_id resource_id,
6136: BOM.resource_type,
6137: WOR.uom_code uom_code,
6138: WOR.usage_rate_or_amount usage_rate_or_amount
6139: FROM BOM_RESOURCES BOM,
6140: WIP_OPERATION_RESOURCES WOR,
6141: AHL_WORKORDER_OPERATIONS WOP,
6142: AHL_WORKORDERS CWO
6143: WHERE BOM.resource_type IN ( 1 , 2 )
8375: WOR.resource_id resource_id,
8376: BOM.resource_type,
8377: WOR.uom_code uom_code,
8378: WOR.usage_rate_or_amount usage_rate_or_amount
8379: FROM BOM_RESOURCES BOM,
8380: WIP_OPERATION_RESOURCES WOR,
8381: AHL_WORKORDER_OPERATIONS WOP,
8382: AHL_WORKORDERS WO
8383: WHERE BOM.resource_type IN ( 1 , 2 )
10711: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
10712: -- Using the transaction quantity above since we know the
10713: -- transaction uom is in hours
10714: FROM WIP_TRANSACTIONS WIPT,
10715: BOM_RESOURCES BOMR
10716: WHERE WIPT.RESOURCE_ID = BOMR.RESOURCE_ID
10717: AND WIPT.WIP_ENTITY_ID = x_wip_entity_id
10718: AND WIPT.OPERATION_SEQ_NUM = x_operation_seq_num
10719: AND BOMR.RESOURCE_TYPE IN (1,2); -- Person/Machine
10737: x_operation_seq_num NUMBER)
10738: IS
10739: SELECT MIN(WIPT.TRANSACTION_DATE),
10740: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
10741: FROM WIP_COST_TXN_INTERFACE WIPT,BOM_RESOURCES BOMR, wip_operation_resources WOR
10742: WHERE WOR.RESOURCE_ID = BOMR.RESOURCE_ID
10743: AND WOR.RESOURCE_SEQ_NUM = WIPT.RESOURCE_SEQ_NUM
10744: AND WIPT.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
10745: AND WIPT.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM