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_PRD_DF_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 4453: FROM AHL_UNIT_EFFECTIVITIES_VL UE

4449: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
4450: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,ATTRIBUTE9,
4451: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,ATTRIBUTE15,
4452: ORIGINATING_WO_ID, ACCOMPLISH_TRIGGER_TYPE, LOOP_CHAIN_SEQ_NUM, START_LC_UE_ID
4453: FROM AHL_UNIT_EFFECTIVITIES_VL UE
4454: WHERE unit_effectivity_id = p_unit_effectivity_id
4455: UNION
4456: SELECT
4457: UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER, CSI_ITEM_INSTANCE_ID, MR_INTERVAL_ID,

Line 4470: FROM AHL_UNIT_EFFECTIVITIES_VL UE

4466: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
4467: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,ATTRIBUTE9,
4468: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,ATTRIBUTE15,
4469: ORIGINATING_WO_ID, ACCOMPLISH_TRIGGER_TYPE, LOOP_CHAIN_SEQ_NUM, START_LC_UE_ID
4470: FROM AHL_UNIT_EFFECTIVITIES_VL UE
4471: WHERE unit_effectivity_id IN
4472: (
4473:
4474: SELECT distinct related_ue_id

Line 5213: FROM AHL_UNIT_EFFECTIVITIES_VL UE

5209: POSITION_PATH_ID, ATA_CODE, UNIT_CONFIG_HEADER_ID,
5210: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
5211: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,ATTRIBUTE9,
5212: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,ATTRIBUTE15
5213: FROM AHL_UNIT_EFFECTIVITIES_VL UE
5214: WHERE unit_effectivity_id = p_unit_effectivity_id;
5215:
5216: CURSOR redundant_deferral_ue_csr(p_unit_effectivity_id IN NUMBER) IS
5217: SELECT UD.unit_deferral_id FROM ahl_unit_deferrals_b UD