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

Line 263: ,wms_license_plate_numbers wlpn

259: FUNCTION GET_DELIVERY_LPN(p_delivery_id IN NUMBER ) RETURN VARCHAR2 IS
260: CURSOR delivery_lpn IS
261: SELECT distinct license_plate_number
262: FROM wms_shipping_transaction_temp wstt
263: ,wms_license_plate_numbers wlpn
264: WHERE wstt.delivery_id = p_delivery_id
265: AND wstt.outermost_lpn_id = wlpn.lpn_id
266: AND wstt.direct_ship_flag = 'Y';
267: l_lpn_string VARCHAR2(30);

Line 2923: FROM wms_license_plate_numbers wlpn

2919: ORDER BY wdd.source_line_id;
2920:
2921: CURSOR del_lpn IS
2922: SELECT lpn_id
2923: FROM wms_license_plate_numbers wlpn
2924: WHERE wlpn.outermost_lpn_id = p_outermost_lpn_id;
2925:
2926: l_del_lpn del_lpn%ROWTYPE;
2927: l_del_det_id NUMBER;

Line 2975: from wms_license_plate_numbers

2971: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
2972:
2973: cursor lpn_cur is
2974: select lpn_id, organization_id
2975: from wms_license_plate_numbers
2976: where outermost_lpn_id = p_outermost_lpn_id;
2977:
2978:
2979: BEGIN

Line 3529: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn

3525: , wlpn.locator_id
3526: , wlc.lot_number
3527: , wlc.inventory_item_id
3528: , msn.serial_number
3529: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn
3530: WHERE wlpn.lpn_id = wlc.parent_lpn_id
3531: AND msn.lpn_id(+) = wlc.parent_lpn_id
3532: AND msn.inventory_item_id(+) = wlc.inventory_item_id
3533: AND msn.current_organization_id(+) = wlc.organization_id

Line 4944: FROM wms_license_plate_numbers

4940: AND dock_door_id = p_dock_door_id;
4941:
4942: CURSOR inner_lpn(p_lpn_id NUMBER) IS
4943: SELECT lpn_id
4944: FROM wms_license_plate_numbers
4945: WHERE outermost_lpn_id = p_lpn_id;
4946:
4947: CURSOR stage_lines(p_lpn_id NUMBER) IS
4948: SELECT wds.order_header_id

Line 4955: , wms_license_plate_numbers wlpn

4951: , msi.reservable_type
4952: , msi.lot_control_code
4953: , msi.serial_number_control_code
4954: FROM wms_direct_ship_temp wds
4955: , wms_license_plate_numbers wlpn
4956: , mtl_secondary_inventories sub
4957: , mtl_system_items msi
4958: WHERE wds.GROUP_ID = p_group_id
4959: AND wds.organization_id = p_organization_id

Line 4999: , wms_license_plate_numbers lpn

4995: /* Bug:2463967 */
4996: CURSOR delete_details(p_outermost_lpn_id NUMBER) IS
4997: SELECT delivery_detail_id
4998: FROM wsh_delivery_details_ob_grp_v wdd
4999: , wms_license_plate_numbers lpn
5000: WHERE lpn.outermost_lpn_id = p_outermost_lpn_id
5001: AND lpn.lpn_id = wdd.lpn_id
5002: AND wdd.released_status = 'X'; -- For LPN reuse ER : 6845650
5003:

Line 5007: FROM wms_license_plate_numbers

5003:
5004: -- bug 4306508
5005: CURSOR lpn_heirarchy(p_outermost_lpn_id NUMBER) IS
5006: SELECT lpn_id
5007: FROM wms_license_plate_numbers
5008: WHERE outermost_lpn_id = p_outermost_lpn_id
5009: ORDER BY lpn_id;
5010:
5011:

Line 5439: FROM wms_license_plate_numbers

5435: FOR j IN l_rsv_index .. l_mtl_reservation_tbl.COUNT LOOP
5436: IF l_mtl_reservation_tbl(j).lpn_id IS NOT NULL THEN
5437: SELECT outermost_lpn_id
5438: INTO l_outermost_lpn_id
5439: FROM wms_license_plate_numbers
5440: WHERE lpn_id = l_mtl_reservation_tbl(j).lpn_id;
5441:
5442: IF (l_debug = 1) THEN
5443: DEBUG('l_outermost_lpn_id: ' || l_outermost_lpn_id, 'Stage_LPNs');

Line 5492: FROM wms_license_plate_numbers

5488: END IF;
5489:
5490: SELECT outermost_lpn_id
5491: INTO l_outermost_lpn_id
5492: FROM wms_license_plate_numbers
5493: WHERE lpn_id = l_mtl_reservation_tbl(j).lpn_id;
5494:
5495: IF l_outer_lpn.lpn_id = l_outermost_lpn_id THEN
5496: IF (l_debug = 1) THEN

Line 6298: UPDATE wms_license_plate_numbers

6294: -- Update container Hierarchy so that container so that following cols has same value as delivery lines
6295: -- SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION_ID, DELIVER_TO_LOCATION_ID
6296: BEGIN
6297: IF l_trip_id > 0 THEN
6298: UPDATE wms_license_plate_numbers
6299: SET lpn_context = 9
6300: WHERE outermost_lpn_id = l_outer_lpn.lpn_id;
6301:
6302: IF (l_debug = 1) THEN

Line 6721: FROM wms_license_plate_numbers

6717: CURSOR inner_lpn(p_lpn NUMBER) IS
6718: SELECT lpn_id
6719: , subinventory_code
6720: , locator_id
6721: FROM wms_license_plate_numbers
6722: WHERE outermost_lpn_id = p_lpn;
6723:
6724: l_rqoh NUMBER;
6725: l_qr NUMBER;

Line 6886: FROM wms_license_plate_numbers

6882: -- Add following new columns
6883: , container_volume
6884: , container_volume_uom
6885: , organization_id
6886: FROM wms_license_plate_numbers
6887: WHERE organization_id = p_org_id
6888: AND outermost_lpn_id = p_outermost_lpn_id;
6889:
6890: l_lpn_ids wsh_util_core.id_tab_type;

Line 7166: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,

7162: -- Cursor to get the item qty in the LPN corresponding to the given delivery_id
7163: -- and the inventory item,revision
7164: CURSOR lpn_item_qty(p_delivery_id NUMBER, p_item_id NUMBER, p_revision VARCHAR2, p_lot_number VARCHAR2) IS
7165: SELECT SUM(wlc.quantity)
7166: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,
7167: wms_shipping_transaction_temp wstt
7168: WHERE wlc.parent_lpn_id = lpn.lpn_id
7169: and wstt.delivery_id = p_delivery_id
7170: and lpn.outermost_lpn_id = wstt.outermost_lpn_id

Line 7203: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc, wms_shipping_transaction_temp wstt

7199: --Query to get the total no. of distinct items in the lpn to be shipped
7200:
7201: SELECT COUNT(COUNT(*))
7202: INTO l_lpn_item_count
7203: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc, wms_shipping_transaction_temp wstt
7204: WHERE wstt.delivery_id = p_delivery_id
7205: AND wstt.outermost_lpn_id = wlpn.outermost_lpn_id
7206: AND wlpn.lpn_id = wlc.parent_lpn_id
7207: GROUP BY wlc.inventory_item_id, wlc.revision;

Line 7359: FROM wms_license_plate_numbers

7355: , p_outermost_lpn_id IN NUMBER
7356: , p_action_code IN VARCHAR2 DEFAULT 'PACK') IS
7357: CURSOR lpn_hierarchy IS
7358: SELECT DISTINCT NVL(parent_lpn_id, outermost_lpn_id)
7359: FROM wms_license_plate_numbers
7360: WHERE organization_id = p_organization_id
7361: AND outermost_lpn_id = p_outermost_lpn_id
7362: AND outermost_lpn_id <> lpn_id;
7363:

Line 7366: FROM wms_license_plate_numbers

7362: AND outermost_lpn_id <> lpn_id;
7363:
7364: CURSOR lpn_childs(l_parent_lpn_id NUMBER) IS
7365: SELECT lpn_id
7366: FROM wms_license_plate_numbers
7367: WHERE organization_id = p_organization_id
7368: AND parent_lpn_id = l_parent_lpn_id;
7369:
7370: CURSOR container_details(p_organization_id NUMBER, l_lpn_id NUMBER) IS

Line 7837: FROM wms_license_plate_numbers

7833:
7834: IF l_count_del_assign <> l_lpn_cur.cnt THEN
7835: SELECT license_plate_number
7836: INTO lpn_name
7837: FROM wms_license_plate_numbers
7838: WHERE lpn_id = l_lpn_cur.parent_lpn_id;
7839:
7840: fnd_message.set_name('WMS', 'WMS_ORDER_LINE_SPLIT');
7841: fnd_message.set_token('CONTAINER_NAME', lpn_name);

Line 8241: lpn_id wms_license_plate_numbers.lpn_id%TYPE

8237: l_group_by_ship_from_loc_flag VARCHAR2(1) := 'Y';
8238:
8239: -- Bug# 3464013
8240: TYPE l_lpn_content_cur_rec_typ IS RECORD(
8241: lpn_id wms_license_plate_numbers.lpn_id%TYPE
8242: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
8243: , locator_id wms_license_plate_numbers.locator_id%TYPE
8244: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
8245: , revision wms_lpn_contents.revision%TYPE

Line 8242: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE

8238:
8239: -- Bug# 3464013
8240: TYPE l_lpn_content_cur_rec_typ IS RECORD(
8241: lpn_id wms_license_plate_numbers.lpn_id%TYPE
8242: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
8243: , locator_id wms_license_plate_numbers.locator_id%TYPE
8244: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
8245: , revision wms_lpn_contents.revision%TYPE
8246: , lot_number wms_lpn_contents.lot_number%TYPE

Line 8243: , locator_id wms_license_plate_numbers.locator_id%TYPE

8239: -- Bug# 3464013
8240: TYPE l_lpn_content_cur_rec_typ IS RECORD(
8241: lpn_id wms_license_plate_numbers.lpn_id%TYPE
8242: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
8243: , locator_id wms_license_plate_numbers.locator_id%TYPE
8244: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
8245: , revision wms_lpn_contents.revision%TYPE
8246: , lot_number wms_lpn_contents.lot_number%TYPE
8247: , quantity wms_lpn_contents.quantity%TYPE

Line 8333: FROM wms_license_plate_numbers

8329: SELECT sub.reservable_type
8330: INTO l_sub_reservable_type
8331: FROM mtl_secondary_inventories sub
8332: WHERE sub.secondary_inventory_name = (SELECT subinventory_code
8333: FROM wms_license_plate_numbers
8334: WHERE lpn_id = p_lpn_id)
8335: AND organization_id = p_org_id;
8336:
8337: IF (l_debug = 1) THEN

Line 8393: ' , wms_license_plate_numbers wlpn ' ||

8389: END IF;
8390:
8391: l_sql_query := l_sql_query ||
8392: ' FROM wms_lpn_contents wlc ' ||
8393: ' , wms_license_plate_numbers wlpn ' ||
8394: ' , mtl_system_items_b msi ' ||
8395: ' , (SELECT lpn_id ' ||
8396: ' , revision ' ||
8397: ' , lot_number ' ||

Line 8403: ' FROM wms_license_plate_numbers ' ||

8399: ' , end_item_unit_number ' ||
8400: ' , COUNT(1) quantity ' ||
8401: ' FROM mtl_serial_numbers ' ||
8402: ' WHERE lpn_id IN(SELECT lpn_id ' ||
8403: ' FROM wms_license_plate_numbers ' ||
8404: ' WHERE organization_id = :p_org_id ' ||
8405: ' AND outermost_lpn_id = :p_lpn_id) ' ||
8406: ' GROUP BY lpn_id, revision, lot_number, inventory_item_id, end_item_unit_number) msn ' ||
8407: ' WHERE msi.inventory_item_id = wlc.inventory_item_id ' ||

Line 10485: FROM wms_license_plate_numbers

10481:
10482: --
10483: CURSOR lpn_cur IS
10484: SELECT lpn_id
10485: FROM wms_license_plate_numbers
10486: WHERE outermost_lpn_id = p_lpn_id
10487: AND organization_id = p_org_id;
10488:
10489: -- query reservations

Line 11671: FROM wms_license_plate_numbers

11667:
11668: --
11669: CURSOR lpn_cur(p_del_id NUMBER) IS
11670: SELECT lpn_id
11671: FROM wms_license_plate_numbers
11672: WHERE lpn_id IN(SELECT outermost_lpn_id
11673: FROM wms_shipping_transaction_temp
11674: WHERE delivery_id = p_del_id);
11675: