APPS.AHL_MATERIALS_GRP dependencies on AHL_SCHEDULE_MATERIALS

Line 77: FROM AHL_SCHEDULE_MATERIALS

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 *
77: FROM AHL_SCHEDULE_MATERIALS
78: WHERE VISIT_TASK_ID = c_visit_task_id
79: -- Fix for bug 13099886: Look at ACTIVE requirements only
80: AND STATUS = 'ACTIVE';
81:

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

Line 383: -- and requested_date in AHL_SCHEDULE_MATERIALS table are different

379: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Inside the loop i = ' || i || ', scheduled_material_id = ' || l_scheduled_material_id);
381: END IF;
382: -- This API updates all the reservation dates, if l_requested_date
383: -- and requested_date in AHL_SCHEDULE_MATERIALS table are different
384: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
385: p_api_version => 1.0,
386: p_init_msg_list => FND_API.G_FALSE,
387: p_commit => FND_API.G_FALSE,

Line 404: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date

400: ELSE
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
404: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date
405: UPDATE AHL_SCHEDULE_MATERIALS
406: SET requested_date = trunc(l_requested_date),
407: last_update_date = sysdate,
408: last_updated_by = fnd_global.user_id,

Line 405: UPDATE AHL_SCHEDULE_MATERIALS

401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
404: -- Now update AHL_SCHEDULE_MATERIALS table with requested_date as l_requested_date
405: UPDATE AHL_SCHEDULE_MATERIALS
406: SET requested_date = trunc(l_requested_date),
407: last_update_date = sysdate,
408: last_updated_by = fnd_global.user_id,
409: last_update_login = fnd_global.login_id

Line 443: UPDATE AHL_SCHEDULE_MATERIALS

439: IF get_matching_sched_mat_id%FOUND THEN
440: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Found Matching Schedule Material Id: ' || l_scheduled_material_id);
442: END IF;
443: UPDATE AHL_SCHEDULE_MATERIALS
444: SET inventory_item_id = p_alt_item_tbl(i).ALTERNATE_ITEM_ID,
445: last_update_date = sysdate,
446: last_updated_by = fnd_global.user_id,
447: last_update_login = fnd_global.login_id