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_NONROUTINES_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 1742: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,

1738: -- modified for perf fix bug# 7442102
1739: CURSOR nr_mel_cdl_csr(p_mel_cdl_header_id IN NUMBER) IS
1740: SELECT UE.unit_effectivity_id
1741: FROM
1742: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1743: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,
1744: --AHL_MEL_CDL_ATA_SEQUENCES SEQ
1745: WHERE
1746: --SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID

Line 1762: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,

1758: -- query to check existence of open NRs for a pc_node_id.
1759: CURSOR nr_pc_node_csr(p_pc_node_id IN NUMBER) IS
1760: SELECT UE.unit_effectivity_id
1761: FROM
1762: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1763: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1764: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR
1765: WHERE
1766: SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID