DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_LOT_NUMBERS

Line 2112: FROM mtl_lot_numbers

2108: CURSOR lot_validation_cursor IS
2109: SELECT 'Validate Lot'
2110: FROM DUAL
2111: WHERE EXISTS( SELECT 'X'
2112: FROM mtl_lot_numbers
2113: WHERE inventory_item_id = p_content_item_id
2114: AND organization_id = p_organization_id
2115: AND lot_number = p_lot_number);
2116:

Line 2404: FROM mtl_lot_numbers

2400: l_lot.lot_number := p_lot_number;
2401:
2402: SELECT COUNT(*)
2403: INTO l_temp_count
2404: FROM mtl_lot_numbers
2405: WHERE organization_id = p_organization_id
2406: AND lot_number = p_lot_number
2407: AND inventory_item_id = p_content_item_id;
2408: