APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_LOT_NUMBERS

Line 1520: SELECT 'x' FROM mtl_lot_numbers

1516: WHERE wo.workorder_id = p_workorder_id
1517: AND wo.visit_id = vi.visit_id;
1518:
1519: CURSOR val_lot_number_csr(p_lot_number IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
1520: SELECT 'x' FROM mtl_lot_numbers
1521: WHERE lot_number = p_lot_number
1522: AND inventory_item_id = p_inventory_item_id
1523: UNION
1524: SELECT 'x' FROM csi_item_instances csi

Line 3286: SELECT 'x' FROM mtl_lot_numbers

3282: WHERE serial_number = p_serial_number
3283: AND inventory_item_id = p_inventory_item_id;
3284: ******/
3285: CURSOR val_lot_number_csr(p_lot_number IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
3286: SELECT 'x' FROM mtl_lot_numbers
3287: WHERE lot_number = p_lot_number
3288: AND inventory_item_id = p_inventory_item_id
3289: UNION
3290: SELECT 'x' FROM csi_item_instances csi