APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on WIP_OPERATION_RESOURCES

Line 1142: wip_operation_resources wipor

1138: MIN(wipor.schedule_seq_num)
1139: FROM
1140: ahl_workorder_operations awop,
1141: ahl_workorders awo,
1142: wip_operation_resources wipor
1143: WHERE
1144: awop.operation_sequence_num = wipor.operation_seq_num
1145: AND awo.wip_entity_id = wipor.wip_entity_id
1146: AND awop.workorder_id = awo.workorder_id

Line 3045: WIP_OPERATION_RESOURCES_V WORV

3041: SELECT WORV.* FROM
3042: AHL_OPERATION_RESOURCES AOR,
3043: AHL_WORKORDER_OPERATIONS AWO,
3044: AHL_WORKORDERS AW,
3045: WIP_OPERATION_RESOURCES_V WORV
3046: WHERE WORV.OPERATION_SEQ_NUM = AWO.OPERATION_SEQUENCE_NUM
3047: AND WORV.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
3048: AND WORV.WIP_ENTITY_ID = AW.WIP_ENTITY_ID
3049: AND AW.WORKORDER_ID = AWO.WORKORDER_ID

Line 3364: SELECT * FROM WIP_OPERATION_RESOURCES

3360: CURSOR c_wip_oper_res (c_wip_entity_id IN NUMBER,
3361: c_oper_seq IN NUMBER,
3362: c_res_seq_num IN NUMBER)
3363: IS
3364: SELECT * FROM WIP_OPERATION_RESOURCES
3365: WHERE WIP_ENTITY_ID = c_wip_entity_id
3366: AND OPERATION_SEQ_NUM = c_oper_seq
3367: AND RESOURCE_SEQ_NUM = c_res_seq_num;
3368: