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 1077: UPDATE wms_license_plate_numbers

1073: WHERE transaction_temp_id = p_transaction_temp_id1
1074: returning lpn_id INTO l_lpn_id;
1075:
1076: -- Bug5659809: update last_update_date and last_update_by as well
1077: UPDATE wms_license_plate_numbers
1078: SET lpn_context = 1
1079: , last_update_date = SYSDATE
1080: , last_updated_by = fnd_global.user_id
1081: WHERE lpn_id = l_lpn_id;

Line 1312: UPDATE wms_license_plate_numbers

1308: instead of INTO LPN) then do not change the context of the LPN to packing.
1309: TM needs it to be 'resides in inv' to be able to unpack the material */
1310: BEGIN
1311: -- Bug5659809: update last_update_date and last_update_by as well
1312: UPDATE wms_license_plate_numbers
1313: SET lpn_context = l_lpn_context_packing
1314: , last_update_date = SYSDATE
1315: , last_updated_by = fnd_global.user_id
1316: WHERE lpn_id = l_lpn_match_lpn_id

Line 1348: UPDATE wms_license_plate_numbers

1344: THEN
1345: BEGIN
1346:
1347: -- Bug5659809: update last_update_date and last_update_by as well
1348: UPDATE wms_license_plate_numbers
1349: SET lpn_context = l_lpn_context_packing
1350: , last_update_date = SYSDATE
1351: , last_updated_by = fnd_global.user_id
1352: WHERE lpn_id = l_transfer_lpn_id

Line 5525: UPDATE wms_license_plate_numbers

5521: IF l_other_tasks = 0 THEN
5522: l_progress := 130;
5523: mydebug('l_progress = ' || l_progress);
5524: -- Bug5659809: update last_update_date and last_update_by as well
5525: UPDATE wms_license_plate_numbers
5526: SET lpn_context = l_lpn_context_PREGENERATED
5527: , last_update_date = SYSDATE
5528: , last_updated_by = fnd_global.user_id
5529: WHERE lpn_id = rec_transfer_lpns.transfer_lpn_id

Line 5548: UPDATE wms_license_plate_numbers

5544: mydebug('l_progress = ' || l_progress);
5545: -- we need to do this since mmtt.lpn_id can be a fully consumable lpn in
5546: -- case where xferLPN is enabled on pickload UI.
5547: -- Bug5659809: update last_update_date and last_update_by as well
5548: UPDATE wms_license_plate_numbers
5549: SET lpn_context = l_lpn_context_INV
5550: , last_update_date = SYSDATE
5551: , last_updated_by = fnd_global.user_id
5552: WHERE lpn_id = rec_from_lpns.lpn_id

Line 5583: UPDATE wms_license_plate_numbers

5579: IF l_other_tasks = 0 THEN
5580: l_progress := 320;
5581: mydebug('l_progress = ' || l_progress);
5582: -- Bug5659809: update last_update_date and last_update_by as well
5583: UPDATE wms_license_plate_numbers
5584: SET lpn_context = l_lpn_context_inv
5585: , last_update_date = SYSDATE
5586: , last_updated_by = fnd_global.user_id
5587: WHERE lpn_id = rec_content_lpns.content_lpn_id

Line 7128: FROM wms_license_plate_numbers wlpn

7124: , l_lpn_context
7125: , x_parent_lpn_id
7126: , l_lpn_sub
7127: , l_lpn_loc
7128: FROM wms_license_plate_numbers wlpn
7129: WHERE wlpn.organization_id = p_org_id
7130: AND wlpn.lpn_id = p_fromlpn_id;
7131: EXCEPTION
7132: WHEN NO_DATA_FOUND THEN

Line 7201: FROM wms_license_plate_numbers w

7197: , l_loc
7198: , l_from_lpn
7199: , l_loc_id
7200: , l_lpn_context
7201: FROM wms_license_plate_numbers w
7202: WHERE w.lpn_id = p_fromlpn_id
7203: AND w.locator_id IS NOT NULL;
7204:
7205: IF l_sub IS NULL THEN

Line 7312: FROM wms_license_plate_numbers

7308:
7309: BEGIN
7310: SELECT 1
7311: INTO l_so_cnt
7312: FROM wms_license_plate_numbers
7313: WHERE lpn_context = 11
7314: AND lpn_id = p_fromlpn_id
7315: AND organization_id = p_org_id;
7316: EXCEPTION

Line 7501: FROM wms_license_plate_numbers

7497: AND organization_id = p_org_id;
7498:
7499: SELECT COUNT(*)
7500: INTO l_lpn_include_lpn
7501: FROM wms_license_plate_numbers
7502: WHERE outermost_lpn_id = p_fromlpn_id
7503: AND organization_id = p_org_id;
7504:
7505: IF l_item_cnt2 > 1

Line 9754: FROM wms_license_plate_numbers

9750: BEGIN
9751:
9752: SELECT lpn_context
9753: INTO l_lpn_context
9754: FROM wms_license_plate_numbers
9755: WHERE lpn_id = p_fromlpn_id
9756: FOR UPDATE NOWAIT;
9757: EXCEPTION
9758: WHEN OTHERS THEN

Line 10390: FROM wms_license_plate_numbers

10386: , l_org_id
10387: , l_locator_id
10388: , x_lpn_id
10389: , x_outermost_lpn_id
10390: FROM wms_license_plate_numbers
10391: WHERE license_plate_number = p_lpn;
10392: x_pick_to_lpn_exists := TRUE;
10393: x_lpn_context := lpn_cont;
10394: EXCEPTION

Line 10652: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE

10648: l_OUT_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
10649: --Bug 6168447-End
10650:
10651: TYPE lpn_rectype IS RECORD
10652: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE
10653: , lpn_context wms_license_plate_numbers.lpn_context%TYPE
10654: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE
10655: );
10656:

Line 10653: , lpn_context wms_license_plate_numbers.lpn_context%TYPE

10649: --Bug 6168447-End
10650:
10651: TYPE lpn_rectype IS RECORD
10652: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE
10653: , lpn_context wms_license_plate_numbers.lpn_context%TYPE
10654: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE
10655: );
10656:
10657: pick_to_lpn_rec lpn_rectype;

Line 10654: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE

10650:
10651: TYPE lpn_rectype IS RECORD
10652: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE
10653: , lpn_context wms_license_plate_numbers.lpn_context%TYPE
10654: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE
10655: );
10656:
10657: pick_to_lpn_rec lpn_rectype;
10658:

Line 10680: FROM wms_license_plate_numbers

10676: --AND wdd.released_status = 'X'; -- For LPN reusability ER : 6845650 Commented for Bug#7430264
10677:
10678: CURSOR child_lpns_cursor(l_lpn_id IN NUMBER) IS
10679: SELECT lpn_id
10680: FROM wms_license_plate_numbers
10681: START WITH lpn_id = l_lpn_id
10682: CONNECT BY parent_lpn_id = PRIOR lpn_id;
10683:
10684: child_lpns_rec child_lpns_cursor%ROWTYPE;

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

10747:
10748: CURSOR c_wdd_exists(p_lpn_id NUMBER,p_organization_id NUMBER) is
10749: SELECT distinct wda.delivery_id
10750: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
10751: WHERE wdd.lpn_id IN (select lpn_id from wms_license_plate_numbers
10752: where organization_id = p_organization_id
10753: and (lpn_id = p_lpn_id
10754: or parent_lpn_id = p_lpn_id
10755: or outermost_lpn_id = p_lpn_id))

Line 10845: FROM Wms_License_Plate_Numbers wlpn

10841: IF (l_delivery_id IS NOT NULL )THEN
10842: BEGIN
10843: SELECT wlpn.LICENSE_PLATE_NUMBER
10844: INTO l_lpn_name
10845: FROM Wms_License_Plate_Numbers wlpn
10846: WHERE organization_id = p_organization_id
10847: and (lpn_id = pick_to_lpn_rec.lpn_id
10848: or parent_lpn_id = pick_to_lpn_rec.lpn_id
10849: or outermost_lpn_id = pick_to_lpn_rec.lpn_id);

Line 10922: FROM wms_license_plate_numbers

10918: END IF;
10919: BEGIN
10920: SELECT nvl(inventory_item_id, -999)
10921: INTO l_container_item_id
10922: FROM wms_license_plate_numbers
10923: WHERE license_plate_number = p_pick_to_lpn
10924: AND organization_id = p_organization_id
10925: AND lpn_context IN (wms_container_pub.lpn_context_packing, wms_container_pub.LPN_CONTEXT_PREGENERATED);
10926: EXCEPTION

Line 11070: UPDATE wms_license_plate_numbers

11066: * IF pick_to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated THEN
11067: --
11068: -- Update the context to "Packing Context" (8)
11069: --
11070: UPDATE wms_license_plate_numbers
11071: SET lpn_context = wms_container_pub.lpn_context_packing
11072: WHERE lpn_id = pick_to_lpn_rec.lpn_id;
11073:
11074: IF (l_debug = 1) THEN