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