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_MR_HEADERS_B

Line 997: FROM ahl_mr_headers_b mr,

993: ahl_routes_v route
994: WHERE r.route_id = res.object_id
995: AND r.mr_header_id IN
996: (SELECT mr.mr_header_id
997: FROM ahl_mr_headers_b mr,
998: ahl_unit_effectivities_b ue
999: WHERE mr.mr_header_id = ue.mr_header_id
1000: AND ue.unit_effectivity_id IN
1001: (SELECT related_ue_id

Line 1040: FROM ahl_mr_headers_b mr,

1036: ahl_routes_v route
1037: WHERE r.route_id = res.object_id
1038: AND r.mr_header_id IN
1039: (SELECT mr.mr_header_id
1040: FROM ahl_mr_headers_b mr,
1041: ahl_ue_simulations ue
1042: WHERE mr.mr_header_id = ue.mr_header_id
1043: AND ue.originator_ue_id = p_grp_ue_id
1044: AND ue.parent_ue_id IS NOT NULL -- Deb: get this logic for chld UEs checked

Line 1083: FROM ahl_mr_headers_b mr,

1079: AND res.object_id = rop.operation_id
1080: AND r.mr_header_id IN
1081: ( -- all mr headers belonging to child UEs
1082: SELECT mr.mr_header_id
1083: FROM ahl_mr_headers_b mr,
1084: ahl_unit_effectivities_b ue
1085: WHERE mr.mr_header_id = ue.mr_header_id
1086: AND ue.unit_effectivity_id IN
1087: (SELECT related_ue_id

Line 1144: FROM ahl_mr_headers_b mr,

1140: AND res.object_id = rop.operation_id
1141: AND r.mr_header_id IN
1142: ( -- all mr headers belonging to child UEs
1143: SELECT mr.mr_header_id
1144: FROM ahl_mr_headers_b mr,
1145: ahl_ue_simulations ue
1146: WHERE mr.mr_header_id = ue.mr_header_id
1147: AND ue.originator_ue_id = p_grp_ue_id
1148: AND ue.parent_ue_id IS NOT NULL

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 2392: FROM ahl_mr_headers_b mr

2388: CURSOR ahl_mr_headers_csr
2389: IS
2390: SELECT mr.mr_header_id,
2391: mr.title
2392: FROM ahl_mr_headers_b mr
2393: WHERE mr_status_code = 'COMPLETE'
2394: AND EXISTS
2395: (SELECT 1
2396: FROM ahl_unit_effectivities_b ueb

Line 2412: FROM ahl_mr_headers_b mr

2408: CURSOR ahl_sim_mr_headers_csr(p_plan_id NUMBER)
2409: IS
2410: SELECT mr.mr_header_id,
2411: mr.title
2412: FROM ahl_mr_headers_b mr
2413: WHERE mr_status_code = 'COMPLETE'
2414: AND EXISTS
2415: (SELECT 1
2416: FROM ahl_ue_simulations ues

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