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_TREE dependencies on WMS_LICENSE_PLATE_NUMBERS

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

120: --End of ER Changes
121: query_str := 'SELECT mp.organization_id, mp.organization_code ';
122: query_str := query_str || 'from mtl_parameters mp where organization_id in ';
123: query_str := query_str || '(select organization_id ';
124: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
125:
126: IF p_sub_type = 2 THEN
127: query_str := query_str || ' AND lpn_context = 3 ';
128: ELSIF p_prepacked IS NULL THEN

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

1058: query_str := query_str || ' SELECT organization_id from ' || table_required;
1059:
1060: IF p_lpn_from IS NOT NULL
1061: OR p_lpn_to IS NOT NULL THEN
1062: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
1063: query_str := query_str || ' WHERE 1=1 ';
1064:
1065: IF p_sub_type = 2 THEN
1066: query_str := query_str || ' AND lpn_context = 3 ';

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

2220: query_str := query_str || 'SELECT organization_id from ' || table_required;
2221:
2222: IF (p_lpn_from IS NOT NULL
2223: OR p_lpn_to IS NOT NULL) THEN
2224: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
2225: query_str := query_str || ' WHERE 1=1 ';
2226:
2227: IF p_locator_id IS NOT NULL THEN
2228: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

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

2708: --ER(3338592) Changes
2709: AND p_item_description IS NULL THEN
2710: --End of ER Changes
2711: query_str := 'select subinventory_code ';
2712: query_str := query_str || 'FROM wms_license_plate_numbers WHERE 1=1 ';
2713:
2714: -- query_str := query_str || 'AND (lpn_context = 1 or lpn_context=11 ');
2715:
2716: IF p_sub_type = 2 THEN

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

3309: query_str := query_str || 'SELECT subinventory_code from ' || table_required;
3310:
3311: IF p_lpn_from IS NOT NULL
3312: OR p_lpn_to IS NOT NULL THEN
3313: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
3314: query_str := query_str || ' WHERE 1=1 ';
3315:
3316: IF p_locator_id IS NOT NULL THEN
3317: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

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

3752: --ER(3338592) Changes
3753: AND p_item_description IS NULL THEN
3754: --ER(3338592) Changes
3755: query_str := 'SELECT wlpn.locator_id, mil.concatenated_segments ';
3756: query_str := query_str || 'FROM mtl_item_locations_kfv mil, wms_license_plate_numbers wlpn WHERE 1=1 ';
3757: query_str := query_str || 'AND mil.inventory_location_id = wlpn.locator_id ';
3758: query_str := query_str || 'AND mil.organization_id = wlpn.organization_id ';
3759:
3760: IF p_sub_type = 2 THEN

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

4308: query_str := 'SELECT locator_id, locator from ' || table_required;
4309:
4310: IF p_lpn_from IS NOT NULL
4311: OR p_lpn_to IS NOT NULL THEN
4312: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
4313: query_str := query_str || ' WHERE 1=1 ';
4314:
4315: IF p_locator_id IS NOT NULL THEN
4316: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

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

5460: query_str := query_str || 'FROM cst_cost_groups ccg, ' || table_required;
5461:
5462: IF (p_lpn_from IS NOT NULL
5463: OR p_lpn_to IS NOT NULL) THEN
5464: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
5465: query_str := query_str || ' WHERE 1=1 ';
5466:
5467: IF p_locator_id IS NOT NULL THEN
5468: query_str := query_str || 'AND wlpn.locator_id = :loc_id ';

Line 5925: lpn wms_license_plate_numbers.license_plate_number%TYPE;

5921: ) IS
5922: query_str VARCHAR2(10000);
5923: query_hdl NUMBER;
5924: rows_processed NUMBER;
5925: lpn wms_license_plate_numbers.license_plate_number%TYPE;
5926: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
5927: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
5928: item mtl_system_items_kfv.concatenated_segments%TYPE;
5929: i NUMBER := x_tbl_index;

Line 5926: lpn_id wms_license_plate_numbers.lpn_id%TYPE;

5922: query_str VARCHAR2(10000);
5923: query_hdl NUMBER;
5924: rows_processed NUMBER;
5925: lpn wms_license_plate_numbers.license_plate_number%TYPE;
5926: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
5927: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
5928: item mtl_system_items_kfv.concatenated_segments%TYPE;
5929: i NUMBER := x_tbl_index;
5930: j NUMBER := x_node_value;

Line 5927: item_id wms_license_plate_numbers.inventory_item_id%TYPE;

