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

10484: -- Changed the context to be updated to 8 instead of 1 as done earlier
10485:
10486: IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN
10487: -- Bug5659809: update last_update_date and last_update_by as well
10488: UPDATE wms_license_plate_numbers
10489: SET lpn_context = wms_container_pub.lpn_context_packing
10490: , last_update_date = SYSDATE
10491: , last_updated_by = fnd_global.user_id
10492: WHERE lpn_id = l_to_lpn_id;

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

10544:
10545: l_lpn_rec.license_plate_number := p_lpn;
10546: l_exist := 0;
10547:
10548: /* SELECT COUNT(*) INTO l_exist FROM wms_license_plate_numbers
10549: WHERE license_plate_number=p_lpn;*/
10550: BEGIN
10551: SELECT 1
10552: INTO l_exist

Line 10555: FROM wms_license_plate_numbers

10551: SELECT 1
10552: INTO l_exist
10553: FROM DUAL
10554: WHERE EXISTS(SELECT 1
10555: FROM wms_license_plate_numbers
10556: WHERE license_plate_number = p_lpn);
10557: EXCEPTION
10558: WHEN NO_DATA_FOUND THEN
10559: l_exist := 0;

Line 10614: FROM wms_license_plate_numbers

10610: END IF;
10611: ELSE -- lpn exists
10612: SELECT lpn_id
10613: INTO p_lpn_id
10614: FROM wms_license_plate_numbers
10615: WHERE license_plate_number = p_lpn;
10616: END IF;
10617:
10618: x_return_status := fnd_api.g_ret_sts_success;

Line 10714: FROM wms_license_plate_numbers

10710:
10711: -- DHERRING additional cursor to find all nested LPNs
10712: CURSOR child_lpns_csr IS
10713: SELECT lpn_id
10714: FROM wms_license_plate_numbers
10715: START WITH lpn_id = l_xfrlpnid
10716: CONNECT BY PRIOR lpn_id = parent_lpn_id;
10717:
10718: -- End of changes for 5222498

Line 11275: UPDATE wms_license_plate_numbers

11271:
11272: -- Now update the loc of the LPN
11273:
11274: -- Bug5659809: update last_update_date and last_update_by as well
11275: UPDATE wms_license_plate_numbers
11276: SET subinventory_code = l_transfer_sub
11277: , locator_id = l_transfer_loc
11278: , last_update_date = SYSDATE
11279: , last_updated_by = fnd_global.user_id

Line 11508: FROM wms_license_plate_numbers

11504: -- Now need to update LPN context appropriately
11505: IF l_isdroplpnentered = TRUE THEN
11506: SELECT lpn_id
11507: INTO l_xfrlpnid
11508: FROM wms_license_plate_numbers
11509: WHERE license_plate_number = p_drop_lpn;
11510: ELSE
11511: l_xfrlpnid := p_from_lpn_id;
11512: END IF;

Line 11721: , wms_license_plate_numbers wlpn

11717: INTO l_open_wdd_count_in_lpn
11718: FROM wsh_delivery_details wdd1
11719: , wsh_delivery_details wdd2
11720: , wsh_delivery_assignments_v wda
11721: , wms_license_plate_numbers wlpn
11722: WHERE wdd2.released_status = 'X'
11723: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
11724: AND wda.delivery_detail_id = wdd1.delivery_detail_id
11725: AND wdd2.lpn_id = wlpn.lpn_id

Line 11733: , wms_license_plate_numbers wlpn

11729: INTO l_shipped_wdd_count_in_lpn
11730: FROM wsh_delivery_details wdd1
11731: , wsh_delivery_details wdd2
11732: , wsh_delivery_assignments_v wda
11733: , wms_license_plate_numbers wlpn
11734: WHERE wdd1.released_status = 'C'
11735: AND wda.delivery_detail_id = wdd1.delivery_detail_id
11736: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id
11737: AND wdd2.lpn_id = wlpn.lpn_id

Line 13519: FROM wms_license_plate_numbers

13515: SELECT lpn_context
13516: , organization_id
13517: INTO lpn_cont
13518: , l_org_id
13519: FROM wms_license_plate_numbers
13520: WHERE license_plate_number = p_lpn;
13521: EXCEPTION
13522: WHEN NO_DATA_FOUND THEN
13523: create_lpn := 'Y';

Line 15665: lpn_id wms_license_plate_numbers.lpn_id%TYPE,

15661: l_grouping_rows WSH_UTIL_CORE.id_tab_type; -- Added for bug#4106176
15662:
15663: TYPE lpn_rectype is RECORD
15664: (
15665: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
15666: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
15667: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
15668: locator_id wms_license_plate_numbers.locator_id%TYPE
15669: );

Line 15666: lpn_context wms_license_plate_numbers.lpn_context%TYPE,

15662:
15663: TYPE lpn_rectype is RECORD
15664: (
15665: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
15666: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
15667: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
15668: locator_id wms_license_plate_numbers.locator_id%TYPE
15669: );
15670: drop_lpn_rec lpn_rectype;

Line 15667: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,

15663: TYPE lpn_rectype is RECORD
15664: (
15665: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
15666: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
15667: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
15668: locator_id wms_license_plate_numbers.locator_id%TYPE
15669: );
15670: drop_lpn_rec lpn_rectype;
15671:

Line 15668: locator_id wms_license_plate_numbers.locator_id%TYPE

15664: (
15665: lpn_id wms_license_plate_numbers.lpn_id%TYPE,
15666: lpn_context wms_license_plate_numbers.lpn_context%TYPE,
15667: subinventory_code wms_license_plate_numbers.subinventory_code%TYPE,
15668: locator_id wms_license_plate_numbers.locator_id%TYPE
15669: );
15670: drop_lpn_rec lpn_rectype;
15671:
15672: CURSOR drop_lpn_cursor IS

Line 15677: FROM wms_license_plate_numbers

15673: SELECT lpn_id,
15674: lpn_context,
15675: subinventory_code,
15676: locator_id
15677: FROM wms_license_plate_numbers
15678: WHERE license_plate_number = p_drop_lpn
15679: AND organization_id = p_organization_id;
15680:
15681: CURSOR pick_delivery_cursor IS

Line 15696: wms_license_plate_numbers lpn

15692: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
15693: SELECT wda.delivery_id
15694: FROM wsh_delivery_assignments wda,
15695: wsh_delivery_details wdd,
15696: wms_license_plate_numbers lpn
15697: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
15698: AND wdd.lpn_id = lpn.lpn_id
15699: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
15700: AND lpn.outermost_lpn_id = l_lpn_id

Line 15748: /* UPDATE wms_license_plate_numbers

15744: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED THEN
15745: --
15746: -- Update the context to "Resides in Inventory" (1)
15747: --
15748: /* UPDATE wms_license_plate_numbers
15749: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
15750: WHERE lpn_id = drop_lpn_rec.lpn_id;*/
15751:
15752: IF (l_debug = 1) THEN

Line 15957: wms_license_plate_numbers wlpn

15953: --Bug Fix 4622935 Added hint as suggested by Ben Chihaoui
15954: SELECT /*+ index(wda WSH_DELIVERY_ASSIGNMENTS_N1) ORDERED USE_NL (WDA WDD WLPN) */ wlpn.outermost_lpn_id
15955: FROM wsh_delivery_assignments wda,
15956: wsh_delivery_details wdd,
15957: wms_license_plate_numbers wlpn
15958: WHERE wda.delivery_id = l_delivery_id_c
15959: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
15960: AND wdd.organization_id = p_organization_id
15961: AND wdd.lpn_id = wlpn.lpn_id

Line 16031: wms_license_plate_numbers WHERE lpn_id = l_lpn_id;

16027:
16028:
16029: BEGIN
16030: SELECT license_plate_number INTO x_lpn_number FROM
16031: wms_license_plate_numbers WHERE lpn_id = l_lpn_id;
16032:
16033: EXCEPTION
16034: WHEN NO_DATA_FOUND THEN
16035: x_lpn_number := NULL;