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 CS_INCIDENT_STATUSES_B

Line 1338: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,

1334: --p_cs_incident_id IN NUMBER)
1335: is
1336: select count(ue.cs_incident_id)
1337: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,
1338: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1339: AHL_MEL_CDL_ATA_SEQUENCES SEQ
1340: where SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1341: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1342: AND UE.CS_INCIDENT_ID = CS.INCIDENT_ID

Line 1831: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,

1827: CURSOR nr_mel_cdl_csr(p_mel_cdl_header_id IN NUMBER) IS
1828: SELECT UE.unit_effectivity_id
1829: FROM
1830: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1831: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,
1832: --AHL_MEL_CDL_ATA_SEQUENCES SEQ
1833: WHERE
1834: --SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1835: --AND

Line 1851: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,

1847: CURSOR nr_pc_node_csr(p_pc_node_id IN NUMBER) IS
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