APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on WIP_OPERATION_RESOURCES

Line 1320: wip_operation_resources wipor

1316: MIN(wipor.schedule_seq_num)
1317: FROM
1318: ahl_workorder_operations awop,
1319: ahl_workorders awo,
1320: wip_operation_resources wipor
1321: WHERE
1322: awop.operation_sequence_num = wipor.operation_seq_num
1323: AND awo.wip_entity_id = wipor.wip_entity_id
1324: AND awop.workorder_id = awo.workorder_id

Line 3264: WIP_OPERATION_RESOURCES WOR,

3260: AOR.RESOURCE_SEQUENCE_NUM,
3261: WOR.START_DATE "SCHEDULED_START_DATE",
3262: WOR.COMPLETION_DATE "SCHEDULED_END_DATE"
3263: FROM AHL_OPERATION_RESOURCES AOR,
3264: WIP_OPERATION_RESOURCES WOR,
3265: AHL_WORKORDER_OPERATIONS AWO ,
3266: AHL_WORKORDERS AWJ
3267: WHERE AOR.RESOURCE_ID = WOR.RESOURCE_ID
3268: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM

Line 3290: WIP_OPERATION_RESOURCES_V WORV

3286: SELECT WORV.* FROM
3287: AHL_OPERATION_RESOURCES AOR,
3288: AHL_WORKORDER_OPERATIONS AWO,
3289: AHL_WORKORDERS AW,
3290: WIP_OPERATION_RESOURCES_V WORV
3291: WHERE WORV.OPERATION_SEQ_NUM = AWO.OPERATION_SEQUENCE_NUM
3292: AND WORV.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
3293: AND WORV.WIP_ENTITY_ID = AW.WIP_ENTITY_ID
3294: AND AW.WORKORDER_ID = AWO.WORKORDER_ID

Line 3609: SELECT * FROM WIP_OPERATION_RESOURCES

3605: CURSOR c_wip_oper_res (c_wip_entity_id IN NUMBER,
3606: c_oper_seq IN NUMBER,
3607: c_res_seq_num IN NUMBER)
3608: IS
3609: SELECT * FROM WIP_OPERATION_RESOURCES
3610: WHERE WIP_ENTITY_ID = c_wip_entity_id
3611: AND OPERATION_SEQ_NUM = c_oper_seq
3612: AND RESOURCE_SEQ_NUM = c_res_seq_num;
3613: