APPS.INV_PHY_INV_LOVS dependencies on MTL_PHYSICAL_ADJUSTMENTS_S

Line 1545: SELECT mtl_physical_adjustments_s.NEXTVAL

1541: END IF;
1542: END IF;
1543:
1544: -- Get a valid adjustment ID for the new record
1545: SELECT mtl_physical_adjustments_s.NEXTVAL
1546: INTO l_adj_id
1547: FROM dual;
1548: IF (l_debug = 1) THEN
1549: print_debug('New adjustment ID: ' || l_adj_id);

Line 2034: l_subinv MTL_PHYSICAL_ADJUSTMENTS.SUBINVENTORY_NAME%TYPE;

2030: l_adjustment_id NUMBER;
2031: l_new_tag VARCHAR2(1);
2032: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2033: /* Added below variables for bug 15926209, start */
2034: l_subinv MTL_PHYSICAL_ADJUSTMENTS.SUBINVENTORY_NAME%TYPE;
2035: l_locator NUMBER;
2036: l_update BOOLEAN;
2037: l_sys_qty NUMBER;
2038: l_sec_sys_qty NUMBER;

Line 2329: l_prev_subinv mtl_physical_adjustments.subinventory_name%TYPE;

2325: l_result NUMBER;
2326: l_proc_msg VARCHAR2(300);
2327: l_first_rec BOOLEAN :=TRUE;
2328: l_prev_lpn_id mtl_physical_adjustments.parent_lpn_id%TYPE;
2329: l_prev_subinv mtl_physical_adjustments.subinventory_name%TYPE;
2330: l_prev_loctor mtl_physical_adjustments.locator_id%TYPE;
2331: l_rec_count NUMBER:=0;
2332: l_adj_id mtl_physical_adjustments.adjustment_id%TYPE;
2333: l_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE;

Line 2604: SELECT mtl_physical_adjustments_s.nextval INTO l_adj_id FROM dual;

2600: End;*/
2601:
2602: ELSE
2603:
2604: SELECT mtl_physical_adjustments_s.nextval INTO l_adj_id FROM dual;
2605:
2606: mydebug(' Creating a new adjustment : '||l_adj_id );
2607:
2608: SELECT NVL(process_enabled_flag, 'N')