APPS.AHL_RSV_RESERVATIONS_PVT dependencies on CSI_ITEM_INSTANCES

Line 100: FROM csi_item_instances csi,

96: IS
97: SELECT csi.instance_id,
98: msn.serial_number,
99: csi.inv_subinventory_name subinventory_code
100: FROM csi_item_instances csi,
101: mtl_serial_numbers msn
102: WHERE trunc(sysdate) >= trunc(nvl(CSI.active_start_date,sysdate))
103: AND trunc(sysdate) < trunc(nvl(CSI.active_end_date,sysdate+1))
104: AND msn.current_status = 3 -- inventory

Line 1262: FROM csi_item_instances csi,mtl_serial_numbers msn

1258: **/
1259: CURSOR get_instance_dtls_csr (c_inventory_itme_id IN NUMBER, c_serial_number IN VARCHAR2, c_organization_id IN NUMBER)
1260: IS
1261: SELECT csi.instance_id, msn.serial_number,csi.inv_subinventory_name subinventory_code
1262: FROM csi_item_instances csi,mtl_serial_numbers msn
1263: WHERE csi.inventory_item_id = c_inventory_itme_id
1264: AND csi.serial_number = c_serial_number
1265: AND csi.last_vld_organization_id = c_organization_id
1266: AND csi.inventory_item_id = msn.inventory_item_id;

Line 2304: FROM csi_item_instances

2300: -- AnRaj modified by selecting 2 more fiels, bug#4756288
2301: CURSOR get_subinv_locator(c_serial_number IN VARCHAR2,c_inventory_item_id IN NUMBER)
2302: IS
2303: SELECT inv_subinventory_name,inv_locator_id,inventory_revision,lot_number
2304: FROM csi_item_instances
2305: WHERE serial_number = c_serial_number
2306: AND inventory_item_id = c_inventory_item_id;
2307:
2308: l_subinventory_name csi_item_instances.inv_subinventory_name%TYPE;

Line 2308: l_subinventory_name csi_item_instances.inv_subinventory_name%TYPE;

2304: FROM csi_item_instances
2305: WHERE serial_number = c_serial_number
2306: AND inventory_item_id = c_inventory_item_id;
2307:
2308: l_subinventory_name csi_item_instances.inv_subinventory_name%TYPE;
2309: l_inv_locator_id NUMBER;
2310: -- AnRaj added 2 more variable, bug#4756288
2311: l_revision csi_item_instances.inventory_revision%TYPE;
2312: l_lot_number csi_item_instances.serial_number%TYPE;

Line 2311: l_revision csi_item_instances.inventory_revision%TYPE;

2307:
2308: l_subinventory_name csi_item_instances.inv_subinventory_name%TYPE;
2309: l_inv_locator_id NUMBER;
2310: -- AnRaj added 2 more variable, bug#4756288
2311: l_revision csi_item_instances.inventory_revision%TYPE;
2312: l_lot_number csi_item_instances.serial_number%TYPE;
2313:
2314: BEGIN
2315:

Line 2312: l_lot_number csi_item_instances.serial_number%TYPE;

2308: l_subinventory_name csi_item_instances.inv_subinventory_name%TYPE;
2309: l_inv_locator_id NUMBER;
2310: -- AnRaj added 2 more variable, bug#4756288
2311: l_revision csi_item_instances.inventory_revision%TYPE;
2312: l_lot_number csi_item_instances.serial_number%TYPE;
2313:
2314: BEGIN
2315:
2316: -- Log API exit point