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.WMS_TASK_LOAD dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1147: UPDATE wms_license_plate_numbers

1143: WHERE transaction_temp_id = p_transaction_temp_id1
1144: returning lpn_id INTO l_lpn_id;
1145:
1146: -- Bug5659809: update last_update_date and last_update_by as well
1147: UPDATE wms_license_plate_numbers
1148: SET lpn_context = 1
1149: --, last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
1150: --, last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
1151: WHERE lpn_id = l_lpn_id;

Line 1424: UPDATE wms_license_plate_numbers

1420: instead of INTO LPN) then do not change the context of the LPN to packing.
1421: TM needs it to be 'resides in inv' to be able to unpack the material */
1422: BEGIN
1423: -- Bug5659809: update last_update_date and last_update_by as well
1424: UPDATE wms_license_plate_numbers
1425: SET lpn_context = l_lpn_context_packing
1426: ,catch_weight_flag = NULL --16466288
1427: -- , last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
1428: -- , last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */

Line 1450: UPDATE wms_license_plate_numbers

1446: END IF;
1447: ELSIF (p_lpn_match = 4 AND l_transfer_lpn_id = l_lpn_match_lpn_id) THEN --added following so that lpn context is updated properly after load bug 12595055 OR (l_lpn_id = l_lpn_match_lpn_id))
1448: mydebug ('Coming to the elseif portion with lpn match values as ' || p_lpn_match );
1449: BEGIN
1450: UPDATE wms_license_plate_numbers
1451: SET lpn_context = l_lpn_context_packing
1452: ,catch_weight_flag = NULL --16466288
1453: WHERE lpn_id = l_lpn_match_lpn_id
1454: AND lpn_context = l_lpn_context_inv --, l_transfer_lpn_id)

Line 1484: UPDATE wms_license_plate_numbers

1480: THEN
1481: BEGIN
1482:
1483: -- Bug5659809: update last_update_date and last_update_by as well
1484: UPDATE wms_license_plate_numbers
1485: SET lpn_context = l_lpn_context_packing
1486: ,catch_weight_flag = NULL --16466288
1487: --, last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
1488: --, last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */

Line 6767: UPDATE wms_license_plate_numbers

6763: IF l_other_tasks = 0 THEN
6764: l_progress := 130;
6765: mydebug('l_progress = ' || l_progress);
6766: -- Bug5659809: update last_update_date and last_update_by as well
6767: UPDATE wms_license_plate_numbers
6768: SET lpn_context = l_lpn_context_PREGENERATED
6769: -- , last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
6770: -- , last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
6771: WHERE lpn_id = rec_transfer_lpns.transfer_lpn_id

Line 6790: UPDATE wms_license_plate_numbers

6786: mydebug('l_progress = ' || l_progress);
6787: -- we need to do this since mmtt.lpn_id can be a fully consumable lpn in
6788: -- case where xferLPN is enabled on pickload UI.
6789: -- Bug5659809: update last_update_date and last_update_by as well
6790: UPDATE wms_license_plate_numbers
6791: SET lpn_context = l_lpn_context_INV
6792: --, last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
6793: --, last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
6794: WHERE lpn_id = rec_from_lpns.lpn_id

Line 6825: UPDATE wms_license_plate_numbers

6821: IF l_other_tasks = 0 THEN
6822: l_progress := 320;
6823: mydebug('l_progress = ' || l_progress);
6824: -- Bug5659809: update last_update_date and last_update_by as well
6825: UPDATE wms_license_plate_numbers
6826: SET lpn_context = l_lpn_context_inv
6827: --, last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
6828: --, last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
6829: WHERE lpn_id = rec_content_lpns.content_lpn_id

Line 7695: FROM WMS_LICENSE_PLATE_NUMBERS

7691: /*Now that LPN is fully consumable, we need to popuate parent_lpn_id
7692: if the picked LPN is already nested into another LPN */
7693: IF (l_parent_lpn_id IS NULL ) THEN
7694: SELECT parent_lpn_id INTO l_parent_lpn_id
7695: FROM WMS_LICENSE_PLATE_NUMBERS
7696: WHERE lpn_id=l_content_lpn_id ;
7697: END IF;
7698: IF (l_debug = 1) THEN
7699: mydebug ('parent_lpn_id:'||l_parent_lpn_id||',content_lpn_id:'||l_content_lpn_id);

Line 8653: FROM wms_license_plate_numbers wlpn

8649: , l_lpn_context
8650: , x_parent_lpn_id
8651: , l_lpn_sub
8652: , l_lpn_loc
8653: FROM wms_license_plate_numbers wlpn
8654: WHERE wlpn.organization_id = p_org_id
8655: AND wlpn.lpn_id = p_fromlpn_id;
8656: EXCEPTION
8657: WHEN NO_DATA_FOUND THEN

Line 8726: FROM wms_license_plate_numbers w

8722: , l_loc
8723: , l_from_lpn
8724: , l_loc_id
8725: , l_lpn_context
8726: FROM wms_license_plate_numbers w
8727: WHERE w.lpn_id = p_fromlpn_id
8728: AND w.locator_id IS NOT NULL;
8729:
8730: IF l_sub IS NULL THEN

Line 8838: FROM wms_license_plate_numbers

8834:
8835: BEGIN
8836: SELECT 1
8837: INTO l_so_cnt
8838: FROM wms_license_plate_numbers
8839: WHERE lpn_context = 11
8840: AND lpn_id = p_fromlpn_id
8841: AND organization_id = p_org_id;
8842: EXCEPTION

Line 9033: FROM wms_license_plate_numbers

9029: AND organization_id = p_org_id;
9030:
9031: SELECT COUNT(*)
9032: INTO l_lpn_include_lpn
9033: FROM wms_license_plate_numbers
9034: WHERE outermost_lpn_id = p_fromlpn_id
9035: AND organization_id = p_org_id;
9036:
9037: IF l_item_cnt2 > 1

Line 11870: FROM wms_license_plate_numbers

11866: BEGIN
11867:
11868: SELECT lpn_context
11869: INTO l_lpn_context
11870: FROM wms_license_plate_numbers
11871: WHERE lpn_id = p_fromlpn_id
11872: FOR UPDATE NOWAIT;
11873: EXCEPTION
11874: WHEN OTHERS THEN

Line 12680: FROM wms_license_plate_numbers

12676: , l_org_id
12677: , l_locator_id
12678: , x_lpn_id
12679: , x_outermost_lpn_id
12680: FROM wms_license_plate_numbers
12681: WHERE license_plate_number = p_lpn;
12682: x_pick_to_lpn_exists := TRUE;
12683: x_lpn_context := lpn_cont;
12684: EXCEPTION

Line 12948: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE

12944:
12945: l_fb_comingle VARCHAR2(1) :='N'; --MUoM
12946:
12947: TYPE lpn_rectype IS RECORD
12948: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE
12949: , lpn_context wms_license_plate_numbers.lpn_context%TYPE
12950: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE
12951: );
12952:

Line 12949: , lpn_context wms_license_plate_numbers.lpn_context%TYPE

12945: l_fb_comingle VARCHAR2(1) :='N'; --MUoM
12946:
12947: TYPE lpn_rectype IS RECORD
12948: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE
12949: , lpn_context wms_license_plate_numbers.lpn_context%TYPE
12950: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE
12951: );
12952:
12953: pick_to_lpn_rec lpn_rectype;

Line 12950: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE

12946:
12947: TYPE lpn_rectype IS RECORD
12948: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE
12949: , lpn_context wms_license_plate_numbers.lpn_context%TYPE
12950: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE
12951: );
12952:
12953: pick_to_lpn_rec lpn_rectype;
12954:

Line 12976: FROM wms_license_plate_numbers

12972: --AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650 Commented for Bug#7430264
12973:
12974: CURSOR child_lpns_cursor(l_lpn_id IN NUMBER) IS
12975: SELECT lpn_id
12976: FROM wms_license_plate_numbers
12977: START WITH lpn_id = l_lpn_id
12978: CONNECT BY parent_lpn_id = PRIOR lpn_id;
12979:
12980: child_lpns_rec child_lpns_cursor%ROWTYPE;

Line 13047: WHERE wdd.lpn_id IN (select lpn_id from wms_license_plate_numbers

13043:
13044: CURSOR c_wdd_exists(p_lpn_id NUMBER,p_organization_id NUMBER) is
13045: SELECT distinct wda.delivery_id
13046: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
13047: WHERE wdd.lpn_id IN (select lpn_id from wms_license_plate_numbers
13048: where organization_id = p_organization_id
13049: and (lpn_id = p_lpn_id
13050: or parent_lpn_id = p_lpn_id
13051: or outermost_lpn_id = p_lpn_id))

Line 13141: FROM Wms_License_Plate_Numbers wlpn

13137: IF (l_delivery_id IS NOT NULL )THEN
13138: BEGIN
13139: SELECT wlpn.LICENSE_PLATE_NUMBER
13140: INTO l_lpn_name
13141: FROM Wms_License_Plate_Numbers wlpn
13142: WHERE organization_id = p_organization_id
13143: and (lpn_id = pick_to_lpn_rec.lpn_id
13144: or parent_lpn_id = pick_to_lpn_rec.lpn_id
13145: or outermost_lpn_id = pick_to_lpn_rec.lpn_id);

Line 13218: FROM wms_license_plate_numbers

13214: END IF;
13215: BEGIN
13216: SELECT nvl(inventory_item_id, -999)
13217: INTO l_container_item_id
13218: FROM wms_license_plate_numbers
13219: WHERE license_plate_number = p_pick_to_lpn
13220: AND organization_id = p_organization_id
13221: AND lpn_context IN (wms_container_pub.lpn_context_packing, wms_container_pub.LPN_CONTEXT_PREGENERATED);
13222: EXCEPTION

Line 15845: FROM wms_license_plate_numbers wlpn

15841: SELECT subinventory_code
15842: , locator_id
15843: INTO l_lpn_sub
15844: , l_lpn_loc
15845: FROM wms_license_plate_numbers wlpn
15846: WHERE wlpn.organization_id = p_org_id
15847: AND wlpn.lpn_id = p_fromlpn_id;
15848: END IF;
15849: