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_MEL_CDL_HEADERS

Line 1324: from ahl_mel_cdl_ata_sequences seq, ahl_mel_cdl_headers hdr,

1320: -- get mel/cdl details.
1321: cursor mel_cdl_header_csr (p_ata_sequence_id IN NUMBER)
1322: is
1323: select seq.INSTALLED_NUMBER, seq.DISPATCH_NUMBER, nvl(rc.repair_time,0)
1324: from ahl_mel_cdl_ata_sequences seq, ahl_mel_cdl_headers hdr,
1325: ahl_repair_categories rc
1326: where seq.mel_cdl_header_id = hdr.mel_cdl_header_id
1327: and seq.mel_cdl_ata_sequence_id = p_ata_sequence_id
1328: and nvl(hdr.expired_date, sysdate+1) > sysdate

Line 1852: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR

1848: SELECT UE.unit_effectivity_id
1849: FROM
1850: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1851: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1852: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR
1853: WHERE
1854: SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1855: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1856: AND UE.CS_INCIDENT_ID = CS.INCIDENT_ID

Line 1981: ahl_mel_cdl_headers mel

1977: IS
1978: SELECT * FROM (
1979: select mel.mel_cdl_header_id, mel.version_number, pcn.pc_node_id
1980: from ahl_pc_nodes_b pcn,
1981: ahl_mel_cdl_headers mel
1982: where pcn.pc_node_id = mel.pc_node_id (+) and
1983: --where pcn.pc_node_id = mel.pc_node_id and -- fix for bug# 9775781. Need outer join else nodes with no MEL definition will not be skipped.
1984: mel.mel_cdl_type_code = l_mel_cdl_type_code and
1985: mel.status_code = 'COMPLETE' and