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

Line 82: TYPE lpn_name_tab IS TABLE OF WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE

78:
79: -- Define collections for commonly used datatypes. These collections will be
80: -- used for bulk fetch.
81:
82: TYPE lpn_name_tab IS TABLE OF WMS_LICENSE_PLATE_NUMBERS.LICENSE_PLATE_NUMBER%TYPE
83: INDEX BY BINARY_INTEGER;
84: TYPE sub_name_tab IS TABLE OF MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE row_type_tab IS TABLE OF WMS_PUTAWAY_GROUP_TASKS_GTMP.ROW_TYPE%TYPE

Line 333: wms_license_plate_numbers wlpn

329: IS
330: CURSOR loaded_lpn_cur IS
331: SELECT wlpn.lpn_id,NVL(wlpn.parent_lpn_id,0),NVL(mmtt.lpn_id,0),NVL(mmtt.content_lpn_id,0),mmtt.transaction_temp_id
332: FROM mtl_material_transactions_temp mmtt ,
333: wms_license_plate_numbers wlpn
334: WHERE wlpn.organization_id = p_org_id
335: AND wlpn.outermost_lpn_id = p_lpn_id
336: AND wlpn.outermost_lpn_id <> wlpn.lpn_id
337: AND mmtt.organization_id = p_org_id

Line 693: FROM wms_license_plate_numbers

689: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
690: AND mmtt.move_order_line_id = mtrl.line_id
691: AND NVL (mmtt.wms_task_type, 0) <> -1
692: AND mtrl.lpn_id IN (SELECT lpn_id
693: FROM wms_license_plate_numbers
694: WHERE organization_id = p_organization_id
695: START WITH lpn_id = p_lpn_id
696: CONNECT BY parent_lpn_id = PRIOR lpn_id)
697: AND mtrl.header_id = mtrh.header_id

Line 807: (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id=wln.outermost_lpn_id), --Outermost LPN Name

803: wln.lpn_context,
804: wln.parent_lpn_id,
805: NULL,
806: wln.outermost_lpn_id, --Outermost LPN ID
807: (SELECT license_plate_number FROM wms_license_plate_numbers WHERE lpn_id=wln.outermost_lpn_id), --Outermost LPN Name
808: TO_NUMBER(NULL), --Consolidated LPN ID
809: NULL, --Consolidated LPN Name
810: gtmp_rec.cartonization_id, --INTO LPN ID
811: NULL, --INTO LPN Name

Line 851: FROM wms_license_plate_numbers

847: gtmp_rec.task_id,
848: gtmp_rec.txn_source_id,
849: gtmp_rec.primary_quantity,
850: (SELECT level
851: FROM wms_license_plate_numbers
852: WHERE organization_id = p_organization_id
853: AND lpn_id=gtmp_rec.lpn_id
854: AND ROWNUM=1
855: START WITH lpn_id = p_lpn_id

Line 859: FROM wms_license_plate_numbers wln

855: START WITH lpn_id = p_lpn_id
856: CONNECT BY parent_lpn_id = PRIOR lpn_id),
857: gtmp_rec.secondary_transaction_quantity, -- 9037915
858: gtmp_rec.secondary_uom_code -- 9037915
859: FROM wms_license_plate_numbers wln
860: WHERE wln.organization_id = p_organization_id
861: AND wln.lpn_id = gtmp_rec.lpn_id;
862:
863:

Line 1257: FROM wms_license_plate_numbers

1253:
1254: --This cursor will fetch all the child LPNs for the LPN Passed
1255: CURSOR c_child_lpn_cursor IS
1256: SELECT lpn_id
1257: FROM wms_license_plate_numbers
1258: START WITH lpn_id = p_lpn_id
1259: CONNECT BY PRIOR lpn_id = parent_lpn_id;
1260:
1261: BEGIN

Line 1286: FROM wms_license_plate_numbers

1282: INTO l_min_drop_order
1283: FROM wms_putaway_group_tasks_gtmp
1284: WHERE lpn_id = p_lpn_id
1285: OR lpn_id IN ( SELECT lpn_id
1286: FROM wms_license_plate_numbers
1287: START WITH lpn_id = p_lpn_id
1288: CONNECT BY PRIOR lpn_id = parent_lpn_id
1289: );
1290: l_progress := '170';

Line 1298: FROM wms_license_plate_numbers

1294: SET consolidated_lpn_id = p_lpn_id
1295: ,consolidated_lpn_name = l_lpn_name
1296: ,drop_order = p_drop_order
1297: WHERE lpn_id IN (SELECT lpn_id
1298: FROM wms_license_plate_numbers
1299: START WITH lpn_id = p_lpn_id
1300: CONNECT BY PRIOR lpn_id = parent_lpn_id
1301: );*/
1302:

Line 2446: wms_license_plate_numbers wlpn1

2442: ,l_parent_lpn_name_tab(i)
2443: ,l_outermost_lpn_id_tab(i)
2444: ,l_outermost_lpn_name_tab(i)
2445: FROM
2446: wms_license_plate_numbers wlpn1
2447: ,wms_license_plate_numbers wlpn2
2448: ,wms_license_plate_numbers wlpn3
2449: WHERE
2450: wlpn1.lpn_id = l_wpgtt_lpn_id_tab(i)

Line 2447: ,wms_license_plate_numbers wlpn2

2443: ,l_outermost_lpn_id_tab(i)
2444: ,l_outermost_lpn_name_tab(i)
2445: FROM
2446: wms_license_plate_numbers wlpn1
2447: ,wms_license_plate_numbers wlpn2
2448: ,wms_license_plate_numbers wlpn3
2449: WHERE
2450: wlpn1.lpn_id = l_wpgtt_lpn_id_tab(i)
2451: AND wlpn1.outermost_lpn_id = wlpn3.lpn_id

Line 2448: ,wms_license_plate_numbers wlpn3

2444: ,l_outermost_lpn_name_tab(i)
2445: FROM
2446: wms_license_plate_numbers wlpn1
2447: ,wms_license_plate_numbers wlpn2
2448: ,wms_license_plate_numbers wlpn3
2449: WHERE
2450: wlpn1.lpn_id = l_wpgtt_lpn_id_tab(i)
2451: AND wlpn1.outermost_lpn_id = wlpn3.lpn_id
2452: AND wlpn2.lpn_id(+) = wlpn1.parent_lpn_id;

Line 3120: FROM wms_license_plate_numbers wln

3116: SELECT lpn_id
3117: ,parent_lpn_id
3118: ,LEVEL
3119: ,lpn_context
3120: FROM wms_license_plate_numbers wln
3121: START WITH LPN_ID = p_lpn_id
3122: CONNECT BY PRIOR wln.lpn_id = wln.parent_lpn_id;
3123:
3124: CURSOR c_dropall_lpn_cursor IS

Line 3129: FROM wms_license_plate_numbers wln

3125: SELECT lpn_id
3126: ,parent_lpn_id
3127: ,LEVEL
3128: ,lpn_context
3129: FROM wms_license_plate_numbers wln
3130: START WITH LPN_ID IN (
3131: SELECT DISTINCT wln2.outermost_lpn_id
3132: FROM wms_dispatched_tasks wdt
3133: ,mtl_txn_request_lines mtrl

Line 3136: ,wms_license_plate_numbers wln2

3132: FROM wms_dispatched_tasks wdt
3133: ,mtl_txn_request_lines mtrl
3134: ,mtl_material_transactions_temp mmtt
3135: ,mtl_txn_request_headers mtrh
3136: ,wms_license_plate_numbers wln2
3137: WHERE mtrh.header_id = mtrl.header_id
3138: AND mtrh.move_order_type = 6
3139: AND mtrl.line_status = 7
3140: AND wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 3412: ,wms_license_plate_numbers wln

3408: ,wms_dispatched_tasks wdt
3409: --,mtl_item_locations milk
3410: ,mtl_system_items_kfv msik
3411: ,mtl_txn_request_headers mtrh
3412: ,wms_license_plate_numbers wln
3413: --,mtl_secondary_inventories msi
3414: WHERE wdt.organization_id = p_org_id
3415: -- kajain
3416: -- added the decode since a lpn loaded by someone

Line 3839: FROM ( SELECT lpn_id FROM wms_license_plate_numbers

3835: -- Performane fix as a part of bug 7143123
3836: CURSOR c_all_mmtt_cursor IS -- Bug 7453925
3837: SELECT /*+ ORDERED USE_NL(mtrl mmtt) INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */
3838: mmtt.transaction_temp_id
3839: FROM ( SELECT lpn_id FROM wms_license_plate_numbers
3840: START WITH lpn_id = p_lpn_id
3841: CONNECT BY PRIOR lpn_id = parent_lpn_id
3842: ) wlpn,
3843: mtl_txn_request_lines mtrl,

Line 4024: FROM ( SELECT lpn_id FROM wms_license_plate_numbers

4020: -- Performane fix as a part of bug 7143123
4021: CURSOR c_all_mmtt_cursor IS -- Bug 7453925
4022: SELECT /*+ ORDERED USE_NL(mtrl mmtt) INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */
4023: mmtt.transaction_temp_id
4024: FROM ( SELECT lpn_id FROM wms_license_plate_numbers
4025: START WITH lpn_id = p_lpn_id
4026: CONNECT BY PRIOR lpn_id = parent_lpn_id
4027: ) wlpn,
4028: mtl_txn_request_lines mtrl,

Line 4369: ,wms_license_plate_numbers wlpn

4365: ,msi.dropping_order sub_dropping_order
4366: ,milk.dropping_order loc_dropping_order
4367: ,Nvl(msi.lpn_controlled_flag,2) lpn_controlled_flag
4368: FROM mtl_material_transactions_temp mmtt
4369: ,wms_license_plate_numbers wlpn
4370: ,mtl_secondary_inventories msi
4371: ,mtl_item_locations_kfv milk
4372: WHERE mmtt.transaction_temp_id = v_transaction_temp_id
4373: AND mmtt.cartonization_id = wlpn.lpn_id(+)

Line 4655: FROM WMS_LICENSE_PLATE_NUMBERS

4651: -- So that other user(s) can't work on this LPN.
4652: SELECT lpn_id
4653: BULK COLLECT
4654: INTO l_lpn_id_tab
4655: FROM WMS_LICENSE_PLATE_NUMBERS
4656: WHERE lpn_id IN ( SELECT DISTINCT lpn_id
4657: FROM wms_putaway_group_tasks_gtmp
4658: WHERE row_type = G_ROW_TP_ALL_TASK
4659: AND lpn_context <> 3

Line 4812: FROM wms_license_plate_numbers

4808:
4809: --BUG 3495726 Issue 25: Unpack from parent LPN first
4810: SELECT parent_lpn_id
4811: INTO l_parent_lpn_id
4812: FROM wms_license_plate_numbers
4813: WHERE lpn_id = p_lpn_id;
4814:
4815: IF (l_parent_lpn_id IS NOT NULL) THEN
4816: IF (l_debug = 1) THEN

Line 5300: FROM WMS_LICENSE_PLATE_NUMBERS START WITH LPN_ID = p_lpn_id CONNECT BY PRIOR LPN_ID = PARENT_LPN_ID ) WLPN,

5296: SELECT /*+ ORDERED USE_NL(WLPN MTRL MMTT) INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */
5297: MMTT.TRANSACTION_TEMP_ID
5298: FROM
5299: ( SELECT LPN_ID
5300: FROM WMS_LICENSE_PLATE_NUMBERS START WITH LPN_ID = p_lpn_id CONNECT BY PRIOR LPN_ID = PARENT_LPN_ID ) WLPN,
5301: MTL_TXN_REQUEST_LINES MTRL,
5302: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
5303: WHERE MTRL.LINE_ID = MMTT.MOVE_ORDER_LINE_ID
5304: AND LINE_STATUS = 7

Line 5793: ,(SELECT lpn_id FROM wms_license_plate_numbers /Bug5723418./

5789: SELECT mmtt.transaction_temp_id
5790: FROM mtl_material_transactions_temp mmtt
5791: ,mtl_txn_request_lines mtrl
5792: ,wms_dispatched_tasks wdt
5793: ,(SELECT lpn_id FROM wms_license_plate_numbers /*Bug5723418.*/
5794: START WITH lpn_id = p_lpn_id
5795: CONNECT BY PRIOR lpn_id = parent_lpn_id
5796: ) wlpn
5797: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 5843: FROM wms_license_plate_numbers

5839: (p_group_id = -1))
5840: AND wdt.STATUS = 4
5841: AND wdt.task_type = 2
5842: AND mtrl.lpn_id IN (SELECT lpn_id
5843: FROM wms_license_plate_numbers
5844: START WITH lpn_id = l_outermost_lpn_id
5845: CONNECT BY PRIOR lpn_id = parent_lpn_id
5846: )
5847: AND ((mmtt.operation_plan_id IS NOT NULL

Line 5915: FROM wms_license_plate_numbers

5911: SELECT outermost_lpn_id
5912: , lpn_context
5913: INTO l_outermost_lpn_id
5914: , l_lpn_context
5915: FROM wms_license_plate_numbers
5916: WHERE lpn_id = p_lpn_id;
5917: EXCEPTION
5918: WHEN OTHERS THEN
5919: IF (l_debug = 1) THEN

Line 5997: FROM wms_license_plate_numbers

5993: BEGIN
5994:
5995: SELECT lpn_context
5996: INTO l_lpn_cxt
5997: FROM wms_license_plate_numbers
5998: WHERE lpn_id= p_lpn_id ;
5999:
6000: IF p_parent_lpn_id is not null THEN
6001: SELECT lpn_context

Line 6003: FROM wms_license_plate_numbers

5999:
6000: IF p_parent_lpn_id is not null THEN
6001: SELECT lpn_context
6002: INTO l_parent_lpn_cxt
6003: FROM wms_license_plate_numbers
6004: WHERE lpn_id= p_parent_lpn_id ;
6005: END IF;
6006:
6007: EXCEPTION

Line 6112: FROM wms_license_plate_numbers

6108: IF (l_lpn_context IS NULL) THEN
6109: BEGIN
6110: SELECT lpn_context
6111: INTO l_lpn_context
6112: FROM wms_license_plate_numbers
6113: WHERE lpn_id = p_lpn_id;
6114: EXCEPTION
6115: WHEN OTHERS THEN
6116: IF (l_debug = 1) THEN

Line 6494: FROM wms_license_plate_numbers

6490: l_mmtt_qty NUMBER := 0; -- Added for bug 14723445
6491:
6492: CURSOR lpn_cursor IS
6493: SELECT lpn_id
6494: FROM wms_license_plate_numbers
6495: WHERE lpn_id <> p_lpn_id
6496: START WITH lpn_id = p_lpn_id
6497: CONNECT BY parent_lpn_id = PRIOR lpn_id;
6498: BEGIN

Line 6516: FROM wms_license_plate_numbers

6512:
6513: -- Get LPN Context
6514: SELECT lpn_context,subinventory_code,locator_id
6515: INTO x_lpn_context,l_lpn_sub,l_lpn_loc
6516: FROM wms_license_plate_numbers
6517: WHERE lpn_id = p_lpn_id;
6518:
6519: --BUG 3473899: p_mode = 2 => it is coming from MANUAL_LOAD
6520: --check the material status, and see if a sub transfer is allowed

Line 6568: FROM wms_license_plate_numbers wlpn

6564: FROM mtl_txn_request_lines mtrl,
6565: mtl_material_transactions_temp mmtt,
6566: wms_op_operation_instances wooi ,
6567: (SELECT wlpn.lpn_id /*5723418*/
6568: FROM wms_license_plate_numbers wlpn
6569: START WITH wlpn.lpn_id = p_lpn_id
6570: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id) wlpn
6571: WHERE mtrl.lpn_id = wlpn.lpn_id
6572: AND mmtt.move_order_line_id = mtrl.line_id

Line 6777: Wms_License_Plate_Numbers wlpn

6773: --Bug#6920388.Added IF block below.
6774: BEGIN
6775: SELECT COUNT(1) INTO l_invalid_cnt
6776: FROM Mtl_material_transactions_temp mmtt,
6777: Wms_License_Plate_Numbers wlpn
6778: WHERE mmtt.organization_id=p_org_id
6779: AND mmtt.wms_task_type <> WMS_GLOBALS.g_wms_task_type_putaway
6780: AND wlpn.outermost_lpn_id = p_lpn_id
6781: AND wlpn.organization_id = p_org_id

Line 6971: FROM Wms_license_plate_numbers wlpn

6967:
6968: IF ( x_ret in (0,1) and x_loaded_status = 'N' ) THEN
6969: Detach_Loaded_Lpns(p_lpn_id,p_org_id); --6920388
6970: SELECT lpn_context INTO l_lpn_context
6971: FROM Wms_license_plate_numbers wlpn
6972: WHERE wlpn.lpn_id=p_lpn_id
6973: AND wlpn.organization_id=p_org_id;
6974: IF l_lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED THEN
6975: debug('There is no LPN content available for this transaction.');

Line 7054: FROM wms_license_plate_numbers

7050: l_msg_data VARCHAR2(1200);
7051: l_wlc_without_mmtt NUMBER := 0; --BUG12681832
7052: CURSOR lpn_cursor IS
7053: SELECT lpn_id
7054: FROM wms_license_plate_numbers
7055: START WITH lpn_id = p_lpn_id
7056: CONNECT BY parent_lpn_id = PRIOR lpn_id;
7057: BEGIN
7058:

Line 7143: (SELECT lpn_id FROM wms_license_plate_numbers

7139: --BUG12681832 Begin
7140: IF (NOT WMS_RE_Custom_PUB.PutawayPartialDetailedLPN(p_lpn_id)) THEN
7141: BEGIN
7142: select count(1) INTO l_wlc_without_mmtt from
7143: (SELECT lpn_id FROM wms_license_plate_numbers
7144: START WITH lpn_id = p_lpn_id
7145: CONNECT BY PRIOR lpn_id = parent_lpn_id ) wlpn ,
7146: wms_lpn_contents wlc
7147: where

Line 7405: FROM wms_license_plate_numbers

7401: END IF;
7402:
7403: SELECT parent_lpn_id,lpn_context
7404: INTO l_parent_lpn_id,l_lpn_context
7405: FROM wms_license_plate_numbers
7406: WHERE lpn_id = p_from_lpn_id;
7407:
7408: IF (p_to_lpn_id IS NOT NULL AND p_to_lpn_id <> 0) THEN
7409: l_progress := 20;

Line 7413: FROM wms_license_plate_numbers

7409: l_progress := 20;
7410: BEGIN
7411: SELECT lpn_context,subinventory_code,locator_id
7412: INTO l_to_context,l_to_sub,l_to_loc
7413: FROM wms_license_plate_numbers
7414: WHERE lpn_id = p_to_lpn_id;
7415: EXCEPTION
7416: WHEN OTHERS THEN
7417: l_to_context := -1;

Line 7738: FROM wms_license_plate_numbers wlpn

7734: SELECT /*+ ORDERED INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */ 1
7735: INTO l_discrepancy
7736: FROM
7737: (SELECT wlpn.lpn_id /*5723418*/
7738: FROM wms_license_plate_numbers wlpn
7739: START WITH wlpn.lpn_id = p_from_lpn_id
7740: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id) wlpn,
7741: mtl_txn_request_lines mtrl -- Bug 14372071
7742: WHERE mtrl.lpn_id = wlpn.lpn_id

Line 7826: FROM wms_license_plate_numbers wlpn

7822: AND mmtt.move_order_line_id IN
7823: ( SELECT mtrl.line_id
7824: FROM mtl_txn_request_lines mtrl ,
7825: (SELECT wlpn.lpn_id /* 5723418 */
7826: FROM wms_license_plate_numbers wlpn
7827: START WITH wlpn.lpn_id = p_from_lpn_id
7828: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id) wlpn
7829: WHERE mtrl.organization_id = p_org_id
7830: AND mtrl.lpn_id = wlpn.lpn_id );

Line 8366: FROM wms_license_plate_numbers

8362:
8363:
8364: CURSOR lpn_cursor IS
8365: SELECT lpn_id
8366: FROM wms_license_plate_numbers
8367: WHERE parent_lpn_id = p_from_lpn_id;
8368:
8369: l_batch_seq NUMBER := p_batch_seq;
8370:

Line 8391: FROM wms_license_plate_numbers

8387: ,locator_id
8388: INTO p_parent_lpn_id
8389: ,l_lpn_sub
8390: ,l_lpn_loc
8391: FROM wms_license_plate_numbers
8392: WHERE lpn_id = p_from_lpn_id;
8393: EXCEPTION
8394: WHEN OTHERS THEN
8395: IF (l_debug = 1) THEN

Line 8628: FROM wms_license_plate_numbers

8624: l_lpn_id NUMBER;
8625:
8626: CURSOR lpn_cursor IS
8627: SELECT lpn_id
8628: FROM wms_license_plate_numbers
8629: WHERE parent_lpn_id = p_from_lpn_id;
8630:
8631: l_batch_seq NUMBER := p_batch_seq; --BUG 3544918
8632: BEGIN

Line 8868: wms_license_plate_numbers

8864: ,l_org_id
8865: ,l_sub_code
8866: ,l_loc_id
8867: FROM
8868: wms_license_plate_numbers
8869: WHERE
8870: lpn_id = p_from_lpn_id;
8871: EXCEPTION
8872: WHEN OTHERS THEN

Line 8874: DEBUG('from LPN not found in WMS_LICENSE_PLATE_NUMBERS',

8870: lpn_id = p_from_lpn_id;
8871: EXCEPTION
8872: WHEN OTHERS THEN
8873: IF (l_debug = 1) THEN
8874: DEBUG('from LPN not found in WMS_LICENSE_PLATE_NUMBERS',
8875: 'transfer_contents',9);
8876: END IF;
8877: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
8878: fnd_msg_pub.ADD;

Line 8894: wms_license_plate_numbers

8890: l_into_context
8891: ,l_to_sub
8892: ,l_to_loc
8893: FROM
8894: wms_license_plate_numbers
8895: WHERE
8896: lpn_id = p_into_lpn_id;
8897: EXCEPTION
8898: WHEN OTHERS THEN

Line 8900: DEBUG('INTO LPN not found in WMS_LICENSE_PLATE_NUMBERS',

8896: lpn_id = p_into_lpn_id;
8897: EXCEPTION
8898: WHEN OTHERS THEN
8899: IF (l_debug = 1) THEN
8900: DEBUG('INTO LPN not found in WMS_LICENSE_PLATE_NUMBERS',
8901: 'transfer_contents',9);
8902: END IF;
8903: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
8904: fnd_msg_pub.ADD;

Line 8983: FROM wms_license_plate_numbers wlpn

8979: SELECT /*+ ORDERED INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */ 1
8980: INTO l_count
8981: FROM
8982: (SELECT wlpn.lpn_id /*5723418*/
8983: FROM wms_license_plate_numbers wlpn
8984: START WITH wlpn.lpn_id = p_from_lpn_id
8985: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id ) wlpn,
8986: mtl_txn_request_lines mtrl -- Bug 14372071
8987: WHERE mtrl.lpn_id = wlpn.lpn_id

Line 9055: FROM wms_license_plate_numbers wlpn

9051: mmtt.move_order_line_id --BUG 3435079: use org_id for performace reason
9052: IN ( SELECT mtrl.line_id
9053: FROM mtl_txn_request_lines mtrl,
9054: ( SELECT wlpn.lpn_id /*5723418*/
9055: FROM wms_license_plate_numbers wlpn
9056: START WITH wlpn.lpn_id = p_from_lpn_id
9057: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id ) wlpn
9058: WHERE mtrl.organization_id = l_org_id
9059: --BUG 3435079: use org_id for performace reason

Line 9097: FROM wms_license_plate_numbers wlpn

9093: mmtt.move_order_line_id --BUG 3435079: use org_id for performace reason
9094: IN ( SELECT mtrl.line_id
9095: FROM mtl_txn_request_lines mtrl ,
9096: (SELECT wlpn.lpn_id /*5723418*/
9097: FROM wms_license_plate_numbers wlpn
9098: START WITH wlpn.lpn_id = p_from_lpn_id
9099: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id ) wlpn
9100: WHERE mtrl.organization_id = l_org_id AND --BUG 3435079: use org_id for performace reason
9101: mtrl.lpn_id = wlpn.lpn_id );

Line 9272: FROM wms_license_plate_numbers wlpn

9268: SET
9269: wms_process_flag = 2
9270: WHERE
9271: lpn_id IN (SELECT wlpn.lpn_id
9272: FROM wms_license_plate_numbers wlpn
9273: START WITH wlpn.lpn_id = p_from_lpn_id
9274: CONNECT BY PRIOR wlpn.lpn_id =
9275: wlpn.parent_lpn_id);
9276: EXCEPTION

Line 9331: FROM wms_license_plate_numbers

9327:
9328: BEGIN
9329: SELECT lpn_id
9330: bulk collect INTO l_lpn_ids
9331: FROM wms_license_plate_numbers
9332: WHERE parent_lpn_id = p_from_lpn_id;
9333: EXCEPTION
9334: WHEN OTHERS THEN
9335: IF (l_debug = 1) THEN

Line 9580: FROM wms_license_plate_numbers

9576: -- Now deal with Nested LPN. For now, there should be none
9577: BEGIN
9578: SELECT lpn_id
9579: bulk collect INTO l_lpn_ids
9580: FROM wms_license_plate_numbers
9581: WHERE parent_lpn_id = p_from_lpn_id;
9582: EXCEPTION
9583: WHEN OTHERS THEN
9584: IF (l_debug = 1) THEN

Line 9786: FROM wms_license_plate_numbers

9782: -- Deal with Nested LPN first
9783: BEGIN
9784: SELECT lpn_id
9785: bulk collect INTO l_lpn_ids
9786: FROM wms_license_plate_numbers
9787: WHERE parent_lpn_id = p_from_lpn_id;
9788: EXCEPTION
9789: WHEN OTHERS THEN
9790: IF (l_debug = 1) THEN

Line 10278: FROM wms_license_plate_numbers wlpn

10274: , mtl_txn_request_headers mtrh
10275: , mtl_system_items_kfv msi
10276: , ( /*5723418*/
10277: SELECT wlpn.lpn_id
10278: FROM wms_license_plate_numbers wlpn
10279: START WITH wlpn.lpn_id = p_lpn_id
10280: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id
10281: ) wlpn
10282: WHERE mtrh.organization_id = p_organization_id

Line 10361: l_to_lpn_name wms_license_plate_numbers.license_plate_number%TYPE;

10357: l_subinventory_code mtl_secondary_inventories.secondary_inventory_name%TYPE;
10358: l_locator_id NUMBER; --Locator for complete_putaway
10359: l_lpn_id NUMBER; --p_LPN_ID for complete_putaway???--check
10360: l_to_lpn_id NUMBER; --To LPN ID -- for pack/unpack
10361: l_to_lpn_name wms_license_plate_numbers.license_plate_number%TYPE;
10362: l_revision mtl_item_revisions.revision%TYPE; --p_rev for complete_putaway
10363: l_lot_number mtl_lot_numbers.lot_number%type; --p_lot for complete_putaway
10364: l_mmtt_prm_qty NUMBER; --Lot quantity in primary uom
10365: l_lot_expiration_date DATE; --Lot expiration date

Line 11783: FROM wms_license_plate_numbers

11779: ELSE
11780: --Replace this with LPN_NAME from global_temp table for this task
11781: SELECT license_plate_number
11782: INTO l_to_lpn_name
11783: FROM wms_license_plate_numbers
11784: WHERE lpn_id = l_mol_lpn_id_tbl(i);
11785: END IF; --END IF check MOL LPN and confirmed LPN
11786: END IF; --END IF check lpn_controlled_flag for the sub
11787:

Line 12348: FROM wms_license_plate_numbers

12344:
12345: -- Get the required LPN values
12346: SELECT lpn_context, subinventory_code, locator_id
12347: INTO l_lpn_context, l_lpn_sub, l_lpn_loc_id
12348: FROM wms_license_plate_numbers
12349: WHERE organization_id = p_organization_id
12350: AND lpn_id = p_lpn_id;
12351: l_progress := '20';
12352: IF (l_debug = 1) THEN

Line 12364: FROM wms_license_plate_numbers

12360: BEGIN
12361: SELECT 1, lpn_id, subinventory_code, locator_id, lpn_context,outermost_lpn_id
12362: INTO l_count, l_into_lpn_id, l_into_lpn_sub, l_into_lpn_loc_id, l_into_lpn_context,
12363: l_into_outermost_lpn_id
12364: FROM wms_license_plate_numbers
12365: WHERE license_plate_number = p_into_lpn
12366: AND organization_id = p_organization_id
12367: FOR UPDATE OF lpn_id NOWAIT;
12368: -- lock so no other user can load into this lpn

Line 12478: FROM wms_license_plate_numbers wlpn1

12474: select NVL(count(1),0)
12475: into l_lpn_has_material
12476: FROM wms_lpn_contents
12477: WHERE parent_lpn_id IN (SELECT wlpn1.lpn_id
12478: FROM wms_license_plate_numbers wlpn1
12479: START WITH wlpn1.lpn_id = l_into_outermost_lpn_id
12480: CONNECT BY PRIOR wlpn1.lpn_id = wlpn1.parent_lpn_id);
12481:
12482: SELECT 1

Line 12487: FROM wms_license_plate_numbers wlpn

12483: INTO l_count
12484: FROM dual
12485: WHERE EXISTS
12486: (SELECT 'INTO_LPN_EXISTS'
12487: FROM wms_license_plate_numbers wlpn
12488: WHERE wlpn.organization_id = p_organization_id
12489: AND wlpn.lpn_id <> p_lpn_id
12490: AND wlpn.lpn_id = l_into_lpn_id
12491: AND (wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED

Line 12498: -- FROM wms_license_plate_numbers wlpn1

12494: ( l_lpn_has_material = 0
12495: --NOT EXISTS (SELECT 'LPN_HAS_MATERIAL'
12496: --FROM wms_lpn_contents
12497: --WHERE parent_lpn_id IN (SELECT wlpn1.lpn_id
12498: -- FROM wms_license_plate_numbers wlpn1
12499: -- START WITH wlpn1.lpn_id = wlpn.outermost_lpn_id
12500: -- CONNECT BY PRIOR wlpn1.lpn_id = wlpn1.parent_lpn_id)
12501: --)
12502: )

Line 12524: FROM wms_license_plate_numbers

12520: AND wdt.status = 4
12521: AND wdt.person_id = p_employee_id
12522: AND mtrl.line_id = mmtt.move_order_line_id--5650113
12523: AND mtrl.lpn_id IN (SELECT lpn_id--5650113
12524: FROM wms_license_plate_numbers
12525: START WITH lpn_id = wlpn.outermost_lpn_id
12526: CONNECT BY PRIOR lpn_id = parent_lpn_id
12527: )
12528: )

Line 12819: from wms_license_plate_numbers wln

12815: and drop_type='ID'
12816: and row_type = 'Group Task'
12817: and not exists
12818: (select 1
12819: from wms_license_plate_numbers wln
12820: where wln.parent_lpn_id = p_lpn_id);
12821: EXCEPTION
12822: WHEN OTHERS THEN
12823: l_item_count :=2;

Line 12849: debug(' quantity from wms license plate Numbers ' || l_qty_wlc);

12845:
12846: IF (l_qty_gtmp<>l_qty_wlc) THEN
12847: IF (l_debug = 1) THEN
12848: debug(' quantity from global temp table ' || l_qty_gtmp);
12849: debug(' quantity from wms license plate Numbers ' || l_qty_wlc);
12850: debug('Given LPN is not fully allocated!','validate_into_lpn',9);
12851: END IF;
12852: x_validation_passed := 'N';
12853: RETURN;

Line 12870: FROM wms_license_plate_numbers wlpn

12866: SELECT 1 INTO l_count
12867: FROM DUAL
12868: WHERE EXISTS (
12869: SELECT 'INTO_LPN_EXISTS'
12870: FROM wms_license_plate_numbers wlpn
12871: WHERE wlpn.organization_id = p_organization_id
12872: AND wlpn.lpn_id = l_into_lpn_id
12873: AND (wlpn.lpn_context = 5 OR
12874: ((wlpn.lpn_context = 1 AND l_lpn_context IN (1,2) ) OR

Line 12886: FROM wms_license_plate_numbers wlpn2

12882: AND wdt.organization_id = p_organization_id
12883: AND wdt.task_type = 2
12884: AND wdt.status = 4
12885: AND mmtt.lpn_id IN (SELECT wlpn2.lpn_id
12886: FROM wms_license_plate_numbers wlpn2
12887: START WITH wlpn2.lpn_id = wlpn.outermost_lpn_id
12888: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
12889: )
12890: )

Line 13179: FROM wms_license_plate_numbers

13175: l_into_lpn_project_id
13176: ,l_into_lpn_task_id
13177: FROM
13178: mtl_txn_request_lines mtrl, (SELECT lpn_id
13179: FROM wms_license_plate_numbers
13180: START WITH lpn_id = l_into_lpn_id
13181: CONNECT BY PRIOR lpn_id = parent_lpn_id
13182: ) wlpn2
13183: WHERE

Line 13312: wms_license_plate_numbers

13308: SELECT
13309: lpn_id,
13310: organization_id
13311: FROM
13312: wms_license_plate_numbers
13313: START WITH lpn_id = p_lpn_id
13314: CONNECT BY PRIOR lpn_id = parent_lpn_id
13315: )
13316: wlpn,

Line 13334: wms_license_plate_numbers

13330: SELECT
13331: lpn_id,
13332: organization_id
13333: FROM
13334: wms_license_plate_numbers
13335: START WITH lpn_id = p_lpn_id
13336: CONNECT BY PRIOR lpn_id = parent_lpn_id
13337: )
13338: wlpn,

Line 13359: wms_license_plate_numbers

13355: (
13356: SELECT
13357: lpn_id
13358: FROM
13359: wms_license_plate_numbers
13360: START WITH lpn_id = p_lpn_id
13361: CONNECT BY PRIOR lpn_id = parent_lpn_id
13362: )
13363: AND organization_id = l_org_id ;

Line 13382: wms_license_plate_numbers

13378: (
13379: SELECT
13380: lpn_id
13381: FROM
13382: wms_license_plate_numbers
13383: START WITH lpn_id = p_lpn_id
13384: CONNECT BY PRIOR lpn_id = parent_lpn_id
13385: )
13386: AND organization_id = l_org_id

Line 13406: wms_license_plate_numbers

13402: (
13403: SELECT
13404: lpn_id
13405: FROM
13406: wms_license_plate_numbers
13407: START WITH lpn_id = p_lpn_id
13408: CONNECT BY PRIOR lpn_id = parent_lpn_id
13409: )
13410: AND organization_id = l_org_id

Line 13433: wms_license_plate_numbers

13429: (
13430: SELECT
13431: lpn_id
13432: FROM
13433: wms_license_plate_numbers
13434: START WITH lpn_id = p_lpn_id
13435: CONNECT BY PRIOR lpn_id = parent_lpn_id
13436: )
13437: AND organization_id = l_org_id

Line 13456: wms_license_plate_numbers wlpn,

13452: IS
13453: SELECT
13454: 1
13455: FROM
13456: wms_license_plate_numbers wlpn,
13457: mtl_txn_request_lines mtrl
13458: WHERE
13459: wlpn.lpn_id = mtrl.lpn_id
13460: AND

Line 13470: wms_license_plate_numbers

13466: (
13467: SELECT
13468: lpn_id
13469: FROM
13470: wms_license_plate_numbers
13471: START WITH lpn_id = p_lpn_id
13472: CONNECT BY PRIOR lpn_id = parent_lpn_id
13473: )
13474: AND wlpn.organization_id = l_org_id

Line 13524: wms_license_plate_numbers

13520: organization_id
13521: INTO
13522: l_org_id
13523: FROM
13524: wms_license_plate_numbers
13525: WHERE
13526: lpn_id = p_lpn_id ;
13527:
13528:

Line 13688: wms_license_plate_numbers

13684: (
13685: SELECT
13686: lpn_id
13687: FROM
13688: wms_license_plate_numbers
13689: START WITH lpn_id = p_lpn_id
13690: CONNECT BY PRIOR lpn_id = parent_lpn_id
13691: );
13692:

Line 13721: wms_license_plate_numbers

13717: (
13718: SELECT
13719: lpn_id
13720: FROM
13721: wms_license_plate_numbers
13722: START WITH lpn_id IN (p_lpn_id)
13723: CONNECT BY PRIOR lpn_id = parent_lpn_id
13724: )
13725: AND organization_id = l_org_id

Line 13781: wms_license_plate_numbers

13777: (
13778: SELECT
13779: lpn_id
13780: FROM
13781: wms_license_plate_numbers
13782: START WITH lpn_id IN (p_lpn_id)
13783: CONNECT BY PRIOR lpn_id = parent_lpn_id
13784: )
13785: AND organization_id = l_org_id

Line 13814: wms_license_plate_numbers

13810: (
13811: SELECT
13812: lpn_id
13813: FROM
13814: wms_license_plate_numbers
13815: START WITH lpn_id IN (p_lpn_id)
13816: CONNECT BY PRIOR lpn_id = parent_lpn_id
13817: )
13818: AND organization_id = l_org_id

Line 13847: wms_license_plate_numbers

13843: (
13844: SELECT
13845: lpn_id
13846: FROM
13847: wms_license_plate_numbers
13848: START WITH lpn_id IN (p_lpn_id)
13849: CONNECT BY PRIOR lpn_id = parent_lpn_id
13850: )
13851: AND organization_id = l_org_id

Line 13880: wms_license_plate_numbers

13876: (
13877: SELECT
13878: lpn_id
13879: FROM
13880: wms_license_plate_numbers
13881: START WITH lpn_id IN (p_lpn_id)
13882: CONNECT BY PRIOR lpn_id = parent_lpn_id
13883: )
13884: AND organization_id = l_org_id

Line 13945: wms_license_plate_numbers

13941: (
13942: SELECT
13943: lpn_id
13944: FROM
13945: wms_license_plate_numbers
13946: START WITH lpn_id IN (p_lpn_id)
13947: CONNECT BY PRIOR lpn_id = parent_lpn_id
13948: )
13949: AND organization_id = l_org_id

Line 13989: wms_license_plate_numbers

13985: (
13986: SELECT
13987: lpn_id
13988: FROM
13989: wms_license_plate_numbers
13990: START WITH lpn_id IN (p_lpn_id)
13991: CONNECT BY PRIOR lpn_id = parent_lpn_id
13992: )
13993: AND organization_id = l_org_id

Line 14055: wms_license_plate_numbers

14051: (
14052: SELECT
14053: lpn_id
14054: FROM
14055: wms_license_plate_numbers
14056: START WITH lpn_id IN (p_lpn_id)
14057: CONNECT BY PRIOR lpn_id = parent_lpn_id
14058: )
14059: AND organization_id = l_org_id

Line 14089: wms_license_plate_numbers

14085: (
14086: SELECT
14087: lpn_id
14088: FROM
14089: wms_license_plate_numbers
14090: START WITH lpn_id IN (p_lpn_id)
14091: CONNECT BY PRIOR lpn_id = parent_lpn_id
14092: )
14093: AND organization_id = l_org_id

Line 14131: wms_license_plate_numbers

14127: (
14128: SELECT
14129: lpn_id
14130: FROM
14131: wms_license_plate_numbers
14132: START WITH lpn_id IN (p_lpn_id)
14133: CONNECT BY PRIOR lpn_id = parent_lpn_id
14134: )
14135: AND organization_id = l_org_id

Line 14277: FROM wms_license_plate_numbers wlpn

14273: FROM
14274: mtl_txn_request_lines mol,
14275: mtl_material_transactions_temp mmtt ,
14276: (SELECT wlpn.lpn_id /*5723418*/
14277: FROM wms_license_plate_numbers wlpn
14278: START WITH wlpn.lpn_id = p_lpn_id
14279: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id ) wlpn
14280: WHERE mol.lpn_id = wlpn.lpn_id
14281: AND mol.organization_id = p_organization_id

Line 14371: FROM wms_license_plate_numbers

14367: , mmtt.transaction_uom
14368: FROM mtl_material_transactions_temp mmtt,
14369: mtl_txn_request_lines mtrl ,
14370: (SELECT lpn_id /*5723418*/
14371: FROM wms_license_plate_numbers
14372: START WITH lpn_id = p_lpn_id
14373: CONNECT BY PRIOR lpn_id = parent_lpn_id) wlpn
14374: WHERE mmtt.move_order_line_id = mtrl.line_id
14375: AND mmtt.organization_id = p_organization_id

Line 14759: FROM wms_license_plate_numbers

14755:
14756:
14757: CURSOR lpn_cursor IS
14758: SELECT lpn_id
14759: FROM wms_license_plate_numbers
14760: START WITH lpn_id = p_lpn_id
14761: CONNECT BY parent_lpn_id = PRIOR lpn_id;
14762:
14763: CURSOR c_mmtt_cursor(p_lpn number) IS

Line 14804: FROM wms_license_plate_numbers

14800:
14801: -- Get LPN Context
14802: SELECT lpn_context
14803: INTO l_lpn_context
14804: FROM wms_license_plate_numbers
14805: WHERE lpn_id = p_lpn_id;
14806:
14807: l_progress := 20;
14808: