APPS.WMS_LPN_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 1190: FROM mtl_physical_adjustments

1186: )
1187: AND NVL(mpit.void_flag, 2) = 2
1188: AND mpit.adjustment_id IN
1189: (SELECT adjustment_id
1190: FROM mtl_physical_adjustments
1191: WHERE physical_inventory_id = p_physical_inventory_id
1192: AND organization_id = p_organization_id
1193: AND approval_status IS NULL);
1194: END IF;

Line 1298: FROM mtl_physical_adjustments

1294: AND NVL(mil.task_id, -1) = NVL(p_task_id, -1))
1295: )
1296: AND mpit.adjustment_id IN
1297: (SELECT adjustment_id
1298: FROM mtl_physical_adjustments
1299: WHERE physical_inventory_id = p_physical_inventory_id
1300: AND organization_id = p_organization_id
1301: AND approval_status IS NULL);
1302: END IF;