DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_LOT_NUMBERS

Line 2035: FROM mtl_lot_numbers

2031: CURSOR lot_validation_cursor IS
2032: SELECT 'Validate Lot'
2033: FROM DUAL
2034: WHERE EXISTS( SELECT 'X'
2035: FROM mtl_lot_numbers
2036: WHERE inventory_item_id = p_content_item_id
2037: AND organization_id = p_organization_id
2038: AND lot_number = p_lot_number);
2039:

Line 2327: FROM mtl_lot_numbers

2323: l_lot.lot_number := p_lot_number;
2324:
2325: SELECT COUNT(*)
2326: INTO l_temp_count
2327: FROM mtl_lot_numbers
2328: WHERE organization_id = p_organization_id
2329: AND lot_number = p_lot_number
2330: AND inventory_item_id = p_content_item_id;
2331: