eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MWB_TREE1 dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 34: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;

30: doc_number VARCHAR2(100);
31: doc_header_id NUMBER;
32: i NUMBER := x_tbl_index;
33: j NUMBER := x_node_value;
34: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
35: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
36: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_DOCUMENT_NUMBERS';
37: BEGIN
38: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );

Line 35: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;

31: doc_header_id NUMBER;
32: i NUMBER := x_tbl_index;
33: j NUMBER := x_node_value;
34: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
35: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
36: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_DOCUMENT_NUMBERS';
37: BEGIN
38: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
39:

Line 244: select_str := select_str || ' , wms_license_plate_numbers wlpn ';

240: AND rsh.asn_type IS NOT NULL ';
241:
242: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
243: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
244: select_str := select_str || ' , wms_license_plate_numbers wlpn ';
245: where_str := where_str ||' AND rsl.asn_lpn_id = wlpn.lpn_id ';
246: END IF;
247:
248: IF inv_mwb_globals.g_vendor_item IS NOT NULL THEN

Line 507: select_str := select_str || ' , wms_license_plate_numbers wlpn ';

503: AND ms.req_header_id IS NULL ';
504:
505: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
506: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
507: select_str := select_str || ' , wms_license_plate_numbers wlpn ';
508: where_str := where_str ||' AND rsl.asn_lpn_id = wlpn.lpn_id ';
509: END IF;
510:
511: IF inv_mwb_globals.g_vendor_item IS NOT NULL THEN

Line 1206: inb_from_clause := inb_from_clause || ' , wms_license_plate_numbers wlpn ';

1202: END IF;
1203:
1204: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
1205: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
1206: inb_from_clause := inb_from_clause || ' , wms_license_plate_numbers wlpn ';
1207: inb_where_clause := inb_where_clause ||' AND rsl.asn_lpn_id = wlpn.lpn_id ';
1208: END IF;
1209:
1210: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 1301: inb_from_clause := inb_from_clause || ' , wms_license_plate_numbers wlpn ';

1297: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
1298: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
1299: inb_from_clause := inb_from_clause || ' , rcv_shipment_lines rsl ';
1300: inb_where_clause := inb_where_clause ||' AND rsl.shipment_line_id = ms.shipment_line_id';
1301: inb_from_clause := inb_from_clause || ' , wms_license_plate_numbers wlpn ';
1302: inb_where_clause := inb_where_clause ||' AND rsl.asn_lpn_id = wlpn.lpn_id ';
1303: END IF;
1304:
1305: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 1705: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';

1701:
1702: query_str := 'SELECT mp.organization_id, mp.organization_code ';
1703: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
1704: query_str := query_str || '(select organization_id ';
1705: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
1706:
1707: IF inv_mwb_globals.g_tree_mat_loc_id = 2
1708: OR inv_mwb_globals.g_chk_receiving = 1 THEN
1709: query_str := query_str || ' AND lpn_context = 3 ';

Line 2797: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

2793: query_str := query_str || ' SELECT organization_id from ' || table_required;
2794:
2795: IF inv_mwb_globals.g_lpn_from IS NOT NULL
2796: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
2797: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
2798: query_str := query_str || ' WHERE 1=1 ';
2799:
2800: IF inv_mwb_globals.g_tree_mat_loc_id = 2
2801: OR inv_mwb_globals.g_chk_receiving = 1 THEN

Line 3361: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';

3357: --End of ER Changes
3358: query_str := 'SELECT mp.organization_id, mp.organization_code ';
3359: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
3360: query_str := query_str || '(select organization_id ';
3361: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
3362:
3363: IF inv_mwb_globals.g_tree_mat_loc_id = 2
3364: OR inv_mwb_globals.g_chk_receiving = 1 THEN
3365: query_str := query_str || ' AND lpn_context = 3 ';

Line 4448: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

4444: query_str := query_str || ' SELECT organization_id from ' || table_required;
4445:
4446: IF inv_mwb_globals.g_lpn_from IS NOT NULL
4447: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
4448: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
4449: query_str := query_str || ' WHERE 1=1 ';
4450:
4451: IF inv_mwb_globals.g_tree_mat_loc_id = 2
4452: OR inv_mwb_globals.g_chk_receiving = 1 THEN

Line 5747: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

