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 8643: FROM ahl_schedule_materials asmt1,

8639: asmt1.requested_quantity,
8640: asmt1.scheduled_quantity,
8641: asmt1.rt_oper_material_id,
8642: asmt1.item_group_id
8643: FROM ahl_schedule_materials asmt1,
8644: ahl_Schedule_materials asmt2
8645: WHERE asmt1.visit_id = asmt2.visit_id
8646: AND asmt1.visit_task_id = asmt2.visit_task_id
8647: AND asmt1.inventory_item_id = asmt2.inventory_item_id

Line 8644: ahl_Schedule_materials asmt2

8640: asmt1.scheduled_quantity,
8641: asmt1.rt_oper_material_id,
8642: asmt1.item_group_id
8643: FROM ahl_schedule_materials asmt1,
8644: ahl_Schedule_materials asmt2
8645: WHERE asmt1.visit_id = asmt2.visit_id
8646: AND asmt1.visit_task_id = asmt2.visit_task_id
8647: AND asmt1.inventory_item_id = asmt2.inventory_item_id
8648: AND NVL(asmt1.operation_code,'X') = NVL(asmt2.operation_code,'X')

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

8769:
8770: IF (l_log_statement >= l_log_current_level) THEN
8771: fnd_log.string(l_log_statement,
8772: L_DEBUG_KEY,
8773: 'Updating ahl_schedule_materials with new Material Requirements');
8774: END IF;
8775:
8776: -- Add the requirements into the first record
8777: UPDATE ahl_schedule_materials

Line 8777: UPDATE ahl_schedule_materials

8773: 'Updating ahl_schedule_materials with new Material Requirements');
8774: END IF;
8775:
8776: -- Add the requirements into the first record
8777: UPDATE ahl_schedule_materials
8778: SET scheduled_quantity = NVL(scheduled_quantity,0) + NVL(l_material_reqrs_rec.scheduled_quantity,0),
8779: item_group_id = NVL(item_group_id,l_material_reqrs_rec.item_group_id),
8780: requested_quantity = NVL(requested_quantity,0) + NVL(l_material_reqrs_rec.requested_quantity,0)
8781: WHERE scheduled_material_id = l_scheduled_matrial_id;

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

8782:
8783: IF (l_log_statement >= l_log_current_level) THEN
8784: fnd_log.string(l_log_statement,
8785: L_DEBUG_KEY,
8786: 'Deleting the old material requirements from table ahl_schedule_materials ');
8787: END IF;
8788:
8789: -- Mark the current row as deleted
8790: UPDATE ahl_Schedule_materials

Line 8790: UPDATE ahl_Schedule_materials

8786: 'Deleting the old material requirements from table ahl_schedule_materials ');
8787: END IF;
8788:
8789: -- Mark the current row as deleted
8790: UPDATE ahl_Schedule_materials
8791: SET status = 'DELETED',requested_quantity = 0
8792: WHERE scheduled_material_id = l_material_reqrs_rec.scheduled_material_id;
8793:
8794: ELSE -- New duplicate inventory item id as material req