APPS.INV_PHY_INV_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 119: FROM mtl_physical_adjustments

115: AND tag_quantity <> 0
116: AND void_flag = 2
117: AND adjustment_id IN
118: (SELECT adjustment_id
119: FROM mtl_physical_adjustments
120: WHERE physical_inventory_id = p_physical_inventory_id
121: AND organization_id = p_organization_id
122: AND approval_status IS NULL);
123:

Line 206: FROM mtl_physical_adjustments

202: -- AND NVL(cost_group_id, -99999) = NVL(p_cost_group_id, -99999)
203: AND void_flag = 2
204: AND adjustment_id IN
205: (SELECT adjustment_id
206: FROM mtl_physical_adjustments
207: WHERE physical_inventory_id = p_physical_inventory_id
208: AND organization_id = p_organization_id
209: AND approval_status IS NULL);
210: CURSOR discrepant_serial_cursor IS

Line 224: FROM mtl_physical_adjustments

220: -- AND NVL(cost_group_id, -99999) = NVL(p_cost_group_id, -99999)
221: AND void_flag = 2
222: AND adjustment_id IN
223: (SELECT adjustment_id
224: FROM mtl_physical_adjustments
225: WHERE physical_inventory_id = p_physical_inventory_id
226: AND organization_id = p_organization_id
227: AND approval_status IS NULL);
228: tag_record MTL_PHYSICAL_INVENTORY_TAGS%ROWTYPE;

Line 1093: UPDATE mtl_physical_adjustments

1089:
1090: IF (l_debug = 1) THEN
1091: print_debug('Updating the physical adjustment record for adjustment ID: ' || p_adjustment_id);
1092: END IF;
1093: UPDATE mtl_physical_adjustments
1094: SET last_update_date = SYSDATE,
1095: last_updated_by = NVL(p_user_id, -1),
1096: count_quantity = l_adj_count_quantity,
1097: adjustment_quantity = NVL(l_adj_count_quantity, NVL(system_quantity,0))

Line 1113: FROM mtl_physical_adjustments

1109: SELECT inventory_item_id, lot_number, serial_number, parent_lpn_id,
1110: subinventory_name, locator_id, NVL(adjustment_quantity, 0)
1111: INTO l_inventory_item_id, l_lot_number, l_serial_number,
1112: l_lpn_id, l_subinventory, l_locator_id, l_adjustment_quantity
1113: FROM mtl_physical_adjustments
1114: WHERE adjustment_id = p_adjustment_id
1115: AND physical_inventory_id = p_physical_inventory_id
1116: AND organization_id = p_organization_id;
1117:

Line 1265: FROM MTL_PHYSICAL_ADJUSTMENTS

1261: print_debug('Try to find the adjustment ID if it exists');
1262: END IF;
1263: SELECT MIN(ADJUSTMENT_ID)
1264: INTO l_adj_id
1265: FROM MTL_PHYSICAL_ADJUSTMENTS
1266: WHERE ORGANIZATION_ID = p_organization_id
1267: AND PHYSICAL_INVENTORY_ID = p_physical_inventory_id
1268: AND INVENTORY_ITEM_ID = p_inventory_item_id
1269: AND SUBINVENTORY_NAME = p_subinventory

Line 1302: from mtl_physical_adjustments

1298:
1299: IF l_adj_id IS NOT NULL THEN
1300: select approval_status
1301: into l_approval_status
1302: from mtl_physical_adjustments
1303: where adjustment_id = l_adj_id
1304: and physical_inventory_id = p_physical_inventory_id;
1305:
1306: if (nvl(l_approval_status,0) = 3) then

Line 1346: SELECT mtl_physical_adjustments_s.NEXTVAL

1342: l_actual_cost := 0;
1343: END IF;
1344:
1345: -- Get a valid adjustment ID for the new record
1346: SELECT mtl_physical_adjustments_s.NEXTVAL
1347: INTO l_adj_id
1348: FROM dual;
1349: IF (l_debug = 1) THEN
1350: print_debug('New adjustment ID: ' || l_adj_id);

Line 1390: INSERT INTO mtl_physical_adjustments

1386: -- Insert the new adjustment record
1387: IF (l_debug = 1) THEN
1388: print_debug('Inserting the new physical adjustment record');
1389: END IF;
1390: INSERT INTO mtl_physical_adjustments
1391: ( adjustment_id,
1392: organization_id,
1393: physical_inventory_id,
1394: inventory_item_id,