DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on WIP_OPERATION_RESOURCES

Line 6095: WIP_OPERATION_RESOURCES WOR,

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
6099: WHERE BOM.resource_type IN ( 1 , 2 )

Line 6140: WIP_OPERATION_RESOURCES WOR,

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 )
6144: AND BOM.resource_id = WOR.resource_id

Line 8380: WIP_OPERATION_RESOURCES WOR,

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 )
8384: AND BOM.resource_id = WOR.resource_id

Line 10741: FROM WIP_COST_TXN_INTERFACE WIPT,BOM_RESOURCES BOMR, wip_operation_resources WOR

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