eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 12437: FROM ahl_schedule_materials asmt1,

12433: asmt1.requested_quantity,
12434: asmt1.scheduled_quantity,
12435: asmt1.rt_oper_material_id,
12436: asmt1.item_group_id
12437: FROM ahl_schedule_materials asmt1,
12438: ahl_Schedule_materials asmt2
12439: WHERE asmt1.visit_id = asmt2.visit_id
12440: AND asmt1.visit_task_id = asmt2.visit_task_id
12441: AND asmt1.inventory_item_id = asmt2.inventory_item_id

Line 12438: ahl_Schedule_materials asmt2

12434: asmt1.scheduled_quantity,
12435: asmt1.rt_oper_material_id,
12436: asmt1.item_group_id
12437: FROM ahl_schedule_materials asmt1,
12438: ahl_Schedule_materials asmt2
12439: WHERE asmt1.visit_id = asmt2.visit_id
12440: AND asmt1.visit_task_id = asmt2.visit_task_id
12441: AND asmt1.inventory_item_id = asmt2.inventory_item_id
12442: AND NVL(asmt1.operation_code,'X') = NVL(asmt2.operation_code,'X')

Line 12569: 'Updating ahl_schedule_materials with new Material Requirements');

12565:
12566: IF (l_log_statement >= l_log_current_level) THEN
12567: fnd_log.string(l_log_statement,
12568: L_DEBUG_KEY,
12569: 'Updating ahl_schedule_materials with new Material Requirements');
12570: END IF;
12571:
12572: -- Add the requirements into the first record
12573: UPDATE ahl_schedule_materials

Line 12573: UPDATE ahl_schedule_materials

12569: 'Updating ahl_schedule_materials with new Material Requirements');
12570: END IF;
12571:
12572: -- Add the requirements into the first record
12573: UPDATE ahl_schedule_materials
12574: SET scheduled_quantity = NVL(scheduled_quantity,0) + NVL(l_material_reqrs_rec.scheduled_quantity,0),
12575: item_group_id = NVL(item_group_id,l_material_reqrs_rec.item_group_id),
12576: requested_quantity = NVL(requested_quantity,0) + NVL(l_material_reqrs_rec.requested_quantity,0)
12577: WHERE scheduled_material_id = l_scheduled_matrial_id;

Line 12582: 'Deleting the old material requirements from table ahl_schedule_materials ');

12578:
12579: IF (l_log_statement >= l_log_current_level) THEN
12580: fnd_log.string(l_log_statement,
12581: L_DEBUG_KEY,
12582: 'Deleting the old material requirements from table ahl_schedule_materials ');
12583: END IF;
12584:
12585: -- Mark the current row as deleted
12586: UPDATE ahl_Schedule_materials

Line 12586: UPDATE ahl_Schedule_materials

12582: 'Deleting the old material requirements from table ahl_schedule_materials ');
12583: END IF;
12584:
12585: -- Mark the current row as deleted
12586: UPDATE ahl_Schedule_materials
12587: SET status = 'DELETED',requested_quantity = 0
12588: WHERE scheduled_material_id = l_material_reqrs_rec.scheduled_material_id;
12589:
12590: ELSE -- New duplicate inventory item id as material req