APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1369: SELECT 'x' FROM mtl_serial_numbers

1365: WHERE lot_number = p_lot_number
1366: AND inventory_item_id = p_inventory_item_id;
1367:
1368: CURSOR val_serial_number_csr(p_serial_number IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
1369: SELECT 'x' FROM mtl_serial_numbers
1370: WHERE serial_number = p_serial_number
1371: AND inventory_item_id = p_inventory_item_id
1372: UNION
1373: SELECT 'x' FROM csi_item_instances csi

Line 2872: SELECT 'x' FROM mtl_serial_numbers

2868: WHERE lot_number = p_lot_number
2869: AND inventory_item_id = p_inventory_item_id;
2870:
2871: CURSOR val_serial_number_csr(p_serial_number IN VARCHAR2, p_inventory_item_id IN NUMBER) IS
2872: SELECT 'x' FROM mtl_serial_numbers
2873: WHERE serial_number = p_serial_number
2874: AND inventory_item_id = p_inventory_item_id
2875: UNION
2876: SELECT 'x' FROM csi_item_instances csi