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 CSI_ITEM_INSTANCES

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

Line 2521: FROM AHL_UNIT_EFFECTIVITIES_B UE, CSI_ITEM_INSTANCES II, AHL_FLEET_HEADERS_B flt

2517: ii.quantity,
2518: (SELECT 'Y' from ahl_ue_relationships
2519: where originator_ue_id = ue.unit_effectivity_id and rownum < 2) grp_flag,
2520: flt.operating_org_id maintenance_org_id, flt.department_id dept_id, ue.fleet_header_id
2521: FROM AHL_UNIT_EFFECTIVITIES_B UE, CSI_ITEM_INSTANCES II, AHL_FLEET_HEADERS_B flt
2522: WHERE UE.csi_item_instance_id = II.instance_id
2523: AND UE.APPLICATION_USG_CODE = 'AHL'
2524: AND UE.Object_type = 'SR'-- Deb: When object type is SR then mr_header_id is null. In that case all mr dependent cursor is going to fail
2525: AND (UE.status_code IS NULL OR UE.status_code = 'INIT-DUE')

Line 2563: FROM AHL_UE_SIMULATIONS UES, CSI_ITEM_INSTANCES II, AHL_FLEET_HEADERS_B flt

2559: WHERE unit_effectivity_id = ues.unit_effectivity_id)) manually_planned_flag,
2560: ii.quantity,
2561: (SELECT 'Y' from ahl_ue_simulations WHERE originator_ue_id = ues.simulation_ue_id AND ROWNUM < 2) grp_flag,
2562: flt.operating_org_id maintenance_org_id, flt.department_id dept_id, ues.fleet_header_id
2563: FROM AHL_UE_SIMULATIONS UES, CSI_ITEM_INSTANCES II, AHL_FLEET_HEADERS_B flt
2564: WHERE UES.csi_item_instance_id = II.instance_id
2565: --AND UE.APPLICATION_USG_CODE = 'AHL'
2566: AND UES.cs_incident_id IS NOT NULL-- Deb: When object type is SR them mr_header_id is null. In that case all mr dependent cursor is going to fail
2567: AND (UES.status_code IS NULL OR UES.status_code = 'INIT-DUE')