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_UE_ORGS_DEPTS_V

Line 1276: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b b, AHL_UE_ORGS_DEPTS_V od

1272: CURSOR child_ue_details(p_parent_ue_id NUMBER)
1273: IS
1274: SELECT ue.unit_effectivity_id, ue.mr_header_id, ue.csi_item_instance_id,
1275: ue.due_date, od.mr_maintenance_org_id maintenance_org_id, od.mr_maintenance_dept_id dept_id, b.down_time
1276: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b b, AHL_UE_ORGS_DEPTS_V od
1277: WHERE ue.unit_effectivity_id IN
1278: (SELECT related_ue_id
1279: FROM ahl_ue_relationships
1280: WHERE originator_ue_id = p_parent_ue_id

Line 1295: FROM ahl_ue_simulations ue, ahl_mr_headers_b b, AHL_UE_ORGS_DEPTS_V od

1291: CURSOR child_ue_details_sim(p_parent_ue_id NUMBER)
1292: IS
1293: SELECT ue.simulation_ue_id, ue.mr_header_id, ue.csi_item_instance_id,
1294: ue.due_date, od.mr_maintenance_org_id maintenance_org_id, od.mr_maintenance_dept_id dept_id, b.down_time
1295: FROM ahl_ue_simulations ue, ahl_mr_headers_b b, AHL_UE_ORGS_DEPTS_V od
1296: WHERE ue.originator_ue_id = p_parent_ue_id
1297: AND ue.parent_ue_id IS NOT NULL
1298: AND ue.mr_header_id IS NOT NULL
1299: AND ue.mr_header_id = b.mr_header_id

Line 2435: FROM AHL_UNIT_EFFECTIVITIES_B UE, CSI_ITEM_INSTANCES II, AHL_MR_HEADERS_B mr, AHL_UE_ORGS_DEPTS_V od

2431: ue.csi_item_instance_id, ue.object_type, ue.defer_from_ue_id,
2432: mr.title title, ue.manually_planned_flag, ii.quantity,
2433: (SELECT 'Y' from ahl_ue_relationships WHERE originator_ue_id = ue.unit_effectivity_id AND ROWNUM < 2) grp_flag,
2434: mr.down_time, mr.uom_code, od.mr_maintenance_org_id maintenance_org_id, od.mr_maintenance_dept_id dept_id, ue.fleet_header_id
2435: FROM AHL_UNIT_EFFECTIVITIES_B UE, CSI_ITEM_INSTANCES II, AHL_MR_HEADERS_B mr, AHL_UE_ORGS_DEPTS_V od
2436: WHERE UE.csi_item_instance_id = II.instance_id
2437: AND UE.mr_header_id = mr.mr_header_id
2438: AND UE.application_usg_code = 'AHL'
2439: AND UE.object_type = 'MR'

Line 2483: FROM AHL_UE_SIMULATIONS UES, CSI_ITEM_INSTANCES II, AHL_MR_HEADERS_B mr, AHL_UE_ORGS_DEPTS_V od

2479: mr.uom_code,
2480: od.MR_MAINTENANCE_ORG_ID maintenance_org_id,
2481: od.MR_MAINTENANCE_DEPT_ID dept_id,
2482: ues.fleet_header_id
2483: FROM AHL_UE_SIMULATIONS UES, CSI_ITEM_INSTANCES II, AHL_MR_HEADERS_B mr, AHL_UE_ORGS_DEPTS_V od
2484: WHERE UES.csi_item_instance_id = II.instance_id
2485: AND UES.mr_header_id = mr.mr_header_id
2486: AND UES.cs_incident_id IS NULL
2487: AND UES.mr_header_id = p_mr_header_id