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_UMP_BOM_PVT dependencies on AHL_UMP_MATERIAL_REQMNTS

Line 846: INSERT INTO AHL_UMP_MATERIAL_REQMNTS(MAINTENANCE_REQMNT_ID,

842: THEN
843: G_DEBUG_LINE_NUM := l_debug_module||': '||7060;
844: BEGIN
845: FORALL x IN p_x_consolidated_mat_tbl.FIRST..p_x_consolidated_mat_tbl.LAST SAVE EXCEPTIONS
846: INSERT INTO AHL_UMP_MATERIAL_REQMNTS(MAINTENANCE_REQMNT_ID,
847: OBJECT_TYPE,
848: SIMULATION_PLAN_ID,
849: OPERATING_ORG_ID,
850: INVENTORY_ITEM_ID,

Line 2700: DELETE FROM AHL_UMP_MATERIAL_REQMNTS

2696:
2697:
2698:
2699: G_DEBUG_LINE_NUM := l_debug_module||': '||14;
2700: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
2701: WHERE maintenance_reqmnt_id IN
2702: (SELECT maintenance_reqmnt_id
2703: FROM AHL_UMP_MAINT_REQMNTS
2704: WHERE object_type = 'UE'

Line 3058: DELETE FROM AHL_UMP_MATERIAL_REQMNTS

3054: WHERE object_type = 'SIM'
3055: AND simulation_plan_id = l_plan_id_tbl(i));
3056:
3057: G_DEBUG_LINE_NUM := l_debug_module||': '||284;
3058: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
3059: WHERE maintenance_reqmnt_id IN
3060: (SELECT maintenance_reqmnt_id
3061: FROM AHL_UMP_MAINT_REQMNTS
3062: WHERE object_type = 'SIM'

Line 3245: DELETE FROM AHL_UMP_MATERIAL_REQMNTS

3241:
3242:
3243:
3244: G_DEBUG_LINE_NUM := l_debug_module||': '||384;
3245: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
3246: WHERE maintenance_reqmnt_id IN
3247: (SELECT maintenance_reqmnt_id
3248: FROM AHL_UMP_MAINT_REQMNTS
3249: WHERE object_type = 'SIM'

Line 3372: DELETE FROM AHL_UMP_MATERIAL_REQMNTS

3368: WHERE object_type = 'UE'
3369: AND simulation_plan_id = l_plan_id);
3370:
3371: G_DEBUG_LINE_NUM := l_debug_module||': '||472;
3372: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
3373: WHERE maintenance_reqmnt_id IN
3374: (SELECT maintenance_reqmnt_id
3375: FROM AHL_UMP_MAINT_REQMNTS
3376: WHERE object_type = 'UE'

Line 3648: DELETE FROM AHL_UMP_MATERIAL_REQMNTS

3644: AND simulation_plan_id = l_plan_id);
3645:
3646:
3647: G_DEBUG_LINE_NUM := l_debug_module||': '||694;
3648: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
3649: WHERE maintenance_reqmnt_id IN
3650: (SELECT maintenance_reqmnt_id
3651: FROM AHL_UMP_MAINT_REQMNTS
3652: WHERE object_type = 'SIM'