DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV dependencies on MTL_ITEM_LOCATIONS_KFV

Line 3901: FROM mtl_item_locations_kfv ml

3897:
3898: /* Bug 3017707 - As locators with the same name can exist in two different organizations, added a filter on organization_id */
3899: SELECT NVL(MAX(ml.inventory_location_id), -999)
3900: INTO x_locator_id_record.locator_id
3901: FROM mtl_item_locations_kfv ml
3902: WHERE ml.concatenated_segments = x_locator_id_record.LOCATOR
3903: AND ( ml.disable_date > SYSDATE
3904: OR ml.disable_date IS NULL)
3905: AND NVL(ml.subinventory_code, 'z') = NVL(x_locator_id_record.subinventory, 'z')