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

Line 1780: FROM wms_license_plate_numbers

1776: SELECT 1
1777: INTO l_exist_lpn
1778: FROM DUAL
1779: WHERE EXISTS(SELECT 1
1780: FROM wms_license_plate_numbers
1781: WHERE license_plate_number = l_lpn
1782: AND organization_id = p_org_id);
1783: EXCEPTION
1784: WHEN NO_DATA_FOUND THEN

Line 1852: FROM wms_license_plate_numbers

1848: ELSE
1849: -- LPN exists. Get LPN ID
1850: SELECT lpn_id
1851: INTO l_lpn_id
1852: FROM wms_license_plate_numbers
1853: WHERE license_plate_number = l_lpn
1854: AND organization_id = p_org_id;
1855: END IF;
1856: END IF;

Line 2753: FROM wms_license_plate_numbers wlpn

2749: SELECT 1
2750: , lpn_context
2751: INTO l_lpn_exists
2752: , l_lpn_context
2753: FROM wms_license_plate_numbers wlpn
2754: WHERE wlpn.organization_id = p_org_id
2755: AND wlpn.lpn_id = p_lpn;
2756: EXCEPTION
2757: WHEN NO_DATA_FOUND THEN

Line 2826: FROM wms_license_plate_numbers w

2822: , l_loc
2823: , l_from_lpn
2824: , l_loc_id
2825: , l_lpn_context
2826: FROM wms_license_plate_numbers w
2827: WHERE w.lpn_id = p_lpn
2828: AND w.locator_id IS NOT NULL;
2829:
2830: IF l_sub IS NULL THEN

Line 2930: FROM wms_license_plate_numbers

2926:
2927: BEGIN
2928: SELECT 1
2929: INTO l_so_cnt
2930: FROM wms_license_plate_numbers
2931: WHERE lpn_context = 11
2932: AND lpn_id = p_lpn
2933: AND organization_id = p_org_id;
2934: EXCEPTION

Line 3110: FROM wms_license_plate_numbers

3106: AND organization_id = p_org_id;
3107:
3108: SELECT COUNT(*)
3109: INTO l_lpn_include_lpn
3110: FROM wms_license_plate_numbers
3111: WHERE outermost_lpn_id = p_lpn
3112: AND organization_id = p_org_id;
3113:
3114: IF l_item_cnt2 > 1

Line 5031: UPDATE wms_license_plate_numbers

5027: mydebug('Set lpn context to packing for lpn_ID : ' || p_lpn);
5028: END IF;
5029:
5030: -- Bug5659809: update last_update_date and last_update_by as well
5031: UPDATE wms_license_plate_numbers
5032: SET lpn_context = wms_container_pub.lpn_context_packing
5033: , last_update_date = SYSDATE
5034: , last_updated_by = fnd_global.user_id
5035: WHERE lpn_id = p_lpn;

Line 5219: FROM wms_license_plate_numbers

5215:
5216: BEGIN
5217: SELECT 1
5218: INTO l_to_lpn_exists
5219: FROM wms_license_plate_numbers
5220: WHERE license_plate_number = p_to_lpn
5221: AND organization_id = p_org_id;
5222: EXCEPTION
5223: WHEN NO_DATA_FOUND THEN

Line 5335: FROM wms_license_plate_numbers

5331: SELECT lpn_id
5332: , lpn_context
5333: INTO l_to_lpn_id
5334: , l_to_lpn_context
5335: FROM wms_license_plate_numbers
5336: WHERE license_plate_number = p_to_lpn
5337: AND organization_id = p_org_id;
5338: END IF;
5339:

Line 5348: UPDATE wms_license_plate_numbers

5344: --
5345: -- Update the context to "Packing context" (8)
5346: --
5347: -- Bug5659809: update last_update_date and last_update_by as well
5348: UPDATE wms_license_plate_numbers
5349: SET lpn_context = wms_container_pub.lpn_context_packing
5350: , last_update_date = SYSDATE
5351: , last_updated_by = fnd_global.user_id
5352: WHERE lpn_id = l_to_lpn_id;

Line 5386: FROM wms_license_plate_numbers

5382: END IF;
5383:
5384: SELECT parent_lpn_id
5385: INTO l_content_parent_lpn_id
5386: FROM wms_license_plate_numbers
5387: WHERE lpn_id = p_from_lpn_id
5388: AND organization_id = p_org_id;
5389:
5390: IF (l_debug = 1) THEN

Line 5436: UPDATE wms_license_plate_numbers

5432: mydebug('Set lpn context to packing for lpn_ID : ' || l_content_lpn_id);
5433: END IF;
5434:
5435: -- Bug5659809: update last_update_date and last_update_by as well
5436: UPDATE wms_license_plate_numbers
5437: SET lpn_context = wms_container_pub.lpn_context_packing
5438: , last_update_date = SYSDATE
5439: , last_updated_by = fnd_global.user_id
5440: WHERE lpn_id = l_content_lpn_id;

Line 6142: FROM WMS_LICENSE_PLATE_NUMBERS

6138:
6139: l_exist_lpn := 0;
6140:
6141: /* SELECT COUNT(*) INTO l_exist_lpn
6142: FROM WMS_LICENSE_PLATE_NUMBERS
6143: WHERE license_plate_number=l_lpn
6144: AND organization_id=l_org_id;*/
6145: BEGIN
6146: SELECT 1

Line 6150: FROM wms_license_plate_numbers

6146: SELECT 1
6147: INTO l_exist_lpn
6148: FROM DUAL
6149: WHERE EXISTS(SELECT 1
6150: FROM wms_license_plate_numbers
6151: WHERE license_plate_number = l_lpn
6152: AND organization_id = l_org_id);
6153: EXCEPTION
6154: WHEN NO_DATA_FOUND THEN

Line 6222: FROM wms_license_plate_numbers

6218: ELSE
6219: -- LPN exists. Get LPN ID
6220: SELECT lpn_id
6221: INTO l_transfer_lpn_id
6222: FROM wms_license_plate_numbers
6223: WHERE license_plate_number = l_lpn
6224: AND organization_id = l_org_id;
6225: END IF;
6226: END IF;

Line 6675: FROM WMS_LICENSE_PLATE_NUMBERS

6671:
6672: /*
6673: -- get sug lpn id
6674: SELECT lpn_id INTO l_sug_lpn_id
6675: FROM WMS_LICENSE_PLATE_NUMBERS
6676: WHERE license_plate_number=l_sug_lpn_name
6677: AND organization_id=l_org_id;
6678: */
6679: --Bug#2095232

Line 6683: FROM wms_license_plate_numbers

6679: --Bug#2095232
6680: -- get new lpn id instead of suggested one
6681: SELECT lpn_id
6682: INTO l_lpn_id
6683: FROM wms_license_plate_numbers
6684: WHERE license_plate_number = l_lpn_name
6685: AND organization_id = l_org_id;
6686:
6687: IF (l_lpn_name IS NULL) THEN

Line 6699: FROM WMS_LICENSE_PLATE_NUMBERS

6695:
6696: l_exist_lpn := 0;
6697:
6698: /* SELECT COUNT(*) INTO l_exist_lpn
6699: FROM WMS_LICENSE_PLATE_NUMBERS
6700: WHERE license_plate_number=l_lpn_name
6701: AND organization_id=l_org_id
6702: AND lpn_context<>wms_container_pub.lpn_context_packing;*/
6703: BEGIN

Line 6709: FROM wms_license_plate_numbers

6705: INTO l_exist_lpn
6706: FROM DUAL
6707: WHERE EXISTS(
6708: SELECT 1
6709: FROM wms_license_plate_numbers
6710: WHERE license_plate_number = l_lpn_name
6711: AND organization_id = l_org_id
6712: AND lpn_context <> wms_container_pub.lpn_context_packing);
6713: EXCEPTION

Line 6728: FROM wms_license_plate_numbers w, wms_lpn_contents c

6724: -- if yes, we cannot modify
6725: l_exist_lpn2 := 0;
6726:
6727: /* SELECT COUNT(*) INTO l_exist_lpn2
6728: FROM wms_license_plate_numbers w, wms_lpn_contents c
6729: WHERE w.license_plate_number=l_sug_lpn_name
6730: AND w.organization_id=l_org_id
6731: AND w.lpn_id=c.parent_lpn_id;*/
6732: BEGIN

