DBA Data[Home] [Help]

APPS.INV_REPLENISH_COUNT_LOVS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 236: FROM mtl_item_locations_kfv milk

232: OPEN x_replenish_count_locator_kff FOR
233: SELECT milk.inventory_location_id
234: , INV_PROJECT.GET_LOCATOR(milk.inventory_location_id, milk.organization_id) -- Bug 6798138
235: , milk.description
236: FROM mtl_item_locations_kfv milk
237: WHERE milk.organization_id = p_organization_id
238: AND milk.subinventory_code = p_subinventory
239: -- AND milk.inventory_location_id = NVL(milk.physical_location_id, milk.inventory_location_id) -- Commented for Bug 6798138
240: AND NVL(milk.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)

Line 312: FROM mtl_item_locations_kfv milk

308: OPEN x_replenish_count_locator_kff FOR
309: SELECT milk.inventory_location_id
310: , INV_PROJECT.GET_LOCSEGS(milk.inventory_location_id, milk.organization_id)
311: , milk.description
312: FROM mtl_item_locations_kfv milk
313: WHERE milk.organization_id = p_organization_id
314: AND milk.subinventory_code = p_subinventory
315: AND milk.inventory_location_id = NVL(milk.physical_location_id, milk.inventory_location_id)
316: AND NVL(milk.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)