DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_SERIAL_NUMBERS_VAL_V

Line 1202: From MTL_SERIAL_NUMBERS_VAL_V

1198: If p_serial_number is not null and p_lot_number is null then
1199: Begin
1200: Select lot_number
1201: into l_lot_number_val
1202: From MTL_SERIAL_NUMBERS_VAL_V
1203: Where current_organization_id = p_organization_id
1204: and current_subinventory_code = p_subinventory_code
1205: and inventory_item_id = p_inventory_item_id
1206: and serial_number = p_serial_number