APPS.AHL_MATERIALS_GRP dependencies on AHL_WORKORDERS

Line 72: FROM AHL_WORKORDERS WO

68: l_alt_items AHL_LTP_MTL_REQ_PVT.Alt_Items_Tbl_Type;
69:
70: Cursor get_visit_task_id_csr(c_wip_entity_id IN NUMBER) IS
71: SELECT WO.VISIT_TASK_ID
72: FROM AHL_WORKORDERS WO
73: WHERE WIP_ENTITY_ID = c_wip_entity_id;
74:
75: Cursor get_task_mtrls_csr(c_visit_task_id IN NUMBER) IS
76: SELECT *

Line 108: -- From AHL_WORKORDERS, get the visit_task_id for the wip_entity_id

104: -- Initialize API return status to success
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: -- Begin Processing
108: -- From AHL_WORKORDERS, get the visit_task_id for the wip_entity_id
109: OPEN get_visit_task_id_csr(p_wip_entity_id);
110: FETCH get_visit_task_id_csr INTO l_visit_task_id;
111: IF l_visit_task_id IS NOT NULL THEN
112: -- Get all rows from ASM for the given visit task and process them one by one

Line 296: FROM ahl_workorders awo, ahl_schedule_materials asmt

292: -- for which requested date is not equal to WO scheduled start date
293: CURSOR get_scheduled_material_id (c_wip_entity_id IN NUMBER,
294: c_requested_date IN DATE) IS
295: SELECT asmt.scheduled_material_id
296: FROM ahl_workorders awo, ahl_schedule_materials asmt
297: WHERE awo.visit_task_id = asmt.visit_task_id
298: AND awo.wip_entity_id= c_wip_entity_id
299: AND asmt.requested_date <> trunc(c_requested_date)
300: AND asmt.status <> 'DELETED';

Line 308: FROM ahl_workorders awo, ahl_schedule_materials asmt

304: CURSOR get_matching_sched_mat_id(c_wip_entity_id IN NUMBER,
305: c_inventory_item_id IN NUMBER,
306: c_operation_sequence IN NUMBER) IS
307: SELECT asmt.scheduled_material_id
308: FROM ahl_workorders awo, ahl_schedule_materials asmt
309: WHERE awo.wip_entity_id= c_wip_entity_id
310: AND awo.visit_task_id = asmt.visit_task_id
311: AND asmt.inventory_item_id = c_inventory_item_id
312: AND asmt.operation_sequence = c_operation_sequence