5743: query_str := query_str || 'SELECT organization_id from ' || table_required;
5744:
5745: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
5746: OR inv_mwb_globals.g_lpn_to IS NOT NULL) THEN
5747: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
5748: query_str := query_str || ' WHERE 1=1 ';
5749:
5750: IF inv_mwb_globals.g_locator_id IS NOT NULL THEN
5751: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

Line 6250: query_str := query_str || 'FROM wms_license_plate_numbers wlpn, mtl_secondary_inventories msi WHERE 1=1 and msi.secondary_inventory_name = wlpn.subinventory_code and wlpn.organization_id = msi.organization_id ';

6246: --ER(3338592) Changes
6247: AND inv_mwb_globals.g_item_description IS NULL THEN
6248: --End of ER Changes
6249: query_str := 'select wlpn.subinventory_code ';
6250: query_str := query_str || 'FROM wms_license_plate_numbers wlpn, mtl_secondary_inventories msi WHERE 1=1 and msi.secondary_inventory_name = wlpn.subinventory_code and wlpn.organization_id = msi.organization_id ';
6251:
6252: -- query_str := query_str || 'AND (lpn_context = 1 or lpn_context=11 ');
6253:
6254: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

Line 7097: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

7093: query_str := query_str || 'SELECT subinventory_code from ' || table_required;
7094:
7095: IF inv_mwb_globals.g_lpn_from IS NOT NULL
7096: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
7097: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
7098: query_str := query_str || ' WHERE 1=1 ';
7099:
7100: IF inv_mwb_globals.g_locator_id IS NOT NULL THEN
7101: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

Line 7608: query_str := query_str || 'FROM mtl_item_locations_kfv mil, wms_license_plate_numbers wlpn WHERE 1=1 ';

7604: --ER(3338592) Changes
7605: AND inv_mwb_globals.g_item_description IS NULL THEN
7606: --ER(3338592) Changes
7607: query_str := 'SELECT wlpn.locator_id, mil.concatenated_segments ';
7608: query_str := query_str || 'FROM mtl_item_locations_kfv mil, wms_license_plate_numbers wlpn WHERE 1=1 ';
7609: query_str := query_str || 'AND mil.inventory_location_id = wlpn.locator_id ';
7610: query_str := query_str || 'AND mil.organization_id = wlpn.organization_id ';
7611:
7612: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

Line 8367: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

8363: query_str := 'SELECT locator_id, locator from ' || table_required;
8364:
8365: IF inv_mwb_globals.g_lpn_from IS NOT NULL
8366: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
8367: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
8368: query_str := query_str || ' WHERE 1=1 ';
8369:
8370: IF inv_mwb_globals.g_locator_id IS NOT NULL THEN
8371: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

Line 9688: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

9684: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
9685:
9686: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
9687: OR inv_mwb_globals.g_lpn_to IS NOT NULL) THEN
9688: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
9689: query_str := query_str || ' WHERE 1=1 ';
9690:
9691: IF inv_mwb_globals.g_locator_id IS NOT NULL THEN
9692: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

Line 10144: lpn wms_license_plate_numbers.license_plate_number%TYPE;

10140: ) IS
10141: query_str VARCHAR2(8000);
10142: query_hdl NUMBER;
10143: rows_processed NUMBER;
10144: lpn wms_license_plate_numbers.license_plate_number%TYPE;
10145: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
10146: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
10147: item mtl_system_items_kfv.concatenated_segments%TYPE;
10148: select_from_str VARCHAR2(4000);

Line 10145: lpn_id wms_license_plate_numbers.lpn_id%TYPE;

10141: query_str VARCHAR2(8000);
10142: query_hdl NUMBER;
10143: rows_processed NUMBER;
10144: lpn wms_license_plate_numbers.license_plate_number%TYPE;
10145: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
10146: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
10147: item mtl_system_items_kfv.concatenated_segments%TYPE;
10148: select_from_str VARCHAR2(4000);
10149: where_str VARCHAR2(4000);

Line 10146: item_id wms_license_plate_numbers.inventory_item_id%TYPE;

10142: query_hdl NUMBER;
10143: rows_processed NUMBER;
10144: lpn wms_license_plate_numbers.license_plate_number%TYPE;
10145: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
10146: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
10147: item mtl_system_items_kfv.concatenated_segments%TYPE;
10148: select_from_str VARCHAR2(4000);
10149: where_str VARCHAR2(4000);
10150: i NUMBER := x_tbl_index;

Line 10156: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;

10152: is_bind_required BOOLEAN := TRUE;
10153: table_required VARCHAR2(200);
10154: is_grade_t BOOLEAN DEFAULT FALSE; -- NSRIVAST, INVCONV
10155: receipt_source_code VARCHAR2(30);
10156: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
10157: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
10158:
10159: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_LPNS';
10160:

Line 10157: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;

10153: table_required VARCHAR2(200);
10154: is_grade_t BOOLEAN DEFAULT FALSE; -- NSRIVAST, INVCONV
10155: receipt_source_code VARCHAR2(30);
10156: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
10157: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
10158:
10159: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_LPNS';
10160:
10161: l_default_status_id NUMBER; -- LPN Status Project

Line 10189: , wms_license_plate_numbers wlpn ';

10185: ' SELECT DISTINCT wlpn.license_plate_number
10186: , wlpn.lpn_id
10187: FROM rcv_shipment_lines rsl
10188: , mtl_system_items_kfv msik
10189: , wms_license_plate_numbers wlpn ';
10190:
10191: where_str :=
10192: ' WHERE 1 = 1
10193: AND rsl.item_id = msik.inventory_item_id

Line 10445: query_str := query_str || ' from wms_license_plate_numbers wln where lpn_id in ';

10441: --ER(3338592) Changes
10442:
10443: IF inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
10444: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
10445: query_str := query_str || ' from wms_license_plate_numbers wln where lpn_id in ';
10446: query_str := query_str || ' (select outermost_lpn_id ';
10447: query_str := query_str || ' FROM wms_license_plate_numbers mol WHERE 1=1 ';
10448:
10449: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

Line 10447: query_str := query_str || ' FROM wms_license_plate_numbers mol WHERE 1=1 ';

10443: IF inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
10444: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
10445: query_str := query_str || ' from wms_license_plate_numbers wln where lpn_id in ';
10446: query_str := query_str || ' (select outermost_lpn_id ';
10447: query_str := query_str || ' FROM wms_license_plate_numbers mol WHERE 1=1 ';
10448:
10449: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
10450: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org
10451: IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN

Line 10534: query_str := query_str || 'from wms_license_plate_numbers mol where 1=1 ';

10530: query_str := query_str || ') GROUP BY wln.license_plate_number, wln.lpn_id, wln.inventory_item_id ';
10531: query_str := query_str || 'ORDER BY wln.license_plate_number ';
10532: ELSE -- PARENT LPN ID IS NOT NULL -- ELSE FOR IF inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
10533: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
10534: query_str := query_str || 'from wms_license_plate_numbers mol where 1=1 ';
10535:
10536: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
10537: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org
10538: IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN

Line 10656: query_str := query_str || ' from wms_license_plate_numbers where lpn_id in ';

10652: END IF;
10653: END IF;
10654:
10655: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
10656: query_str := query_str || ' from wms_license_plate_numbers where lpn_id in ';
10657: query_str := query_str || ' (select MOL.outermost_lpn_id ';
10658: query_str := query_str || ' FROM ' || table_required;
10659:
10660: IF inv_mwb_globals.g_lpn_from IS NOT NULL

Line 10662: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

10658: query_str := query_str || ' FROM ' || table_required;
10659:
10660: IF inv_mwb_globals.g_lpn_from IS NOT NULL
10661: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
10662: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
10663: query_str := query_str || ' WHERE 1=1 ';
10664:
10665: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
10666: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org

Line 10948: query_str := query_str || ' select license_plate_number lpn, lpn_id, inventory_item_id from wms_license_plate_numbers ';

10944: END IF;
10945: ELSE -- comes here if query criteria contains item serial and parent lpn is there.
10946: -- connect by is delibarately removed from here as it is affecting performance.
10947: -- For details see Material workbech performance hld doc
10948: query_str := query_str || ' select license_plate_number lpn, lpn_id, inventory_item_id from wms_license_plate_numbers ';
10949: query_str := query_str || ' WHERE parent_lpn_id = :plpn_id ';
10950:
10951: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
10952: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org

Line 11205: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;

11201: select_str VARCHAR2(10000) ;
11202: where_str VARCHAR2(10000) ;
11203:
11204: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
11205: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
11206: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
11207:
11208: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_ITEMS';
11209:

Line 11206: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;

11202: where_str VARCHAR2(10000) ;
11203:
11204: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
11205: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
11206: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
11207:
11208: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_ITEMS';
11209:
11210: l_default_status_id NUMBER; -- Onhand Material Status Support

Line 13241: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

13237:
13238: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
13239: OR inv_mwb_globals.g_lpn_to IS NOT NULL)
13240: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
13241: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
13242: query_str := query_str || ' WHERE 1=1 ';
13243:
13244: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
13245: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org

Line 13817: lpn_from_id wms_license_plate_numbers.lpn_id%type;

13813: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
13814: select_from_str VARCHAR2(1000);
13815: from_str VARCHAR2(1000);
13816: where_str VARCHAR2(3000);
13817: lpn_from_id wms_license_plate_numbers.lpn_id%type;
13818: lpn_to_id wms_license_plate_numbers.lpn_id%type;
13819: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE; -- Bug 6350236
13820:
13821: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_REVS';

Line 13818: lpn_to_id wms_license_plate_numbers.lpn_id%type;

13814: select_from_str VARCHAR2(1000);
13815: from_str VARCHAR2(1000);
13816: where_str VARCHAR2(3000);
13817: lpn_from_id wms_license_plate_numbers.lpn_id%type;
13818: lpn_to_id wms_license_plate_numbers.lpn_id%type;
13819: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE; -- Bug 6350236
13820:
13821: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_REVS';
13822: l_default_status_id NUMBER; -- Onhand Material Status Support

Line 14876: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

14872:
14873: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
14874: OR inv_mwb_globals.g_lpn_to IS NOT NULL)
14875: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
14876: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
14877: query_str := query_str || ' WHERE 1=1 ';
14878:
14879: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
14880: query_str := query_str || ' AND lpn_context = 3 ';

Line 15337: lpn_from_id wms_license_plate_numbers.lpn_id%type;

15333: table_required VARCHAR2(300);
15334: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
15335: select_from_str VARCHAR2(2000);
15336: where_str VARCHAR2(2000);
15337: lpn_from_id wms_license_plate_numbers.lpn_id%type;
15338: lpn_to_id wms_license_plate_numbers.lpn_id%type;
15339: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_LOTS';
15340: l_default_status_id NUMBER; -- Onhand Material Status Support
15341: BEGIN

Line 15338: lpn_to_id wms_license_plate_numbers.lpn_id%type;

15334: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
15335: select_from_str VARCHAR2(2000);
15336: where_str VARCHAR2(2000);
15337: lpn_from_id wms_license_plate_numbers.lpn_id%type;
15338: lpn_to_id wms_license_plate_numbers.lpn_id%type;
15339: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_LOTS';
15340: l_default_status_id NUMBER; -- Onhand Material Status Support
15341: BEGIN
15342: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );

Line 16474: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

16470:
16471: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
16472: OR inv_mwb_globals.g_lpn_to IS NOT NULL)
16473: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
16474: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
16475: query_str := query_str || ' WHERE 1=1 ';
16476:
16477: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
16478: query_str := query_str || ' AND lpn_context = 3 ';

Line 16985: lpn_from_id wms_license_plate_numbers.lpn_id%type;

16981: table_required VARCHAR2(300);
16982: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
16983: select_from_str VARCHAR2(2000);
16984: where_str VARCHAR2(2000);
16985: lpn_from_id wms_license_plate_numbers.lpn_id%type;
16986: lpn_to_id wms_license_plate_numbers.lpn_id%type;
16987: l_default_status_id NUMBER; -- Onhand Material Status Support
16988:
16989: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_SERIAL';

Line 16986: lpn_to_id wms_license_plate_numbers.lpn_id%type;

16982: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
16983: select_from_str VARCHAR2(2000);
16984: where_str VARCHAR2(2000);
16985: lpn_from_id wms_license_plate_numbers.lpn_id%type;
16986: lpn_to_id wms_license_plate_numbers.lpn_id%type;
16987: l_default_status_id NUMBER; -- Onhand Material Status Support
16988:
16989: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_SERIAL';
16990: BEGIN

Line 17541: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';

17537:
17538: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
17539: OR inv_mwb_globals.g_lpn_to IS NOT NULL)
17540: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
17541: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
17542: query_str := query_str || ' WHERE 1=1 ';
17543:
17544: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
17545: query_str := query_str || ' AND lpn_context = 3 ';