APPS.AHL_VWP_RULES_PVT dependencies on CSI_ITEM_INSTANCES

Line 395: FROM CSI_ITEM_INSTANCES

391: END IF;
392:
393: IF (p_serial_id IS NOT NULL AND p_item_id IS NOT NULL AND p_org_id IS NOT NULL) THEN
394: SELECT Instance_Id INTO x_serial_id
395: FROM CSI_ITEM_INSTANCES
396: WHERE Instance_Id = p_serial_id AND Inventory_Item_Id = p_item_id AND Inv_Master_Organization_Id = p_org_id
397: AND ACTIVE_START_DATE <= sysdate AND (ACTIVE_END_DATE >= sysdate OR ACTIVE_END_DATE IS NULL);
398: END IF;
399:

Line 402: FROM CSI_ITEM_INSTANCES

398: END IF;
399:
400: IF (p_serial_number IS NOT NULL AND p_item_id IS NOT NULL AND p_org_id IS NOT NULL) THEN
401: SELECT Instance_Id INTO x_serial_id
402: FROM CSI_ITEM_INSTANCES
403: WHERE Serial_Number = p_serial_number AND Inventory_Item_Id = p_item_id AND Inv_Master_Organization_Id = p_org_id
404: AND ACTIVE_START_DATE <= sysdate AND (ACTIVE_END_DATE >= sysdate OR ACTIVE_END_DATE IS NULL);
405: END IF;
406:

Line 1087: FROM CSI_ITEM_INSTANCES

1083:
1084: IF x_instance_id IS NOT NULL THEN
1085: SELECT Inventory_Item_Id, Inv_Master_Organization_Id
1086: INTO x_Item_Id, x_Item_Org_Id
1087: FROM CSI_ITEM_INSTANCES
1088: WHERE Instance_Id = x_instance_id;
1089: ELSE
1090: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');
1091: Fnd_Msg_Pub.ADD;

Line 1950: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI

1946:
1947: -- To find on the basis of input unit effectivity the related information
1948: CURSOR c_info(x_mr_header_id IN NUMBER, x_unit_id IN NUMBER, x_serial_id IN NUMBER) IS
1949: SELECT CSI.INV_MASTER_ORGANIZATION_ID, CSI.INVENTORY_ITEM_ID
1950: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI
1951: WHERE AUEB.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID
1952: AND AUEB.CSI_ITEM_INSTANCE_ID = x_serial_id
1953: AND (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
1954: AND AUEB.UNIT_EFFECTIVITY_ID = x_unit_id