APPS.INV_UI_ITEM_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 2243: FROM mtl_physical_adjustments

2239: AND NVL(mpit.locator_id, -99999) = NVL(p_locator_id, -99999)
2240: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
2241: AND NVL(mpit.void_flag, 2) = 2
2242: AND mpit.adjustment_id IN (SELECT adjustment_id
2243: FROM mtl_physical_adjustments
2244: WHERE physical_inventory_id = p_physical_inventory_id
2245: AND organization_id = p_organization_id
2246: AND approval_status IS NULL)
2247: AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,

Line 2311: FROM mtl_physical_adjustments

2307: AND NVL(mpit.locator_id, -99999) = NVL(p_locator_id, -99999)
2308: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
2309: AND NVL(mpit.void_flag, 2) = 2
2310: AND mpit.adjustment_id IN (SELECT adjustment_id
2311: FROM mtl_physical_adjustments
2312: WHERE physical_inventory_id = p_physical_inventory_id
2313: AND organization_id = p_organization_id
2314: AND approval_status IS NULL)
2315: AND msik.inventory_item_id = mcr.inventory_item_id

Line 2369: FROM mtl_physical_adjustments

2365: AND mpit.physical_inventory_id = p_physical_inventory_id
2366: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
2367: AND NVL(mpit.void_flag, 2) = 2
2368: AND mpit.adjustment_id IN (SELECT adjustment_id
2369: FROM mtl_physical_adjustments
2370: WHERE physical_inventory_id = p_physical_inventory_id
2371: AND organization_id = p_organization_id
2372: AND approval_status IS NULL)
2373: ORDER BY UPPER(mir.revision);