DBA Data[Home] [Help]

APPS.INV_RESERVATION_AVAIL_PVT dependencies on MTL_PARAMETERS

Line 1622: AND NOT EXISTS (SELECT 1 from mtl_parameters

1618: AND nvl(mr.subinventory_code, '@@@') = nvl(wdd.subinventory, '@@@')
1619: AND nvl(mr.locator_id, -999) = nvl(wdd.locator_id, -999)
1620: AND nvl(mr.lot_number, '@@@') = nvl(wdd.lot_number, '@@@')
1621: )
1622: AND NOT EXISTS (SELECT 1 from mtl_parameters
1623: WHERE organization_id = wdd.organization_id
1624: AND NVL(wms_enabled_flag,'N') = 'Y') --Bug 9036307
1625: GROUP BY wdd.requested_quantity_uom ;
1626: