APPS.AHL_PP_MATERIALS_PVT dependencies on WIP_OPERATIONS

Line 752: -- derive dept. from wip-operations.

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.
753: CURSOR get_oper_dept(c_wip_entity_id IN NUMBER,
754: c_oper_seq_num IN NUMBER)
755: IS
756: SELECT wo.department_id

Line 757: FROM WIP_OPERATIONS WO

753: CURSOR get_oper_dept(c_wip_entity_id IN NUMBER,
754: c_oper_seq_num IN NUMBER)
755: IS
756: SELECT wo.department_id
757: FROM WIP_OPERATIONS WO
758: WHERE wo.wip_entity_id = c_wip_entity_id
759: AND wo.operation_seq_num = c_oper_seq_num;
760:
761: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MATERIAL_REQST';

Line 2081: AHL_JOB_OPER_MATERIALS_V B, WIP_OPERATIONS WO

2077: A.attribute15,
2078: A.completed_quantity,
2079: A.requested_date old_requested_date -- added to fix bug# 5182334.
2080: FROM AHL_SCHEDULE_MATERIALS A,
2081: AHL_JOB_OPER_MATERIALS_V B, WIP_OPERATIONS WO
2082: WHERE A.SCHEDULED_MATERIAL_ID = B.SCHEDULED_MATERIAL_ID
2083: AND B.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
2084: AND B.OPERATION_SEQUENCE = WO.OPERATION_SEQ_NUM
2085: AND A.SCHEDULED_MATERIAL_ID = c_schedule_material_id

Line 2976: WIP_OPERATIONS WOP

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
2979: AWOS.VISIT_TASK_ID = ASML.VISIT_TASK_ID AND
2980: ASML.VISIT_ID = AVST.VISIT_ID AND