APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_EFFECTIVITIES_V

Line 3928: SELECT title from ahl_unit_effectivities_v

3924: --Changes by nsikka for Bug 5324101
3925: --Cursor added to fetch UE Title to be passed as token
3926:
3927: CURSOR ue_title_csr(p_unit_effectivity_id IN NUMBER) IS
3928: SELECT title from ahl_unit_effectivities_v
3929: WHERE UNIT_EFFECTIVITY_ID = p_unit_effectivity_id;
3930:
3931: l_update_flag BOOLEAN := false;
3932: --l_complete_flag BOOLEAN := false; /* commented out as workorder completion is no longer needed. */

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

Line 6161: FROM ahl_unit_effectivities_v UMP

6157: UMP.csi_item_instance_id,
6158: UMP.orig_ue_instance_id,
6159: UMP.counter_id,
6160: UMP.due_counter_value
6161: FROM ahl_unit_effectivities_v UMP
6162: WHERE UMP.unit_effectivity_id = p_unit_effectivity_id;
6163:
6164: ump_rec ump_details_csr%rowtype;
6165: