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 821: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

817: WHERE EXISTS
818: ( SELECT 'x'
819: FROM mtl_material_transactions_temp mmtt
820: WHERE mmtt.organization_id = p_org_id
821: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
822: WHERE wlpn.outermost_lpn_id = p_lpn_id));
823:
824:
825: CURSOR c_get_temp_txn_id

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

843: SELECT mmtt.transaction_temp_id
844: , mmtt.transaction_type_id
845: FROM mtl_material_transactions_temp mmtt
846: WHERE mmtt.organization_id = p_org_id
847: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
848: WHERE wlpn.outermost_lpn_id = p_lpn_id)
849: AND (mmtt.parent_line_id IS NULL
850: OR
851: (mmtt.parent_line_id IS NOT NULL

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

869: , mtl_txn_request_lines mtrl
870: , mtl_txn_request_headers mtrh
871: WHERE mmtt.organization_id = p_org_id
872: --Modified for Bug 6717052
873: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
874: WHERE wlpn.outermost_lpn_id = p_lpn_id))
875: AND mmtt.move_order_line_id = mtrl.line_id
876: AND mtrl.header_id = mtrh.header_id;
877:

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

882: SELECT COUNT (DISTINCT mmtt.transaction_action_id)
883: FROM mtl_material_transactions_temp mmtt
884: WHERE mmtt.organization_id = p_org_id
885: --Added for Bug 6717052
886: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
887: WHERE wlpn.outermost_lpn_id = p_lpn_id))
888: AND (mmtt.parent_line_id IS NULL
889: OR
890: (mmtt.parent_line_id IS NOT NULL

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

917: , mmtt.transaction_source_type_id
918: , mmtt.transaction_action_id
919: FROM mtl_material_transactions_temp mmtt
920: WHERE mmtt.organization_id = p_org_id
921: AND mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
922: WHERE wlpn.outermost_lpn_id = p_lpn_id)
923: AND (mmtt.parent_line_id IS NULL
924: OR
925: (mmtt.parent_line_id IS NOT NULL

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

948: , wsh_delivery_details_ob_grp_v wdd
949: , wsh_delivery_assignments_v wda
950: WHERE mmtt.organization_id = p_org_id
951: --Modified for Bug 6717052
952: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
953: WHERE wlpn.outermost_lpn_id = p_lpn_id))
954: AND ( (mmtt.parent_line_id IS NOT NULL
955: AND
956: mmtt.parent_line_id <> mmtt.transaction_temp_id

Line 1506: FROM wms_license_plate_numbers wlpn

1502: CURSOR c_get_lpn
1503: ( p_lpn_id IN NUMBER
1504: ) IS
1505: SELECT license_plate_number
1506: FROM wms_license_plate_numbers wlpn
1507: WHERE wlpn.lpn_id = p_lpn_id;
1508:
1509:
1510: CURSOR c_chk_nested_bulk

Line 1706: UPDATE wms_license_plate_numbers

1702: FETCH c_get_lpn INTO l_inner_lpn;
1703: CLOSE c_get_lpn;
1704:
1705: -- Bug5659809: update last_update_date and last_update_by as well
1706: UPDATE wms_license_plate_numbers
1707: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
1708: , last_update_date = SYSDATE
1709: , last_updated_by = fnd_global.user_id
1710: WHERE lpn_id = c_mmtt_rec.lpn_id;

Line 2324: UPDATE wms_license_plate_numbers

2320: --Bug6913674
2321:
2322:
2323: -- Bug5659809: update last_update_date and last_update_by as well
2324: UPDATE wms_license_plate_numbers
2325: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2326: , last_update_date = SYSDATE
2327: , last_updated_by = fnd_global.user_id
2328: WHERE lpn_id IN

Line 2352: UPDATE wms_license_plate_numbers

2348:
2349: IF l_loose_exists = 'Y'
2350: THEN
2351: -- Bug5659809: update last_update_date and last_update_by as well
2352: UPDATE wms_license_plate_numbers
2353: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2354: , last_update_date = SYSDATE
2355: , last_updated_by = fnd_global.user_id
2356: WHERE lpn_id IN

Line 4204: FROM wms_license_plate_numbers

4200:
4201: IF x_transfer_lpn_id IS NOT NULL THEN
4202: SELECT license_plate_number
4203: INTO x_transfer_lpn
4204: FROM wms_license_plate_numbers
4205: WHERE lpn_id = x_transfer_lpn_id;
4206: END IF;
4207:
4208: IF l_debug = 1 THEN

Line 4254: , wms_license_plate_numbers wlpn

4250: ) IS
4251: SELECT wlpn.outermost_lpn_id
4252: FROM wsh_delivery_assignments_v wda
4253: , wsh_delivery_details_ob_grp_v wdd
4254: , wms_license_plate_numbers wlpn
4255: WHERE wda.delivery_id = p_deliv_id
4256: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
4257: AND wdd.organization_id = p_org_id
4258: AND wdd.lpn_id = wlpn.lpn_id

Line 4268: FROM wms_license_plate_numbers wlpn

4264: CURSOR c_get_lpn
4265: ( p_lpn_id IN NUMBER
4266: ) IS
4267: SELECT license_plate_number
4268: FROM wms_license_plate_numbers wlpn
4269: WHERE wlpn.lpn_id = p_lpn_id;
4270:
4271: BEGIN
4272: x_return_status := fnd_api.g_ret_sts_success;

Line 4815: FROM wms_license_plate_numbers wlpn

4811: , mmtt.transaction_temp_id
4812: , mmtt.primary_quantity
4813: , mmtt.subinventory_code
4814: , mmtt.locator_id
4815: FROM wms_license_plate_numbers wlpn
4816: , mtl_material_transactions_temp mmtt
4817: WHERE wlpn.license_plate_number = p_inner_lpn
4818: AND wlpn.organization_id = p_org_id
4819: AND mmtt.transfer_lpn_id = p_outer_lpn_id

Line 4985: UPDATE wms_license_plate_numbers

4981:
4982: -- Start change for Bug 5620764
4983: -- Updates LPN context to "Packing Content" since entire LPN is consumed
4984: -- Bug5659809: update last_update_date and last_update_by as well
4985: UPDATE wms_license_plate_numbers
4986: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
4987: , last_update_date = SYSDATE
4988: , last_updated_by = fnd_global.user_id
4989: WHERE lpn_id = l_inner_lpn_id;

Line 6008: FROM wms_license_plate_numbers wlpn

6004: , p_outer_lpn_id IN NUMBER
6005: , p_org_id IN NUMBER
6006: ) IS
6007: SELECT wlpn.lpn_id
6008: FROM wms_license_plate_numbers wlpn
6009: , mtl_material_transactions_temp mmtt
6010: WHERE wlpn.license_plate_number = p_inner_lpn
6011: AND wlpn.organization_id = p_org_id
6012: AND mmtt.transfer_lpn_id = p_outer_lpn_id

Line 7306: UPDATE wms_license_plate_numbers wlpn1

7302:
7303: -- Start change for Bug 5620764
7304: -- Restore LPN context for bulk picked content LPNs back to "Packing Content" from "In Inventory"
7305: -- Bug5659809: update last_update_date and last_update_by as well
7306: UPDATE wms_license_plate_numbers wlpn1
7307: SET wlpn1.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
7308: , last_update_date = SYSDATE
7309: , last_updated_by = fnd_global.user_id
7310: WHERE wlpn1.lpn_id IN

Line 7313: , wms_license_plate_numbers wlpn2

7309: , last_updated_by = fnd_global.user_id
7310: WHERE wlpn1.lpn_id IN
7311: ( SELECT mmtt.content_lpn_id
7312: FROM mtl_material_transactions_temp mmtt
7313: , wms_license_plate_numbers wlpn2
7314: WHERE mmtt.transfer_lpn_id = p_transfer_lpn_id
7315: AND mmtt.organization_id = p_organization_id
7316: AND mmtt.parent_line_id = mmtt.transaction_temp_id
7317: AND mmtt.content_lpn_id = wlpn2.lpn_id

Line 7386: FROM wms_license_plate_numbers

7382: SELECT lpn_id
7383: , lpn_context
7384: , subinventory_code
7385: , locator_id
7386: FROM wms_license_plate_numbers
7387: WHERE organization_id = p_org_id
7388: AND license_plate_number = p_lpn;
7389:
7390: to_lpn_rec c_lpn_info%ROWTYPE;

Line 8685: --UPDATE wms_license_plate_numbers wlpn

8681: END IF;
8682:
8683: -- Start change for Bug 5620764
8684: -- This is not required, since entire LPN is being consumed
8685: --UPDATE wms_license_plate_numbers wlpn
8686: -- SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
8687: -- WHERE wlpn.lpn_id = nested_lpn_rec.content_lpn_id
8688: -- AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
8689: -- AND wlpn.organization_id = p_orgn_id;

Line 8787: FROM wms_license_plate_numbers wlpn

8783: THEN
8784: BEGIN
8785: SELECT wlpn.lpn_id
8786: INTO l_outer_most_lpn_id
8787: FROM wms_license_plate_numbers wlpn
8788: WHERE wlpn.license_plate_number = p_drop_lpn;
8789:
8790: IF l_debug = 1
8791: THEN

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

9004: mmtt.locator_id,
9005: mmtt.transaction_date
9006: FROM mtl_material_transactions_temp mmtt
9007: WHERE mmtt.organization_id = p_org_id
9008: AND mmtt.transfer_lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers
9009: WHERE outermost_lpn_id = p_lpn_id AND lpn_id <> outermost_lpn_id)
9010: AND mmtt.parent_line_id IS NULL
9011: UNION ALL
9012: -- Loose material

Line 9090: FROM wms_license_plate_numbers wlpn

9086: IF l_debug = 1 THEN print_debug ('find l_drop_lpn_id: ' , l_api_name); END IF;
9087: BEGIN
9088: SELECT wlpn.lpn_id
9089: INTO l_drop_lpn_id
9090: FROM wms_license_plate_numbers wlpn
9091: WHERE wlpn.license_plate_number = p_drop_lpn
9092: AND wlpn.organization_id = p_organization_id
9093: AND ROWNUM=1;
9094: IF l_debug = 1 THEN print_debug ('find l_drop_lpn_id: ' || l_drop_lpn_id , l_api_name); END IF;

Line 9357: UPDATE wms_license_plate_numbers wlpn

9353: --
9354: -- Update LPN context if required
9355: --
9356: -- Bug5659809: update last_update_date and last_update_by as well
9357: UPDATE wms_license_plate_numbers wlpn
9358: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
9359: , last_update_date = SYSDATE
9360: , last_updated_by = fnd_global.user_id
9361: WHERE wlpn.lpn_id = l_curr_xfer_lpn_id

Line 10449: FROM wms_license_plate_numbers wlpn

10445: SELECT wlpn.lpn_id
10446: , wlpn.lpn_context
10447: , wlpn.subinventory_code
10448: , wlpn.locator_id
10449: FROM wms_license_plate_numbers wlpn
10450: WHERE wlpn.license_plate_number = p_lpn
10451: AND wlpn.organization_id = p_org_id;
10452:
10453: drop_lpn_rec c_drop_lpn_cursor%ROWTYPE;

Line 10471: , wms_license_plate_numbers lpn

10467: ) IS
10468: SELECT wda.delivery_id
10469: FROM wsh_delivery_assignments_v wda
10470: , wsh_delivery_details_ob_grp_v wdd
10471: , wms_license_plate_numbers lpn
10472: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
10473: AND wdd.organization_id = p_org_id
10474: AND wdd.lpn_id = lpn.lpn_id
10475: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650