DBA Data[Home] [Help]

APPS.INV_PHY_INV_LOVS dependencies on DUAL

Line 819: FROM dual;

815: END IF;
816: -- Get the next tag ID for this new record
817: SELECT mtl_physical_inventory_tags_s.nextval
818: INTO l_tag_id
819: FROM dual;
820: IF (l_debug = 1) THEN
821: print_debug('Dynamic tag ID: ' || l_tag_id);
822: END IF;
823:

Line 1547: FROM dual;

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);
1550: END IF;
1551:

Line 2441: FROM dual;

2437: Mydebug(' Start Processing the Implicit Physical Inventory Xfer ');
2438: /*
2439: SELECT mtl_material_transactions_s.nextval
2440: INTO l_transaction_header_id
2441: FROM dual;
2442: */
2443: Mydebug(' l_transaction_header_id ..'||l_transaction_header_id);
2444:
2445:

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')