DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_SERIAL_NUMBERS_VAL_V

Line 1077: From MTL_SERIAL_NUMBERS_VAL_V

1073: If p_serial_number is not null and p_lot_number is null then
1074: Begin
1075: Select lot_number
1076: into l_lot_number_val
1077: From MTL_SERIAL_NUMBERS_VAL_V
1078: Where current_organization_id = p_organization_id
1079: and current_subinventory_code = p_subinventory_code
1080: and inventory_item_id = p_inventory_item_id
1081: and serial_number = p_serial_number