APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1197: FROM wms_license_plate_numbers

1193: -- only receiving or WIP.
1194:
1195: SELECT lpn_context
1196: INTO l_lpn_context
1197: FROM wms_license_plate_numbers
1198: WHERE lpn_id = l_lpn_id
1199: AND organization_id = p_org_id;
1200:
1201: -- ATF_J2 moved crossdock call to after cleanup_suggestions

Line 1324: FROM wms_license_plate_numbers

1320: SELECT subinventory_code
1321: , locator_id
1322: INTO l_m_sub
1323: , l_m_loc
1324: FROM wms_license_plate_numbers
1325: WHERE lpn_id = l_lpn_id;
1326:
1327: -- Need to close those old MOL lines
1328: -- for inventory LPN

Line 3757: FROM wms_license_plate_numbers

3753: */
3754: -- Check to see if its a receipt LPN
3755: SELECT lpn_context
3756: INTO l_lpn_context
3757: FROM wms_license_plate_numbers
3758: WHERE lpn_id = p_lpn_id;
3759:
3760: IF l_lpn_context = 3 THEN
3761: IF (l_debug =1) THEN

Line 3886: FROM wms_license_plate_numbers

3882: SELECT 1
3883: INTO l_exist_lpn
3884: FROM DUAL
3885: WHERE EXISTS(SELECT 1
3886: FROM wms_license_plate_numbers
3887: WHERE license_plate_number = p_to_lpn
3888: AND organization_id = p_org_id);
3889: EXCEPTION
3890: WHEN NO_DATA_FOUND THEN

Line 3954: FROM wms_license_plate_numbers

3950: ELSE
3951: -- LPN exists. Get LPN ID
3952: SELECT lpn_id
3953: INTO l_to_lpn_id
3954: FROM wms_license_plate_numbers
3955: WHERE license_plate_number = p_to_lpn
3956: AND organization_id = p_org_id;
3957: END IF;
3958: END IF;

Line 5833: FROM wms_license_plate_numbers

5829: --get the context
5830: BEGIN
5831: SELECT lpn_context
5832: INTO l_lpn_context
5833: FROM wms_license_plate_numbers
5834: WHERE lpn_id = l_lpn_id
5835: AND organization_id = l_org_id;
5836: EXCEPTION
5837: WHEN NO_DATA_FOUND THEN

Line 5860: FROM wms_license_plate_numbers

5856: -- current session from hanging (bug 1724818).
5857: BEGIN
5858: SELECT lpn_id
5859: INTO l_dummy
5860: FROM wms_license_plate_numbers
5861: WHERE lpn_id = l_lpn_id
5862: AND organization_id = l_org_id
5863: FOR UPDATE NOWAIT;
5864: EXCEPTION

Line 6819: FROM wms_license_plate_numbers wlpn

6815: SELECT 1
6816: , lpn_id
6817: INTO l_count
6818: , l_to_lpn_id
6819: FROM wms_license_plate_numbers wlpn
6820: WHERE wlpn.license_plate_number = p_to_lpn
6821: AND wlpn.organization_id = p_org_id;
6822: EXCEPTION
6823: WHEN NO_DATA_FOUND THEN

Line 6939: FROM wms_license_plate_numbers wlpn

6935: INTO l_count
6936: FROM DUAL
6937: WHERE EXISTS(
6938: SELECT 1
6939: FROM wms_license_plate_numbers wlpn
6940: WHERE wlpn.organization_id = p_org_id
6941: AND license_plate_number = p_to_lpn
6942: AND (
6943: wlpn.lpn_context = 5

Line 7049: FROM wms_license_plate_numbers wlc

7045: END IF;
7046:
7047: SELECT wlc.lpn_context
7048: INTO l_lpn_context
7049: FROM wms_license_plate_numbers wlc
7050: WHERE wlc.license_plate_number = p_to_lpn
7051: AND wlc.organization_id = p_org_id;
7052:
7053: IF (l_debug = 1) THEN

Line 7080: --UPDATE wms_license_plate_numbers

7076:
7077: l_lpn_update := NULL;
7078:
7079: -- 4411792 The below is replaced by the above API call
7080: --UPDATE wms_license_plate_numbers
7081: --SET lpn_context = wms_container_pub.lpn_context_inv
7082: --WHERE license_plate_number = p_to_lpn
7083: --AND organization_id = p_org_id;
7084:

Line 7420: FROM wms_license_plate_numbers

7416: -- Create a cursor to loop through all the nested LPNs within
7417: -- the given outer LPN, p_lpn_id.
7418: CURSOR lpn_csr IS
7419: SELECT lpn_id
7420: FROM wms_license_plate_numbers
7421: START WITH lpn_id = p_lpn_id
7422: CONNECT BY PRIOR lpn_id = parent_lpn_id;
7423: l_current_lpn_id NUMBER;
7424:

Line 7481: wms_license_plate_numbers wlc

7477: AND EXISTS
7478: (SELECT 1
7479: FROM
7480: mtl_txn_request_headers moh,
7481: wms_license_plate_numbers wlc
7482: WHERE mol.header_id = moh.header_id
7483: AND moh.move_order_type = inv_globals.g_move_order_put_away
7484: AND wlc.lpn_id = mol.lpn_id
7485: AND wlc.lpn_context = 1);

Line 7501: FROM wms_license_plate_numbers

7497: SELECT subinventory_code
7498: , locator_id
7499: INTO l_m_sub
7500: , l_m_loc
7501: FROM wms_license_plate_numbers
7502: WHERE lpn_id = l_lpn_id;
7503:
7504: SELECT mil.project_id
7505: , mil.task_id

Line 7642: FROM wms_license_plate_numbers

7638: l_mmtt_primary_qty NUMBER;
7639:
7640: CURSOR lpn_cur IS
7641: SELECT lpn_id
7642: FROM wms_license_plate_numbers
7643: START WITH lpn_id = p_lpn_id
7644: CONNECT BY parent_lpn_id = PRIOR lpn_id;
7645:
7646: BEGIN

Line 8086: FROM wms_license_plate_numbers

8082: -- Bug# 3281512 - Performance Fixes
8083: -- Cursor to retrieve the nested LPNs within a given outer LPN
8084: CURSOR nested_lpn_cursor IS
8085: SELECT lpn_id
8086: FROM wms_license_plate_numbers
8087: START WITH lpn_id = p_lpn_id
8088: CONNECT BY PRIOR lpn_id = parent_lpn_id;
8089: l_current_lpn_id NUMBER;
8090:

Line 8233: FROM wms_license_plate_numbers

8229: mtl_txn_request_lines mtrl
8230: WHERE mmtt.organization_id = p_organization_id
8231: AND mmtt.move_order_line_id = mtrl.line_id
8232: AND mtrl.lpn_id IN (SELECT lpn_id
8233: FROM wms_license_plate_numbers
8234: START WITH lpn_id = p_lpn_id
8235: CONNECT BY parent_lpn_id = PRIOR lpn_id);
8236:
8237:

Line 8241: FROM wms_license_plate_numbers

8237:
8238:
8239: SELECT lpn_context,subinventory_code,locator_id
8240: INTO l_lpn_context,l_subinventory,l_locator_id
8241: FROM wms_license_plate_numbers
8242: WHERE lpn_id = p_lpn_id;
8243:
8244: IF l_lpn_context = 1 THEN
8245: -- Inventory LPN so need to create MOLs first

Line 8906: FROM wms_license_plate_numbers

8902: -- Bug# 3434940 - Performance Fixes
8903: -- Cursor to retrieve the nested LPNs within a given outer LPN
8904: CURSOR nested_lpn_cursor IS
8905: SELECT lpn_id
8906: FROM wms_license_plate_numbers
8907: START WITH lpn_id = p_lpn_id
8908: CONNECT BY PRIOR lpn_id = parent_lpn_id;
8909: l_current_lpn_id NUMBER;
8910: