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

Line 838: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

834: WHERE EXISTS
835: ( SELECT 'x'
836: FROM mtl_material_transactions_temp mmtt
837: WHERE mmtt.organization_id = p_org_id
838: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
839: WHERE wlpn.outermost_lpn_id = p_lpn_id));
840:
841:
842: CURSOR c_get_temp_txn_id

Line 864: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

860: SELECT mmtt.transaction_temp_id
861: , mmtt.transaction_type_id
862: FROM mtl_material_transactions_temp mmtt
863: WHERE mmtt.organization_id = p_org_id
864: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
865: WHERE wlpn.outermost_lpn_id = p_lpn_id)
866: AND (mmtt.parent_line_id IS NULL
867: OR
868: (mmtt.parent_line_id IS NOT NULL

Line 890: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

886: , mtl_txn_request_lines mtrl
887: , mtl_txn_request_headers mtrh
888: WHERE mmtt.organization_id = p_org_id
889: --Modified for Bug 6717052
890: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
891: WHERE wlpn.outermost_lpn_id = p_lpn_id))
892: AND mmtt.move_order_line_id = mtrl.line_id
893: AND mtrl.header_id = mtrh.header_id;
894:

Line 903: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

899: SELECT COUNT (DISTINCT mmtt.transaction_action_id)
900: FROM mtl_material_transactions_temp mmtt
901: WHERE mmtt.organization_id = p_org_id
902: --Added for Bug 6717052
903: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
904: WHERE wlpn.outermost_lpn_id = p_lpn_id))
905: AND (mmtt.parent_line_id IS NULL
906: OR
907: (mmtt.parent_line_id IS NOT NULL

Line 938: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

934: , mmtt.transaction_source_type_id
935: , mmtt.transaction_action_id
936: FROM mtl_material_transactions_temp mmtt
937: WHERE mmtt.organization_id = p_org_id
938: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
939: WHERE wlpn.outermost_lpn_id = p_lpn_id)
940: AND (mmtt.parent_line_id IS NULL
941: OR
942: (mmtt.parent_line_id IS NOT NULL

Line 969: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

965: , wsh_delivery_details_ob_grp_v wdd
966: , wsh_delivery_assignments_v wda
967: WHERE mmtt.organization_id = p_org_id
968: --Modified for Bug 6717052
969: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
970: WHERE wlpn.outermost_lpn_id = p_lpn_id))
971: AND ( (mmtt.parent_line_id IS NOT NULL
972: AND
973: mmtt.parent_line_id <> mmtt.transaction_temp_id

Line 1647: FROM wms_license_plate_numbers wlpn

1643: CURSOR c_get_lpn
1644: ( p_lpn_id IN NUMBER
1645: ) IS
1646: SELECT license_plate_number
1647: FROM wms_license_plate_numbers wlpn
1648: WHERE wlpn.lpn_id = p_lpn_id;
1649:
1650:
1651: CURSOR c_chk_nested_bulk

Line 1847: UPDATE wms_license_plate_numbers

1843: FETCH c_get_lpn INTO l_inner_lpn;
1844: CLOSE c_get_lpn;
1845:
1846: -- Bug5659809: update last_update_date and last_update_by as well
1847: UPDATE wms_license_plate_numbers
1848: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
1849: , last_update_date = SYSDATE
1850: , last_updated_by = fnd_global.user_id
1851: WHERE lpn_id = c_mmtt_rec.lpn_id;

Line 2467: UPDATE wms_license_plate_numbers

2463: --Bug6913674
2464:
2465:
2466: -- Bug5659809: update last_update_date and last_update_by as well
2467: UPDATE wms_license_plate_numbers
2468: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2469: , last_update_date = SYSDATE
2470: , last_updated_by = fnd_global.user_id
2471: WHERE lpn_id IN

Line 2495: UPDATE wms_license_plate_numbers

2491:
2492: IF l_loose_exists = 'Y'
2493: THEN
2494: -- Bug5659809: update last_update_date and last_update_by as well
2495: UPDATE wms_license_plate_numbers
2496: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2497: , last_update_date = SYSDATE
2498: , last_updated_by = fnd_global.user_id
2499: WHERE lpn_id IN

Line 4482: FROM wms_license_plate_numbers

4478:
4479: IF x_transfer_lpn_id IS NOT NULL THEN
4480: SELECT license_plate_number
4481: INTO x_transfer_lpn
4482: FROM wms_license_plate_numbers
4483: WHERE lpn_id = x_transfer_lpn_id;
4484: END IF;
4485:
4486: IF l_debug = 1 THEN

Line 4532: , wms_license_plate_numbers wlpn

4528: ) IS
4529: SELECT wlpn.outermost_lpn_id
4530: FROM wsh_delivery_assignments_v wda
4531: , wsh_delivery_details_ob_grp_v wdd
4532: , wms_license_plate_numbers wlpn
4533: WHERE wda.delivery_id = p_deliv_id
4534: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
4535: AND wdd.organization_id = p_org_id
4536: AND wdd.lpn_id = wlpn.lpn_id

Line 4546: FROM wms_license_plate_numbers wlpn

4542: CURSOR c_get_lpn
4543: ( p_lpn_id IN NUMBER
4544: ) IS
4545: SELECT license_plate_number
4546: FROM wms_license_plate_numbers wlpn
4547: WHERE wlpn.lpn_id = p_lpn_id;
4548:
4549: BEGIN
4550: x_return_status := fnd_api.g_ret_sts_success;

Line 5093: FROM wms_license_plate_numbers wlpn

5089: , mmtt.transaction_temp_id
5090: , mmtt.primary_quantity
5091: , mmtt.subinventory_code
5092: , mmtt.locator_id
5093: FROM wms_license_plate_numbers wlpn
5094: , mtl_material_transactions_temp mmtt
5095: WHERE wlpn.license_plate_number = p_inner_lpn
5096: AND wlpn.organization_id = p_org_id
5097: AND mmtt.transfer_lpn_id = p_outer_lpn_id

Line 5263: UPDATE wms_license_plate_numbers

5259:
5260: -- Start change for Bug 5620764
5261: -- Updates LPN context to "Packing Content" since entire LPN is consumed
5262: -- Bug5659809: update last_update_date and last_update_by as well
5263: UPDATE wms_license_plate_numbers
5264: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
5265: , last_update_date = SYSDATE
5266: , last_updated_by = fnd_global.user_id
5267: WHERE lpn_id = l_inner_lpn_id;

Line 6286: FROM wms_license_plate_numbers wlpn

6282: , p_outer_lpn_id IN NUMBER
6283: , p_org_id IN NUMBER
6284: ) IS
6285: SELECT wlpn.lpn_id
6286: FROM wms_license_plate_numbers wlpn
6287: , mtl_material_transactions_temp mmtt
6288: WHERE wlpn.license_plate_number = p_inner_lpn
6289: AND wlpn.organization_id = p_org_id
6290: AND mmtt.transfer_lpn_id = p_outer_lpn_id

Line 7584: UPDATE wms_license_plate_numbers wlpn1

7580:
7581: -- Start change for Bug 5620764
7582: -- Restore LPN context for bulk picked content LPNs back to "Packing Content" from "In Inventory"
7583: -- Bug5659809: update last_update_date and last_update_by as well
7584: UPDATE wms_license_plate_numbers wlpn1
7585: SET wlpn1.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
7586: , last_update_date = SYSDATE
7587: , last_updated_by = fnd_global.user_id
7588: WHERE wlpn1.lpn_id IN

Line 7591: , wms_license_plate_numbers wlpn2

7587: , last_updated_by = fnd_global.user_id
7588: WHERE wlpn1.lpn_id IN
7589: ( SELECT mmtt.content_lpn_id
7590: FROM mtl_material_transactions_temp mmtt
7591: , wms_license_plate_numbers wlpn2
7592: WHERE mmtt.transfer_lpn_id = p_transfer_lpn_id
7593: AND mmtt.organization_id = p_organization_id
7594: AND mmtt.parent_line_id = mmtt.transaction_temp_id
7595: AND mmtt.content_lpn_id = wlpn2.lpn_id

Line 7664: FROM wms_license_plate_numbers

7660: SELECT lpn_id
7661: , lpn_context
7662: , subinventory_code
7663: , locator_id
7664: FROM wms_license_plate_numbers
7665: WHERE organization_id = p_org_id
7666: AND license_plate_number = p_lpn;
7667:
7668: to_lpn_rec c_lpn_info%ROWTYPE;

Line 8979: --UPDATE wms_license_plate_numbers wlpn

8975: END IF;
8976:
8977: -- Start change for Bug 5620764
8978: -- This is not required, since entire LPN is being consumed
8979: --UPDATE wms_license_plate_numbers wlpn
8980: -- SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
8981: -- WHERE wlpn.lpn_id = nested_lpn_rec.content_lpn_id
8982: -- AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
8983: -- AND wlpn.organization_id = p_orgn_id;

Line 9081: FROM wms_license_plate_numbers wlpn

9077: THEN
9078: BEGIN
9079: SELECT wlpn.lpn_id
9080: INTO l_outer_most_lpn_id
9081: FROM wms_license_plate_numbers wlpn
9082: WHERE wlpn.license_plate_number = p_drop_lpn;
9083:
9084: IF l_debug = 1
9085: THEN

Line 9303: AND mmtt.transfer_lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers

9299: mmtt.locator_id,
9300: mmtt.transaction_date
9301: FROM mtl_material_transactions_temp mmtt
9302: WHERE mmtt.organization_id = p_org_id
9303: AND mmtt.transfer_lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers
9304: WHERE outermost_lpn_id = p_lpn_id AND lpn_id <> outermost_lpn_id)
9305: AND mmtt.parent_line_id IS NULL
9306: UNION ALL
9307: -- Loose material

Line 9393: FROM wms_license_plate_numbers wlpn

9389: IF l_debug = 1 THEN print_debug ('find l_drop_lpn_id: ' , l_api_name); END IF;
9390: BEGIN
9391: SELECT wlpn.lpn_id
9392: INTO l_drop_lpn_id
9393: FROM wms_license_plate_numbers wlpn
9394: WHERE wlpn.license_plate_number = p_drop_lpn
9395: AND wlpn.organization_id = p_organization_id
9396: AND ROWNUM=1;
9397: IF l_debug = 1 THEN print_debug ('find l_drop_lpn_id: ' || l_drop_lpn_id , l_api_name); END IF;

Line 9676: UPDATE wms_license_plate_numbers wlpn

9672: --
9673: -- Update LPN context if required
9674: --
9675: -- Bug5659809: update last_update_date and last_update_by as well
9676: UPDATE wms_license_plate_numbers wlpn
9677: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
9678: , last_update_date = SYSDATE
9679: , last_updated_by = fnd_global.user_id
9680: WHERE wlpn.lpn_id = l_curr_xfer_lpn_id

Line 10772: FROM wms_license_plate_numbers wlpn

10768: SELECT wlpn.lpn_id
10769: , wlpn.lpn_context
10770: , wlpn.subinventory_code
10771: , wlpn.locator_id
10772: FROM wms_license_plate_numbers wlpn
10773: WHERE wlpn.license_plate_number = p_lpn
10774: AND wlpn.organization_id = p_org_id;
10775:
10776: drop_lpn_rec c_drop_lpn_cursor%ROWTYPE;

Line 10794: , wms_license_plate_numbers lpn

10790: ) IS
10791: SELECT wda.delivery_id
10792: FROM wsh_delivery_assignments_v wda
10793: , wsh_delivery_details_ob_grp_v wdd
10794: , wms_license_plate_numbers lpn
10795: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
10796: AND wdd.organization_id = p_org_id
10797: AND wdd.lpn_id = lpn.lpn_id
10798: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650