Line 6737: FROM wms_license_plate_numbers w, wms_lpn_contents c

6733: SELECT 1
6734: INTO l_exist_lpn2
6735: FROM DUAL
6736: WHERE EXISTS(SELECT 1
6737: FROM wms_license_plate_numbers w, wms_lpn_contents c
6738: WHERE w.license_plate_number = l_sug_lpn_name
6739: AND w.organization_id = l_org_id
6740: AND w.lpn_id = c.parent_lpn_id);
6741: EXCEPTION

Line 6924: FROM wms_license_plate_numbers

6920:
6921: --Modifying the below sql to also get the data of sub and loc from the LPN in case of multiple pick bug3765153
6922: SELECT parent_lpn_id,subinventory_code,locator_id
6923: INTO l_content_parent_lpn_id,l_lpn_sub,l_lpn_loc
6924: FROM wms_license_plate_numbers
6925: WHERE lpn_id = l_lpn_id
6926: AND organization_id = p_org_id;
6927:
6928: IF (l_debug = 1) THEN

Line 7962: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE

7958: l_same_carton_grouping BOOLEAN := FALSE; --Bug#4440585
7959: l_return_status VARCHAR2(2) ;
7960:
7961: TYPE lpn_rectype IS RECORD
7962: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE
7963: , lpn_context wms_license_plate_numbers.lpn_context%TYPE
7964: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE
7965: );
7966:

Line 7963: , lpn_context wms_license_plate_numbers.lpn_context%TYPE

7959: l_return_status VARCHAR2(2) ;
7960:
7961: TYPE lpn_rectype IS RECORD
7962: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE
7963: , lpn_context wms_license_plate_numbers.lpn_context%TYPE
7964: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE
7965: );
7966:
7967: pick_to_lpn_rec lpn_rectype;

Line 7964: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE

7960:
7961: TYPE lpn_rectype IS RECORD
7962: ( lpn_id wms_license_plate_numbers.lpn_id%TYPE
7963: , lpn_context wms_license_plate_numbers.lpn_context%TYPE
7964: , outermost_lpn_id wms_license_plate_numbers.outermost_lpn_id%TYPE
7965: );
7966:
7967: pick_to_lpn_rec lpn_rectype;
7968:

Line 7991: FROM wms_license_plate_numbers

7987: CURSOR pick_to_lpn_cursor IS
7988: SELECT lpn_id
7989: , lpn_context
7990: , outermost_lpn_id
7991: FROM wms_license_plate_numbers
7992: WHERE license_plate_number = p_pick_to_lpn;
7993:
7994: CURSOR child_lpns_cursor(l_lpn_id IN NUMBER) IS
7995: SELECT lpn_id

Line 7996: FROM wms_license_plate_numbers

7992: WHERE license_plate_number = p_pick_to_lpn;
7993:
7994: CURSOR child_lpns_cursor(l_lpn_id IN NUMBER) IS
7995: SELECT lpn_id
7996: FROM wms_license_plate_numbers
7997: START WITH lpn_id = l_lpn_id
7998: CONNECT BY parent_lpn_id = PRIOR lpn_id;
7999:
8000: child_lpns_rec child_lpns_cursor%ROWTYPE;

Line 8136: UPDATE wms_license_plate_numbers

8132: --
8133: -- Update the context to "Packing Context" (8)
8134: --
8135: -- Bug5659809: update last_update_date and last_update_by as well
8136: UPDATE wms_license_plate_numbers
8137: SET lpn_context = wms_container_pub.lpn_context_packing
8138: , last_update_date = SYSDATE
8139: , last_updated_by = fnd_global.user_id
8140: WHERE lpn_id = pick_to_lpn_rec.lpn_id;

Line 9145: FROM wms_license_plate_numbers

9141:
9142: BEGIN
9143: SELECT 1
9144: INTO l_to_lpn_exists
9145: FROM wms_license_plate_numbers
9146: WHERE license_plate_number = p_to_lpn
9147: AND organization_id = p_org_id;
9148: EXCEPTION
9149: WHEN NO_DATA_FOUND THEN

Line 9233: FROM wms_license_plate_numbers

9229: SELECT lpn_id
9230: , lpn_context
9231: INTO l_to_lpn_id
9232: , l_to_lpn_context
9233: FROM wms_license_plate_numbers
9234: WHERE license_plate_number = p_to_lpn
9235: AND organization_id = p_org_id;
9236: ELSE
9237: l_to_lpn_id := NULL;

Line 10040: FROM wms_license_plate_numbers

10036: SELECT subinventory_code
10037: , locator_id
10038: INTO l_act_sub
10039: , l_act_loc
10040: FROM wms_license_plate_numbers
10041: WHERE lpn_id = l_from_lpn_id;
10042:
10043: l_progress := '430';
10044:

Line 10053: FROM wms_license_plate_numbers

10049: END IF;
10050:
10051: SELECT parent_lpn_id
10052: INTO l_content_parent_lpn_id
10053: FROM wms_license_plate_numbers
10054: WHERE lpn_id = l_from_lpn_id
10055: AND organization_id = p_org_id;
10056:
10057: IF (l_debug = 1) THEN

Line 10462: UPDATE wms_license_plate_numbers

10458: -- Changed the context to be updated to 8 instead of 1 as done earlier
10459:
10460: IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN
10461: -- Bug5659809: update last_update_date and last_update_by as well
10462: UPDATE wms_license_plate_numbers
10463: SET lpn_context = wms_container_pub.lpn_context_packing
10464: , last_update_date = SYSDATE
10465: , last_updated_by = fnd_global.user_id
10466: WHERE lpn_id = l_to_lpn_id;

Line 10522: /* SELECT COUNT(*) INTO l_exist FROM wms_license_plate_numbers

10518:
10519: l_lpn_rec.license_plate_number := p_lpn;
10520: l_exist := 0;
10521:
10522: /* SELECT COUNT(*) INTO l_exist FROM wms_license_plate_numbers
10523: WHERE license_plate_number=p_lpn;*/
10524: BEGIN
10525: SELECT 1
10526: INTO l_exist

Line 10529: FROM wms_license_plate_numbers

10525: SELECT 1
10526: INTO l_exist
10527: FROM DUAL
10528: WHERE EXISTS(SELECT 1
10529: FROM wms_license_plate_numbers
10530: WHERE license_plate_number = p_lpn);
10531: EXCEPTION
10532: WHEN NO_DATA_FOUND THEN
10533: l_exist := 0;

Line 10588: FROM wms_license_plate_numbers

10584: END IF;
10585: ELSE -- lpn exists
10586: SELECT lpn_id
10587: INTO p_lpn_id
10588: FROM wms_license_plate_numbers
10589: WHERE license_plate_number = p_lpn;
10590: END IF;
10591:
10592: x_return_status := fnd_api.g_ret_sts_success;

Line 10685: FROM wms_license_plate_numbers

10681:
10682: -- DHERRING additional cursor to find all nested LPNs
10683: CURSOR child_lpns_csr IS
10684: SELECT lpn_id
10685: FROM wms_license_plate_numbers
10686: START WITH lpn_id = l_xfrlpnid
10687: CONNECT BY PRIOR lpn_id = parent_lpn_id;
10688:
10689: -- End of changes for 5222498

Line 11204: UPDATE wms_license_plate_numbers

11200:
11201: -- Now update the loc of the LPN
11202:
11203: -- Bug5659809: update last_update_date and last_update_by as well
11204: UPDATE wms_license_plate_numbers
11205: SET subinventory_code = l_transfer_sub
11206: , locator_id = l_transfer_loc
11207: , last_update_date = SYSDATE
11208: , last_updated_by = fnd_global.user_id

Line 11437: FROM wms_license_plate_numbers

11433: -- Now need to update LPN context appropriately
11434: IF l_isdroplpnentered = TRUE THEN
11435: SELECT lpn_id
11436: INTO l_xfrlpnid
11437: FROM wms_license_plate_numbers
11438: WHERE license_plate_number = p_drop_lpn;
11439: ELSE
11440: l_xfrlpnid := p_from_lpn_id;
11441: END IF;

Line 11584: , wms_license_plate_numbers wlpn

11580: INTO l_shipped_wdd_count_in_lpn
11581: FROM wsh_delivery_details wdd1
11582: , wsh_delivery_details wdd2
11583: , wsh_delivery_assignments_v wda
11584: , wms_license_plate_numbers wlpn
11585: WHERE wdd1.released_status = 'C'
11586: AND wda.delivery_detail_id = wdd1.delivery_detail_id
11587: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
11588: AND wdd2.lpn_id = wlpn.lpn_id

Line 13267: FROM wms_license_plate_numbers

13263: SELECT lpn_context
13264: , organization_id
13265: INTO lpn_cont
13266: , l_org_id
13267: FROM wms_license_plate_numbers
13268: WHERE license_plate_number = p_lpn;
13269: EXCEPTION
13270: WHEN NO_DATA_FOUND THEN
13271: create_lpn := 'Y';

Line 15265: lpn_id wms_license_plate_numbers.lpn_id%TYPE,

15261: l_grouping_rows WSH_UTIL_CORE.id_tab_type; -- Added for bug#4106176
15262:
15263: TYPE lpn_rectype is RECORD
15264: (
15265: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
15266: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
15267: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
15268: locator_id wms_license_plate_numbers.locator_id%TYPE
15269: );

Line 15266: lpn_context wms_license_plate_numbers.lpn_context%TYPE,

15262:
15263: TYPE lpn_rectype is RECORD
15264: (
15265: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
15266: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
15267: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
15268: locator_id wms_license_plate_numbers.locator_id%TYPE
15269: );
15270: drop_lpn_rec lpn_rectype;

Line 15267: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,

15263: TYPE lpn_rectype is RECORD
15264: (
15265: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
15266: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
15267: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
15268: locator_id wms_license_plate_numbers.locator_id%TYPE
15269: );
15270: drop_lpn_rec lpn_rectype;
15271:

Line 15268: locator_id wms_license_plate_numbers.locator_id%TYPE

15264: (
15265: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
15266: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
15267: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
15268: locator_id wms_license_plate_numbers.locator_id%TYPE
15269: );
15270: drop_lpn_rec lpn_rectype;
15271:
15272: CURSOR drop_lpn_cursor IS

Line 15277: FROM wms_license_plate_numbers

15273: SELECT lpn_id,
15274: lpn_context,
15275: subinventory_code,
15276: locator_id
15277: FROM wms_license_plate_numbers
15278: WHERE license_plate_number = p_drop_lpn
15279: AND organization_id = p_organization_id;
15280:
15281: CURSOR pick_delivery_cursor IS

Line 15296: wms_license_plate_numbers lpn

15292: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
15293: SELECT wda.delivery_id
15294: FROM wsh_delivery_assignments wda,
15295: wsh_delivery_details wdd,
15296: wms_license_plate_numbers lpn
15297: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
15298: AND wdd.lpn_id = lpn.lpn_id
15299: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
15300: AND lpn.outermost_lpn_id = l_lpn_id

Line 15348: /* UPDATE wms_license_plate_numbers

15344: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED THEN
15345: --
15346: -- Update the context to "Resides in Inventory" (1)
15347: --
15348: /* UPDATE wms_license_plate_numbers
15349: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
15350: WHERE lpn_id = drop_lpn_rec.lpn_id;*/
15351:
15352: IF (l_debug = 1) THEN

Line 15557: wms_license_plate_numbers wlpn

15553: --Bug Fix 4622935 Added hint as suggested by Ben Chihaoui
15554: SELECT /*+ index(wda WSH_DELIVERY_ASSIGNMENTS_N1) ORDERED USE_NL (WDA WDD WLPN) */ wlpn.outermost_lpn_id
15555: FROM wsh_delivery_assignments wda,
15556: wsh_delivery_details wdd,
15557: wms_license_plate_numbers wlpn
15558: WHERE wda.delivery_id = l_delivery_id_c
15559: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
15560: AND wdd.organization_id = p_organization_id
15561: AND wdd.lpn_id = wlpn.lpn_id

Line 15631: wms_license_plate_numbers WHERE lpn_id = l_lpn_id;

15627:
15628:
15629: BEGIN
15630: SELECT license_plate_number INTO x_lpn_number FROM
15631: wms_license_plate_numbers WHERE lpn_id = l_lpn_id;
15632:
15633: EXCEPTION
15634: WHEN NO_DATA_FOUND THEN
15635: x_lpn_number := NULL;