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 25: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;

21: doc_number VARCHAR2(100);
22: doc_header_id NUMBER;
23: i NUMBER := x_tbl_index;
24: j NUMBER := x_node_value;
25: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
26: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
27: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_DOCUMENT_NUMBERS';
28: BEGIN
29: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );

Line 26: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;

22: doc_header_id NUMBER;
23: i NUMBER := x_tbl_index;
24: j NUMBER := x_node_value;
25: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
26: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
27: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_DOCUMENT_NUMBERS';
28: BEGIN
29: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
30:

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

271: AND rsh.asn_type IS NOT NULL ';
272:
273: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
274: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
275: select_str := select_str || ' , wms_license_plate_numbers wlpn ';
276: where_str := where_str ||' AND rsl.asn_lpn_id = wlpn.lpn_id ';
277: END IF;
278:
279: IF inv_mwb_globals.g_vendor_item IS NOT NULL THEN

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

616: AND ms.req_header_id IS NULL ';
617:
618: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
619: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
620: select_str := select_str || ' , wms_license_plate_numbers wlpn ';
621: where_str := where_str ||' AND rsl.asn_lpn_id = wlpn.lpn_id ';
622: END IF;
623:
624: IF inv_mwb_globals.g_vendor_item IS NOT NULL THEN

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

1516: END IF;
1517:
1518: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
1519: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
1520: inb_from_clause := inb_from_clause || ' , wms_license_plate_numbers wlpn ';
1521: inb_where_clause := inb_where_clause ||' AND rsl.asn_lpn_id = wlpn.lpn_id ';
1522: END IF;
1523:
1524: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

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

1658: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
1659: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
1660: inb_from_clause := inb_from_clause || ' , rcv_shipment_lines rsl ';
1661: inb_where_clause := inb_where_clause ||' AND rsl.shipment_line_id = ms.shipment_line_id';
1662: inb_from_clause := inb_from_clause || ' , wms_license_plate_numbers wlpn ';
1663: inb_where_clause := inb_where_clause ||' AND rsl.asn_lpn_id = wlpn.lpn_id ';
1664: END IF;
1665:
1666: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

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

2185:
2186: query_str := 'SELECT mp.organization_id, mp.organization_code ';
2187: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
2188: query_str := query_str || '(select organization_id ';
2189: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
2190:
2191: IF inv_mwb_globals.g_tree_mat_loc_id = 2
2192: OR inv_mwb_globals.g_chk_receiving = 1 THEN
2193: query_str := query_str || ' AND lpn_context = 3 ';

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

3436: query_str := query_str || ' SELECT organization_id from ' || table_required;
3437:
3438: IF inv_mwb_globals.g_lpn_from IS NOT NULL
3439: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
3440: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
3441: query_str := query_str || ' WHERE 1=1 ';
3442:
3443: IF inv_mwb_globals.g_tree_mat_loc_id = 2
3444: OR inv_mwb_globals.g_chk_receiving = 1 THEN

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

4092: --End of ER Changes
4093: query_str := 'SELECT mp.organization_id, mp.organization_code ';
4094: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
4095: query_str := query_str || '(select organization_id ';
4096: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
4097:
4098: IF inv_mwb_globals.g_tree_mat_loc_id = 2
4099: OR inv_mwb_globals.g_chk_receiving = 1 THEN
4100: query_str := query_str || ' AND lpn_context = 3 ';

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

5336: query_str := query_str || ' SELECT organization_id from ' || table_required;
5337:
5338: IF inv_mwb_globals.g_lpn_from IS NOT NULL
5339: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
5340: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
5341: query_str := query_str || ' WHERE 1=1 ';
5342:
5343: IF inv_mwb_globals.g_tree_mat_loc_id = 2
5344: OR inv_mwb_globals.g_chk_receiving = 1 THEN

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

6844: query_str := query_str || 'SELECT organization_id from ' || table_required;
6845:
6846: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
6847: OR inv_mwb_globals.g_lpn_to IS NOT NULL) THEN
6848: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
6849: query_str := query_str || ' WHERE 1=1 ';
6850:
6851: IF inv_mwb_globals.g_locator_id IS NOT NULL THEN
6852: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

Line 7442: 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 ';

7438: --ER(3338592) Changes
7439: AND inv_mwb_globals.g_item_description IS NULL THEN
7440: --End of ER Changes
7441: query_str := 'select wlpn.subinventory_code ';
7442: 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 ';
7443:
7444: -- query_str := query_str || 'AND (lpn_context = 1 or lpn_context=11 ');
7445:
7446: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

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

8442: query_str := query_str || 'SELECT subinventory_code from ' || table_required;
8443:
8444: IF inv_mwb_globals.g_lpn_from IS NOT NULL
8445: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
8446: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
8447: query_str := query_str || ' WHERE 1=1 ';
8448:
8449: IF inv_mwb_globals.g_locator_id IS NOT NULL THEN
8450: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

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

9044: --ER(3338592) Changes
9045: AND inv_mwb_globals.g_item_description IS NULL THEN
9046: --ER(3338592) Changes
9047: query_str := 'SELECT wlpn.locator_id, mil.concatenated_segments ';
9048: query_str := query_str || 'FROM mtl_item_locations_kfv mil, wms_license_plate_numbers wlpn WHERE 1=1 ';
9049: query_str := query_str || 'AND mil.inventory_location_id = wlpn.locator_id ';
9050: query_str := query_str || 'AND mil.organization_id = wlpn.organization_id ';
9051:
9052: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

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

9960: query_str := 'SELECT locator_id, locator from ' || table_required;
9961:
9962: IF inv_mwb_globals.g_lpn_from IS NOT NULL
9963: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
9964: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
9965: query_str := query_str || ' WHERE 1=1 ';
9966:
9967: IF inv_mwb_globals.g_locator_id IS NOT NULL THEN
9968: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

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

11523: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
11524:
11525: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
11526: OR inv_mwb_globals.g_lpn_to IS NOT NULL) THEN
11527: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
11528: query_str := query_str || ' WHERE 1=1 ';
11529:
11530: IF inv_mwb_globals.g_locator_id IS NOT NULL THEN
11531: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

Line 12069: lpn wms_license_plate_numbers.license_plate_number%TYPE;

12065: ) IS
12066: query_str VARCHAR2(8000);
12067: query_hdl NUMBER;
12068: rows_processed NUMBER;
12069: lpn wms_license_plate_numbers.license_plate_number%TYPE;
12070: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
12071: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
12072: item mtl_system_items_kfv.concatenated_segments%TYPE;
12073: select_from_str VARCHAR2(4000);

Line 12070: lpn_id wms_license_plate_numbers.lpn_id%TYPE;

12066: query_str VARCHAR2(8000);
12067: query_hdl NUMBER;
12068: rows_processed NUMBER;
12069: lpn wms_license_plate_numbers.license_plate_number%TYPE;
12070: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
12071: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
12072: item mtl_system_items_kfv.concatenated_segments%TYPE;
12073: select_from_str VARCHAR2(4000);
12074: where_str VARCHAR2(4000);

Line 12071: item_id wms_license_plate_numbers.inventory_item_id%TYPE;

12067: query_hdl NUMBER;
12068: rows_processed NUMBER;
12069: lpn wms_license_plate_numbers.license_plate_number%TYPE;
12070: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
12071: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
12072: item mtl_system_items_kfv.concatenated_segments%TYPE;
12073: select_from_str VARCHAR2(4000);
12074: where_str VARCHAR2(4000);
12075: i NUMBER := x_tbl_index;

Line 12081: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;

12077: is_bind_required BOOLEAN := TRUE;
12078: table_required VARCHAR2(200);
12079: is_grade_t BOOLEAN DEFAULT FALSE; -- NSRIVAST, INVCONV
12080: receipt_source_code VARCHAR2(30);
12081: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
12082: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
12083:
12084: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_LPNS';
12085:

Line 12082: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;

