APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on CSI_ITEM_INSTANCES

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 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 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 1180: FROM csi_item_instances csii, ahl_unit_effectivities_b ue

1176:
1177: --Cursor to fetch instance quantity
1178: CURSOR c_get_instance_qty(p_unit_effectivity IN NUMBER) IS
1179: SELECT csii.quantity, ue.csi_item_instance_id
1180: FROM csi_item_instances csii, ahl_unit_effectivities_b ue
1181: WHERE ue.unit_effectivity_id = p_unit_effectivity
1182: AND csii.instance_id = ue.csi_item_instance_id;
1183:
1184: -- SKPATHAK :: Bug 9971127 :: 13-AUG-2010