DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 249: FROM mtl_secondary_inventories

245: AND l_pvt_RQH_rec.destination_subinventory <> FND_API.G_MISS_CHAR) THEN
246: BEGIN
247: SELECT count(secondary_inventory_name)
248: INTO l_count
249: FROM mtl_secondary_inventories
250: WHERE organization_id = nvl(l_pvt_RQH_rec.destination_organization_id, organization_id)
251: AND secondary_inventory_name = l_pvt_RQH_rec.destination_subinventory;
252: IF (l_count <= 0) THEN
253: FND_MESSAGE.SET_NAME ('INV', 'INV-NO SUBINVENTORY RECORD');