APPS.INV_UI_ITEM_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 2381: FROM mtl_physical_adjustments

2377: AND NVL(mpit.locator_id, -99999) = NVL(p_locator_id, -99999)
2378: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
2379: AND NVL(mpit.void_flag, 2) = 2
2380: AND (mpit.adjustment_id IN (SELECT adjustment_id
2381: FROM mtl_physical_adjustments
2382: WHERE physical_inventory_id = p_physical_inventory_id
2383: AND organization_id = p_organization_id
2384: AND approval_status IS NULL) OR mpit.adjustment_id IS NULL)--Bug#9772069
2385: /*AND INV_MATERIAL_STATUS_GRP.loc_valid_for_item(p_locator_id,

Line 2452: FROM mtl_physical_adjustments

2448: AND NVL(mpit.locator_id, -99999) = NVL(p_locator_id, -99999)
2449: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
2450: AND NVL(mpit.void_flag, 2) = 2
2451: AND (mpit.adjustment_id IN (SELECT adjustment_id
2452: FROM mtl_physical_adjustments
2453: WHERE physical_inventory_id = p_physical_inventory_id
2454: AND organization_id = p_organization_id
2455: AND approval_status IS NULL) OR mpit.adjustment_id IS NULL)--Bug#9772069
2456: AND msik.inventory_item_id = mcr.inventory_item_id

Line 2510: FROM mtl_physical_adjustments

2506: AND mpit.physical_inventory_id = p_physical_inventory_id
2507: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
2508: AND NVL(mpit.void_flag, 2) = 2
2509: AND mpit.adjustment_id IN (SELECT adjustment_id
2510: FROM mtl_physical_adjustments
2511: WHERE physical_inventory_id = p_physical_inventory_id
2512: AND organization_id = p_organization_id
2513: AND approval_status IS NULL)
2514: ORDER BY UPPER(mir.revision);