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

Line 479: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI

475:
476: -- To find on the basis of input unit effectivity the related information
477: CURSOR c_info(x_mr_header_id IN NUMBER, x_unit_id IN NUMBER) IS
478: SELECT AUEB.CSI_ITEM_INSTANCE_ID
479: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI
480: WHERE AUEB.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID
481: AND (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
482: AND AUEB.UNIT_EFFECTIVITY_ID = x_unit_id AND AUEB.MR_HEADER_ID = x_mr_header_id;
483:

Line 492: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB

488: CURSOR c_relation (x_ue_id IN NUMBER) IS
489: SELECT AUR.RELATED_UE_ID "UNIT_ID"
490: FROM AHL_UE_RELATIONSHIPS AUR
491: START WITH AUR.UE_ID IN (SELECT AUEB.unit_effectivity_id
492: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB
493: WHERE (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
494: AND AUEB.unit_effectivity_id = x_ue_id
495: )
496: CONNECT BY PRIOR AUR.RELATED_UE_ID = AUR.UE_ID;

Line 503: FROM ahl_ue_relationships AUR, ahl_unit_effectivities_vl AUEB

499: -- Added by sjayacha for Servie Request Integration
500: -- To check whether any child UE exists
501: CURSOR c_check_child_ue(p_ue_id IN NUMBER) IS
502: SELECT 'X'
503: FROM ahl_ue_relationships AUR, ahl_unit_effectivities_vl AUEB
504: WHERE AUR.ue_id = AUEB.unit_effectivity_id
505: AND (AUEB.status_code IS NULL OR AUEB.status_code = 'INIT-DUE')
506: AND AUR.ue_id = p_ue_id;
507:

Line 512: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB

508: -- To find MR Header Id for any related Sub Unit Effectivity Id
509: -- or for main Unit Effectivity Id
510: CURSOR c_header (x_unit_id IN NUMBER) IS
511: /*SELECT MR_HEADER_ID
512: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB
513: WHERE (STATUS_CODE IS NULL OR STATUS_CODE IN ('INIT-DUE', 'DEFERRED'))
514: AND UNIT_EFFECTIVITY_ID = x_unit_id;*/
515: /* For Bug# 3152532 fix by shbhanda dated 02-Dec-03*/
516: SELECT AUEB.MR_HEADER_ID

Line 517: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, AHL_MR_HEADERS_B AMHB

513: WHERE (STATUS_CODE IS NULL OR STATUS_CODE IN ('INIT-DUE', 'DEFERRED'))
514: AND UNIT_EFFECTIVITY_ID = x_unit_id;*/
515: /* For Bug# 3152532 fix by shbhanda dated 02-Dec-03*/
516: SELECT AUEB.MR_HEADER_ID
517: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, AHL_MR_HEADERS_B AMHB
518: WHERE AUEB.MR_HEADER_ID = AMHB.MR_HEADER_ID
519: AND AMHB.MR_STATUS_CODE = 'COMPLETE'
520: AND AMHB.VERSION_NUMBER IN
521: ( SELECT MAX(VERSION_NUMBER)

Line 568: FROM AHL_UNIT_EFFECTIVITIES_VL

564:
565: CURSOR c_unit_object_type(p_unit_id IN NUMBER)
566: IS
567: SELECT OBJECT_TYPE
568: FROM AHL_UNIT_EFFECTIVITIES_VL
569: WHERE UNIT_EFFECTIVITY_ID = p_unit_id;
570:
571: -- To find the Item Id, Inv Org Id and Serial Number
572: CURSOR c_item_info(p_unit_id IN NUMBER) IS

Line 577: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI

573: SELECT AUEB.CSI_ITEM_INSTANCE_ID,
574: AUEB.CS_INCIDENT_ID,
575: CSI.INV_MASTER_ORGANIZATION_ID,
576: CSI.INVENTORY_ITEM_ID
577: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI
578: WHERE AUEB.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID
579: AND (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
580: AND AUEB.UNIT_EFFECTIVITY_ID = p_unit_id ;
581:

Line 1110: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb

1106: )
1107: IS
1108: CURSOR c_header (x_unit_id IN NUMBER) IS
1109: SELECT aueb.mr_header_id
1110: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb
1111: WHERE aueb.mr_header_id = amhb.mr_header_id
1112: AND amhb.mr_status_code = 'COMPLETE'
1113: AND amhb.version_number IN
1114: (SELECT MAX(version_number)

Line 1129: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb

1125: --SKPATHAK :: Bug 8344789 :: 19-MAY-2009
1126: --Validate status and version of the MR associated to the SR
1127: CURSOR c_validate_mr (x_unit_id IN NUMBER) IS
1128: SELECT 'X'
1129: FROM ahl_unit_effectivities_vl aueb, ahl_mr_headers_b amhb
1130: WHERE aueb.mr_header_id = amhb.mr_header_id
1131: AND aueb.unit_effectivity_id = x_unit_id
1132: AND (amhb.version_number NOT IN
1133: ( SELECT MAX(version_number)

Line 1147: FROM ahl_unit_effectivities_vl aueb, csi_item_instances csi

1143:
1144: -- To find on the basis of input unit effectivity the related information
1145: CURSOR c_info(x_mr_header_id IN NUMBER, x_unit_id IN NUMBER) IS
1146: SELECT aueb.csi_item_instance_id
1147: FROM ahl_unit_effectivities_vl aueb, csi_item_instances csi
1148: WHERE aueb.csi_item_instance_id = csi.instance_id
1149: AND (aueb.status_code IS NULL OR aueb.status_code = 'INIT-DUE')
1150: AND aueb.unit_effectivity_id = x_unit_id
1151: AND aueb.mr_header_id = x_mr_header_id;

Line 1156: ahl_unit_effectivities_vl aueb

1152:
1153: CURSOR c_relation (x_ue_id IN NUMBER) IS
1154: SELECT aur.related_ue_id
1155: FROM ahl_ue_relationships aur,
1156: ahl_unit_effectivities_vl aueb
1157: WHERE aur.ue_id = x_ue_id
1158: AND aur.ue_id = aueb.unit_effectivity_id
1159: AND (aueb.status_code IS NULL OR aueb.status_code = 'INIT-DUE');
1160: c_relation_rec c_relation%ROWTYPE;