DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 846: FROM mtl_physical_adjustments

842: AND mpit.inventory_item_id = p_inventory_item_id
843: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
844: AND NVL(mpit.void_flag, 2) = 2
845: AND mpit.adjustment_id IN (SELECT adjustment_id
846: FROM mtl_physical_adjustments
847: WHERE physical_inventory_id = p_physical_inventory_id
848: AND organization_id = p_organization_id
849: AND approval_status IS NULL);
850: END IF;

Line 1556: FROM mtl_physical_adjustments

1552: AND NVL(mpit.locator_id, -99999) = NVL(p_locator_id, -99999)
1553: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
1554: AND NVL(mpit.void_flag, 2) = 2
1555: AND mpit.adjustment_id IN (SELECT adjustment_id
1556: FROM mtl_physical_adjustments
1557: WHERE physical_inventory_id = p_physical_inventory_id
1558: AND organization_id = p_organization_id
1559: AND approval_status IS NULL);
1560: END IF;