APPS.AHL_VWP_RULES_PVT dependencies on CSI_ITEM_INSTANCES

Line 401: FROM CSI_ITEM_INSTANCES

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

Line 408: FROM CSI_ITEM_INSTANCES

404: END IF;
405:
406: IF (p_serial_number IS NOT NULL AND p_item_id IS NOT NULL AND p_org_id IS NOT NULL) THEN
407: SELECT Instance_Id INTO x_serial_id
408: FROM CSI_ITEM_INSTANCES
409: WHERE Serial_Number = p_serial_number AND Inventory_Item_Id = p_item_id AND Inv_Master_Organization_Id = p_org_id
410: AND ACTIVE_START_DATE <= sysdate AND (ACTIVE_END_DATE >= sysdate OR ACTIVE_END_DATE IS NULL);
411: END IF;
412:

Line 1093: FROM CSI_ITEM_INSTANCES

1089:
1090: IF x_instance_id IS NOT NULL THEN
1091: SELECT Inventory_Item_Id, Inv_Master_Organization_Id
1092: INTO x_Item_Id, x_Item_Org_Id
1093: FROM CSI_ITEM_INSTANCES
1094: WHERE Instance_Id = x_instance_id;
1095: ELSE
1096: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');
1097: Fnd_Msg_Pub.ADD;

Line 2228: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI

2224:
2225: -- To find on the basis of input unit effectivity the related information
2226: CURSOR c_info(x_mr_header_id IN NUMBER, x_unit_id IN NUMBER, x_serial_id IN NUMBER) IS
2227: SELECT CSI.INV_MASTER_ORGANIZATION_ID, CSI.INVENTORY_ITEM_ID
2228: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI
2229: WHERE AUEB.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID
2230: AND AUEB.CSI_ITEM_INSTANCE_ID = x_serial_id
2231: AND (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
2232: AND AUEB.UNIT_EFFECTIVITY_ID = x_unit_id

Line 5271: csi_item_instances CSIS

5267: -- Get the instance numbers which are marked RTS in more than one instance in visit
5268: CURSOR get_vst_violating_inst(c_visit_id NUMBER) IS
5269: SELECT CSIS.instance_number
5270: FROM ahl_visit_tasks_b ATSK,
5271: csi_item_instances CSIS
5272: WHERE ATSK.instance_id = CSIS.instance_id
5273: AND ATSK.status_code = 'PLANNING'
5274: AND ATSK.return_to_supply_flag = 'Y'
5275: AND ATSK.visit_id = c_visit_id

Line 5349: ' csi_item_instances CSIS ' ||

5345:
5346: -- Formulate the query with the tasks obtained
5347: l_query_str := ' SELECT CSIS.instance_number ' ||
5348: ' FROM ahl_visit_tasks_b ATSK, ' ||
5349: ' csi_item_instances CSIS ' ||
5350: ' WHERE ATSK.instance_id = CSIS.instance_id ' ||
5351: ' AND ATSK.return_to_supply_flag = ''Y'' ' ||
5352: ' AND ATSK.status_code = ''PLANNING'' ' ||
5353: ' AND ATSK.visit_task_id IN (' || taskStr || ') ' ||