5923: query_hdl NUMBER;
5924: rows_processed NUMBER;
5925: lpn wms_license_plate_numbers.license_plate_number%TYPE;
5926: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
5927: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
5928: item mtl_system_items_kfv.concatenated_segments%TYPE;
5929: i NUMBER := x_tbl_index;
5930: j NUMBER := x_node_value;
5931: is_bind_required BOOLEAN := TRUE;

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

5967: --ER(3338592) Changes
5968:
5969: IF p_parent_lpn_id IS NULL THEN
5970: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
5971: query_str := query_str || ' from wms_license_plate_numbers wln where lpn_id in ';
5972: query_str := query_str || ' (select outermost_lpn_id ';
5973: query_str := query_str || ' FROM wms_license_plate_numbers mol WHERE 1=1 ';
5974:
5975: IF p_sub_type = 2 THEN

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

5969: IF p_parent_lpn_id IS NULL THEN
5970: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
5971: query_str := query_str || ' from wms_license_plate_numbers wln where lpn_id in ';
5972: query_str := query_str || ' (select outermost_lpn_id ';
5973: query_str := query_str || ' FROM wms_license_plate_numbers mol WHERE 1=1 ';
5974:
5975: IF p_sub_type = 2 THEN
5976: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org
5977: IF p_inserted_under_org = 'Y' OR p_inserted_under_org = 'y' THEN

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

6053: query_str := query_str || ') GROUP BY wln.license_plate_number, wln.lpn_id, wln.inventory_item_id ';
6054: query_str := query_str || 'ORDER BY wln.license_plate_number ';
6055: ELSE -- PARENT LPN ID IS NOT NULL -- ELSE FOR IF p_parent_lpn_id IS NULL THEN
6056: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
6057: query_str := query_str || 'from wms_license_plate_numbers mol where 1=1 ';
6058:
6059: IF p_sub_type = 2 THEN
6060: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org
6061: IF p_inserted_under_org = 'Y' OR p_inserted_under_org = 'y' THEN

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

6170: END IF;
6171: END IF;
6172:
6173: query_str := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
6174: query_str := query_str || ' from wms_license_plate_numbers where lpn_id in ';
6175: query_str := query_str || ' (select MOL.outermost_lpn_id ';
6176: query_str := query_str || ' FROM ' || table_required;
6177:
6178: IF p_lpn_from IS NOT NULL

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

6176: query_str := query_str || ' FROM ' || table_required;
6177:
6178: IF p_lpn_from IS NOT NULL
6179: OR p_lpn_to IS NOT NULL THEN
6180: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
6181: query_str := query_str || ' WHERE 1=1 ';
6182:
6183: IF p_sub_type = 2 THEN
6184: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org

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

6435: END IF;
6436: ELSE -- comes here if query criteria contains item serial and parent lpn is there.
6437: -- connect by is delibarately removed from here as it is affecting performance.
6438: -- For details see Material workbech performance hld doc
6439: query_str := query_str || ' select license_plate_number lpn, lpn_id, inventory_item_id from wms_license_plate_numbers ';
6440: query_str := query_str || ' WHERE parent_lpn_id = :plpn_id ';
6441:
6442: IF p_sub_type = 2 THEN
6443: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org

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

7629:
7630: IF (p_lpn_from IS NOT NULL
7631: OR p_lpn_to IS NOT NULL)
7632: AND p_parent_lpn_id IS NULL THEN
7633: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
7634: query_str := query_str || ' WHERE 1=1 ';
7635:
7636: IF p_sub_type = 2 THEN
7637: --Bug#3191526 add the LPNs which don't have any sub/loc association directly after org

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

8871:
8872: IF (p_lpn_from IS NOT NULL
8873: OR p_lpn_to IS NOT NULL)
8874: AND p_parent_lpn_id IS NULL THEN
8875: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
8876: query_str := query_str || ' WHERE 1=1 ';
8877:
8878: IF p_sub_type = 2 THEN
8879: query_str := query_str || ' AND lpn_context = 3 ';

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

9996:
9997: IF (p_lpn_from IS NOT NULL
9998: OR p_lpn_to IS NOT NULL)
9999: AND p_parent_lpn_id IS NULL THEN
10000: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
10001: query_str := query_str || ' WHERE 1=1 ';
10002:
10003: IF p_sub_type = 2 THEN
10004: query_str := query_str || ' AND lpn_context = 3 ';

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

10711:
10712: IF (p_lpn_from IS NOT NULL
10713: OR p_lpn_to IS NOT NULL)
10714: AND p_parent_lpn_id IS NULL THEN
10715: query_str := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
10716: query_str := query_str || ' WHERE 1=1 ';
10717:
10718: IF p_sub_type = 2 THEN
10719: query_str := query_str || ' AND lpn_context = 3 ';