APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 270: FROM AHL_WORKORDER_OPERATIONS

266: IF (p_workorder_id IS NOT NULL AND
267: p_operation_sequence IS NOT NULL) THEN
268: --
269: SELECT workorder_operation_id INTO x_workorder_operation_id
270: FROM AHL_WORKORDER_OPERATIONS
271: WHERE workorder_id = p_workorder_id
272: AND operation_sequence_num = p_operation_sequence;
273: --
274: END IF;

Line 728: FROM ahl_workorder_operations_v

724: CURSOR Get_sch_dates_cur(c_wo_operation_id IN NUMBER,
725: c_req_date IN DATE)
726: IS
727: SELECT 1
728: FROM ahl_workorder_operations_v
729: WHERE workorder_operation_id = c_wo_operation_id
730: AND c_req_date between trunc(scheduled_start_date)
731: and trunc(scheduled_end_date) ;
732: -- TO Get uom code for meaning

Line 748: FROM ahl_workorder_operations

744: --Get operation sequnece
745: CURSOR Get_Operation_Seq_cur(c_operation_id IN NUMBER)
746: IS
747: SELECT operation_sequence_num
748: FROM ahl_workorder_operations
749: WHERE workorder_operation_id = c_operation_id;
750:
751: -- sracha: added for bug# 6802777.
752: -- derive dept. from wip-operations.

Line 2974: AHL_WORKORDER_OPERATIONS AWOP,

2970: AHL_SCHEDULE_MATERIALS ASML,
2971: wip_requirement_operations wipr,
2972: MTL_SYSTEM_ITEMS_VL MSIV,
2973: AHL_VISITS_VL AVST,
2974: AHL_WORKORDER_OPERATIONS AWOP,
2975: -- added for FP bug# 6802777
2976: WIP_OPERATIONS WOP
2977: WHERE
2978: AWOP.WORKORDER_OPERATION_ID = ASML.WORKORDER_OPERATION_ID AND