12078: table_required VARCHAR2(200);
12079: is_grade_t BOOLEAN DEFAULT FALSE; -- NSRIVAST, INVCONV
12080: receipt_source_code VARCHAR2(30);
12081: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
12082: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
12083:
12084: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_LPNS';
12085:
12086: l_default_status_id NUMBER; -- LPN Status Project

Line 12114: , wms_license_plate_numbers wlpn ';

12110: ' SELECT DISTINCT wlpn.license_plate_number
12111: , wlpn.lpn_id
12112: FROM rcv_shipment_lines rsl
12113: , mtl_system_items_kfv msik
12114: , wms_license_plate_numbers wlpn ';
12115:
12116: where_str :=
12117: ' WHERE 1 = 1
12118: AND rsl.item_id = msik.inventory_item_id

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

12462: --ER(3338592) Changes
12463:
12464: IF inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
12465: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
12466: query_str := query_str || ' from wms_license_plate_numbers wln where lpn_id in ';
12467: query_str := query_str || ' (select outermost_lpn_id ';
12468: query_str := query_str || ' FROM wms_license_plate_numbers mol WHERE 1=1 ';
12469:
12470: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

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

12464: IF inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
12465: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
12466: query_str := query_str || ' from wms_license_plate_numbers wln where lpn_id in ';
12467: query_str := query_str || ' (select outermost_lpn_id ';
12468: query_str := query_str || ' FROM wms_license_plate_numbers mol WHERE 1=1 ';
12469:
12470: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
12471: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org
12472: IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN

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

12551: query_str := query_str || ') GROUP BY wln.license_plate_number, wln.lpn_id, wln.inventory_item_id ';
12552: query_str := query_str || 'ORDER BY wln.license_plate_number ';
12553: ELSE -- PARENT LPN ID IS NOT NULL -- ELSE FOR IF inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
12554: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
12555: query_str := query_str || 'from wms_license_plate_numbers mol where 1=1 ';
12556:
12557: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
12558: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org
12559: IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN

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

12673: END IF;
12674: END IF;
12675:
12676: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
12677: query_str := query_str || ' from wms_license_plate_numbers where lpn_id in ';
12678: query_str := query_str || ' (select MOL.outermost_lpn_id ';
12679: query_str := query_str || ' FROM ' || table_required;
12680:
12681: IF inv_mwb_globals.g_lpn_from IS NOT NULL

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

12679: query_str := query_str || ' FROM ' || table_required;
12680:
12681: IF inv_mwb_globals.g_lpn_from IS NOT NULL
12682: OR inv_mwb_globals.g_lpn_to IS NOT NULL THEN
12683: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
12684: query_str := query_str || ' WHERE 1=1 ';
12685:
12686: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
12687: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org

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

13019: END IF;
13020: ELSE -- comes here if query criteria contains item serial and parent lpn is there.
13021: -- connect by is delibarately removed from here as it is affecting performance.
13022: -- For details see Material workbech performance hld doc
13023: query_str := query_str || ' select license_plate_number lpn, lpn_id, inventory_item_id from wms_license_plate_numbers ';
13024: query_str := query_str || ' WHERE parent_lpn_id = :plpn_id ';
13025:
13026: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
13027: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org

Line 13312: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;

13308: select_str VARCHAR2(10000) ;
13309: where_str VARCHAR2(10000) ;
13310:
13311: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
13312: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
13313: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
13314:
13315: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_ITEMS';
13316:

Line 13313: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;

13309: where_str VARCHAR2(10000) ;
13310:
13311: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
13312: lpn_from_id wms_license_plate_numbers.lpn_id%TYPE;
13313: lpn_to_id wms_license_plate_numbers.lpn_id%TYPE;
13314:
13315: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_ITEMS';
13316:
13317: l_default_status_id NUMBER; -- Onhand Material Status Support

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

15772:
15773: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
15774: OR inv_mwb_globals.g_lpn_to IS NOT NULL)
15775: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
15776: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
15777: query_str := query_str || ' WHERE 1=1 ';
15778:
15779: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
15780: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org

Line 16443: lpn_from_id wms_license_plate_numbers.lpn_id%type;

16439: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
16440: select_from_str VARCHAR2(1000);
16441: from_str VARCHAR2(1000);
16442: where_str VARCHAR2(3000);
16443: lpn_from_id wms_license_plate_numbers.lpn_id%type;
16444: lpn_to_id wms_license_plate_numbers.lpn_id%type;
16445: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE; -- Bug 6350236
16446:
16447: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_REVS';

Line 16444: lpn_to_id wms_license_plate_numbers.lpn_id%type;

16440: select_from_str VARCHAR2(1000);
16441: from_str VARCHAR2(1000);
16442: where_str VARCHAR2(3000);
16443: lpn_from_id wms_license_plate_numbers.lpn_id%type;
16444: lpn_to_id wms_license_plate_numbers.lpn_id%type;
16445: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE; -- Bug 6350236
16446:
16447: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_REVS';
16448: l_default_status_id NUMBER; -- Onhand Material Status Support

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

17734:
17735: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
17736: OR inv_mwb_globals.g_lpn_to IS NOT NULL)
17737: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
17738: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
17739: query_str := query_str || ' WHERE 1=1 ';
17740:
17741: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
17742: query_str := query_str || ' AND lpn_context = 3 ';

Line 18285: lpn_from_id wms_license_plate_numbers.lpn_id%type;

18281: table_required VARCHAR2(300);
18282: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
18283: select_from_str VARCHAR2(2000);
18284: where_str VARCHAR2(2000);
18285: lpn_from_id wms_license_plate_numbers.lpn_id%type;
18286: lpn_to_id wms_license_plate_numbers.lpn_id%type;
18287: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_LOTS';
18288: l_default_status_id NUMBER; -- Onhand Material Status Support
18289: BEGIN

Line 18286: lpn_to_id wms_license_plate_numbers.lpn_id%type;

18282: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
18283: select_from_str VARCHAR2(2000);
18284: where_str VARCHAR2(2000);
18285: lpn_from_id wms_license_plate_numbers.lpn_id%type;
18286: lpn_to_id wms_license_plate_numbers.lpn_id%type;
18287: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_LOTS';
18288: l_default_status_id NUMBER; -- Onhand Material Status Support
18289: BEGIN
18290: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );

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

19654:
19655: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
19656: OR inv_mwb_globals.g_lpn_to IS NOT NULL)
19657: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
19658: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
19659: query_str := query_str || ' WHERE 1=1 ';
19660:
19661: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
19662: query_str := query_str || ' AND lpn_context = 3 ';

Line 20255: lpn_from_id wms_license_plate_numbers.lpn_id%type;

20251: table_required VARCHAR2(300);
20252: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
20253: select_from_str VARCHAR2(2000);
20254: where_str VARCHAR2(2000);
20255: lpn_from_id wms_license_plate_numbers.lpn_id%type;
20256: lpn_to_id wms_license_plate_numbers.lpn_id%type;
20257: l_default_status_id NUMBER; -- Onhand Material Status Support
20258:
20259: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_SERIAL';

Line 20256: lpn_to_id wms_license_plate_numbers.lpn_id%type;

20252: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV
20253: select_from_str VARCHAR2(2000);
20254: where_str VARCHAR2(2000);
20255: lpn_from_id wms_license_plate_numbers.lpn_id%type;
20256: lpn_to_id wms_license_plate_numbers.lpn_id%type;
20257: l_default_status_id NUMBER; -- Onhand Material Status Support
20258:
20259: l_procedure_name CONSTANT VARCHAR2(30) := 'ADD_SERIAL';
20260: BEGIN

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

20942:
20943: IF (inv_mwb_globals.g_lpn_from IS NOT NULL
20944: OR inv_mwb_globals.g_lpn_to IS NOT NULL)
20945: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL THEN
20946: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
20947: query_str := query_str || ' WHERE 1=1 ';
20948:
20949: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
20950: query_str := query_str || ' AND lpn_context = 3 ';