APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on CSI_ITEM_INSTANCES

Line 468: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI

464:
465: -- To find on the basis of input unit effectivity the related information
466: CURSOR c_info(x_mr_header_id IN NUMBER, x_unit_id IN NUMBER) IS
467: SELECT AUEB.CSI_ITEM_INSTANCE_ID
468: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI
469: WHERE AUEB.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID
470: AND (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
471: AND AUEB.UNIT_EFFECTIVITY_ID = x_unit_id AND AUEB.MR_HEADER_ID = x_mr_header_id;
472:

Line 566: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI

562: SELECT AUEB.CSI_ITEM_INSTANCE_ID,
563: AUEB.CS_INCIDENT_ID,
564: CSI.INV_MASTER_ORGANIZATION_ID,
565: CSI.INVENTORY_ITEM_ID
566: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI
567: WHERE AUEB.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID
568: AND (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
569: AND AUEB.UNIT_EFFECTIVITY_ID = p_unit_id ;
570:

Line 1055: FROM ahl_unit_effectivities_vl aueb, csi_item_instances csi

1051:
1052: -- To find on the basis of input unit effectivity the related information
1053: CURSOR c_info(x_mr_header_id IN NUMBER, x_unit_id IN NUMBER) IS
1054: SELECT aueb.csi_item_instance_id
1055: FROM ahl_unit_effectivities_vl aueb, csi_item_instances csi
1056: WHERE aueb.csi_item_instance_id = csi.instance_id
1057: AND (aueb.status_code IS NULL OR aueb.status_code = 'INIT-DUE')
1058: AND aueb.unit_effectivity_id = x_unit_id
1059: AND aueb.mr_header_id = x_mr_header_id;

Line 1088: FROM csi_item_instances csii, ahl_unit_effectivities_b ue

1084:
1085: --Cursor to fetch instance quantity
1086: CURSOR c_get_instance_qty(p_unit_effectivity IN NUMBER) IS
1087: SELECT csii.quantity, ue.csi_item_instance_id
1088: FROM csi_item_instances csii, ahl_unit_effectivities_b ue
1089: WHERE ue.unit_effectivity_id = p_unit_effectivity
1090: AND csii.instance_id = ue.csi_item_instance_id;
1091:
1092: l_instance_qty NUMBER := 0;