DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 824: FROM mtl_physical_adjustments

820: AND mpit.inventory_item_id = p_inventory_item_id
821: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
822: AND NVL(mpit.void_flag, 2) = 2
823: AND mpit.adjustment_id IN (SELECT adjustment_id
824: FROM mtl_physical_adjustments
825: WHERE physical_inventory_id = p_physical_inventory_id
826: AND organization_id = p_organization_id
827: AND approval_status IS NULL);
828: END IF;

Line 1532: FROM mtl_physical_adjustments

1528: AND NVL(mpit.locator_id, -99999) = NVL(p_locator_id, -99999)
1529: AND NVL(mpit.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
1530: AND NVL(mpit.void_flag, 2) = 2
1531: AND mpit.adjustment_id IN (SELECT adjustment_id
1532: FROM mtl_physical_adjustments
1533: WHERE physical_inventory_id = p_physical_inventory_id
1534: AND organization_id = p_organization_id
1535: AND approval_status IS NULL);
1536: END IF;