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 314: WHERE wstt.outermost_lpn_id = (SELECT wlpn.outermost_lpn_id FROM wms_license_plate_numbers wlpn WHERE wlpn.lpn_id = p_lpn_id)

310: l_direct_ship := 'N';
311: BEGIN
312: SELECT 'Y' INTO l_direct_ship
313: FROM wms_shipping_transaction_temp wstt
314: WHERE wstt.outermost_lpn_id = (SELECT wlpn.outermost_lpn_id FROM wms_license_plate_numbers wlpn WHERE wlpn.lpn_id = p_lpn_id)
315: and wstt.direct_ship_flag = 'Y'
316: and rownum <2;
317: EXCEPTION
318: WHEN no_data_found THEN

Line 346: ,wms_license_plate_numbers wlpn

342: FUNCTION GET_DELIVERY_LPN(p_delivery_id IN NUMBER ) RETURN VARCHAR2 IS
343: CURSOR delivery_lpn IS
344: SELECT distinct license_plate_number
345: FROM wms_shipping_transaction_temp wstt
346: ,wms_license_plate_numbers wlpn
347: WHERE wstt.delivery_id = p_delivery_id
348: AND wstt.outermost_lpn_id = wlpn.lpn_id
349: AND wstt.direct_ship_flag = 'Y';
350: l_lpn_string VARCHAR2(30);

Line 3079: FROM wms_license_plate_numbers wlpn

3075: ORDER BY wdd.source_line_id;
3076:
3077: CURSOR del_lpn IS
3078: SELECT lpn_id
3079: FROM wms_license_plate_numbers wlpn
3080: WHERE wlpn.outermost_lpn_id = p_outermost_lpn_id;
3081:
3082: l_del_lpn del_lpn%ROWTYPE;
3083: l_del_det_id NUMBER;

Line 3132: from wms_license_plate_numbers

3128: l_lpn_rec WMS_Data_Type_Definitions_PUB.LPNRecordType;
3129:
3130: cursor lpn_cur is
3131: select lpn_id, organization_id
3132: from wms_license_plate_numbers
3133: where outermost_lpn_id = p_outermost_lpn_id;
3134:
3135:
3136: BEGIN

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

3716: , wlpn.locator_id
3717: , wlc.lot_number
3718: , wlc.inventory_item_id
3719: , msn.serial_number
3720: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn
3721: WHERE wlpn.lpn_id = wlc.parent_lpn_id
3722: AND msn.lpn_id(+) = wlc.parent_lpn_id
3723: AND msn.inventory_item_id(+) = wlc.inventory_item_id
3724: AND msn.current_organization_id(+) = wlc.organization_id

Line 4822: FROM wms_license_plate_numbers

4818: l_dual_uom_item BOOLEAN := FALSE;
4819:
4820: CURSOR c_lpn_heirarchy(p_outermost_lpn_id NUMBER) IS
4821: SELECT lpn_id
4822: FROM wms_license_plate_numbers
4823: WHERE outermost_lpn_id = p_outermost_lpn_id
4824: ORDER BY lpn_id;
4825:
4826: BEGIN

Line 5221: FROM wms_license_plate_numbers

5217: AND dock_door_id = p_dock_door_id;
5218:
5219: CURSOR inner_lpn(p_lpn_id NUMBER) IS
5220: SELECT lpn_id
5221: FROM wms_license_plate_numbers
5222: WHERE outermost_lpn_id = p_lpn_id;
5223:
5224: CURSOR stage_lines(p_lpn_id NUMBER) IS
5225: SELECT wds.order_header_id

Line 5233: , wms_license_plate_numbers wlpn

5229: , msi.reservable_type
5230: , msi.lot_control_code
5231: , msi.serial_number_control_code
5232: FROM wms_direct_ship_temp wds
5233: , wms_license_plate_numbers wlpn
5234: , mtl_secondary_inventories sub
5235: , mtl_system_items msi
5236: WHERE wds.GROUP_ID = p_group_id
5237: AND wds.organization_id = p_organization_id

Line 5277: , wms_license_plate_numbers lpn

5273: /* Bug:2463967 */
5274: CURSOR delete_details(p_outermost_lpn_id NUMBER) IS
5275: SELECT delivery_detail_id
5276: FROM wsh_delivery_details_ob_grp_v wdd
5277: , wms_license_plate_numbers lpn
5278: WHERE lpn.outermost_lpn_id = p_outermost_lpn_id
5279: AND lpn.lpn_id = wdd.lpn_id
5280: AND wdd.released_status = 'X'; -- For LPN reuse ER : 6845650
5281:

Line 5285: FROM wms_license_plate_numbers

5281:
5282: -- bug 4306508
5283: CURSOR lpn_heirarchy(p_outermost_lpn_id NUMBER) IS
5284: SELECT lpn_id
5285: FROM wms_license_plate_numbers
5286: WHERE outermost_lpn_id = p_outermost_lpn_id
5287: ORDER BY lpn_id;
5288:
5289:

Line 5736: FROM wms_license_plate_numbers

5732: FOR j IN l_rsv_index .. l_mtl_reservation_tbl.COUNT LOOP
5733: IF l_mtl_reservation_tbl(j).lpn_id IS NOT NULL THEN
5734: SELECT outermost_lpn_id
5735: INTO l_outermost_lpn_id
5736: FROM wms_license_plate_numbers
5737: WHERE lpn_id = l_mtl_reservation_tbl(j).lpn_id;
5738:
5739: IF (l_debug = 1) THEN
5740: DEBUG('l_outermost_lpn_id: ' || l_outermost_lpn_id, 'Stage_LPNs');

Line 5785: FROM wms_license_plate_numbers

5781: END IF;
5782:
5783: SELECT outermost_lpn_id
5784: INTO l_outermost_lpn_id
5785: FROM wms_license_plate_numbers
5786: WHERE lpn_id = l_mtl_reservation_tbl(j).lpn_id;
5787:
5788: IF l_outer_lpn.lpn_id = l_outermost_lpn_id THEN
5789: IF (l_debug = 1) THEN

Line 7405: UPDATE wms_license_plate_numbers

7401: -- Update container Hierarchy so that container so that following cols has same value as delivery lines
7402: -- SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION_ID, DELIVER_TO_LOCATION_ID
7403: BEGIN
7404: IF l_trip_id > 0 THEN
7405: UPDATE wms_license_plate_numbers
7406: SET lpn_context = 9
7407: WHERE outermost_lpn_id = l_outer_lpn.lpn_id;
7408:
7409: IF (l_debug = 1) THEN

Line 7828: FROM wms_license_plate_numbers

7824: CURSOR inner_lpn(p_lpn NUMBER) IS
7825: SELECT lpn_id
7826: , subinventory_code
7827: , locator_id
7828: FROM wms_license_plate_numbers
7829: WHERE outermost_lpn_id = p_lpn;
7830:
7831: l_rqoh NUMBER;
7832: l_qr NUMBER;

Line 7983: FROM wms_license_plate_numbers

7979: -- Add following new columns
7980: , container_volume
7981: , container_volume_uom
7982: , organization_id
7983: FROM wms_license_plate_numbers
7984: WHERE organization_id = p_org_id
7985: AND outermost_lpn_id = p_outermost_lpn_id;
7986:
7987: l_lpn_ids wsh_util_core.id_tab_type;

Line 8263: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,

8259: -- Cursor to get the item qty in the LPN corresponding to the given delivery_id
8260: -- and the inventory item,revision
8261: CURSOR lpn_item_qty(p_delivery_id NUMBER, p_item_id NUMBER, p_revision VARCHAR2, p_lot_number VARCHAR2) IS
8262: SELECT SUM(wlc.quantity)
8263: FROM wms_lpn_contents wlc, wms_license_plate_numbers lpn,
8264: wms_shipping_transaction_temp wstt
8265: WHERE wlc.parent_lpn_id = lpn.lpn_id
8266: and wstt.delivery_id = p_delivery_id
8267: and lpn.outermost_lpn_id = wstt.outermost_lpn_id

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

8296: --Query to get the total no. of distinct items in the lpn to be shipped
8297:
8298: SELECT COUNT(COUNT(*))
8299: INTO l_lpn_item_count
8300: FROM wms_license_plate_numbers wlpn, wms_lpn_contents wlc, wms_shipping_transaction_temp wstt
8301: WHERE wstt.delivery_id = p_delivery_id
8302: AND wstt.outermost_lpn_id = wlpn.outermost_lpn_id
8303: AND wlpn.lpn_id = wlc.parent_lpn_id
8304: GROUP BY wlc.inventory_item_id, wlc.revision;

Line 8456: FROM wms_license_plate_numbers

8452: , p_outermost_lpn_id IN NUMBER
8453: , p_action_code IN VARCHAR2 DEFAULT 'PACK') IS
8454: CURSOR lpn_hierarchy IS
8455: SELECT DISTINCT NVL(parent_lpn_id, outermost_lpn_id)
8456: FROM wms_license_plate_numbers
8457: WHERE organization_id = p_organization_id
8458: AND outermost_lpn_id = p_outermost_lpn_id
8459: AND outermost_lpn_id <> lpn_id;
8460:

Line 8463: FROM wms_license_plate_numbers

8459: AND outermost_lpn_id <> lpn_id;
8460:
8461: CURSOR lpn_childs(l_parent_lpn_id NUMBER) IS
8462: SELECT lpn_id
8463: FROM wms_license_plate_numbers
8464: WHERE organization_id = p_organization_id
8465: AND parent_lpn_id = l_parent_lpn_id;
8466:
8467: CURSOR container_details(p_organization_id NUMBER, l_lpn_id NUMBER) IS

Line 8934: FROM wms_license_plate_numbers

8930:
8931: IF l_count_del_assign <> l_lpn_cur.cnt THEN
8932: SELECT license_plate_number
8933: INTO lpn_name
8934: FROM wms_license_plate_numbers
8935: WHERE lpn_id = l_lpn_cur.parent_lpn_id;
8936:
8937: fnd_message.set_name('WMS', 'WMS_ORDER_LINE_SPLIT');
8938: fnd_message.set_token('CONTAINER_NAME', lpn_name);

Line 9358: lpn_id wms_license_plate_numbers.lpn_id%TYPE

9354: l_group_by_ship_from_loc_flag VARCHAR2(1) := 'Y';
9355:
9356: -- Bug# 3464013
9357: TYPE l_lpn_content_cur_rec_typ IS RECORD(
9358: lpn_id wms_license_plate_numbers.lpn_id%TYPE
9359: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
9360: , locator_id wms_license_plate_numbers.locator_id%TYPE
9361: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
9362: , revision wms_lpn_contents.revision%TYPE

Line 9359: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE

9355:
9356: -- Bug# 3464013
9357: TYPE l_lpn_content_cur_rec_typ IS RECORD(
9358: lpn_id wms_license_plate_numbers.lpn_id%TYPE
9359: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
9360: , locator_id wms_license_plate_numbers.locator_id%TYPE
9361: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
9362: , revision wms_lpn_contents.revision%TYPE
9363: , lot_number wms_lpn_contents.lot_number%TYPE

Line 9360: , locator_id wms_license_plate_numbers.locator_id%TYPE

9356: -- Bug# 3464013
9357: TYPE l_lpn_content_cur_rec_typ IS RECORD(
9358: lpn_id wms_license_plate_numbers.lpn_id%TYPE
9359: , subinventory_code wms_license_plate_numbers.subinventory_code%TYPE
9360: , locator_id wms_license_plate_numbers.locator_id%TYPE
9361: , inventory_item_id wms_lpn_contents.inventory_item_id%TYPE
9362: , revision wms_lpn_contents.revision%TYPE
9363: , lot_number wms_lpn_contents.lot_number%TYPE
9364: , quantity wms_lpn_contents.quantity%TYPE

Line 9459: FROM wms_license_plate_numbers

9455: SELECT sub.reservable_type
9456: INTO l_sub_reservable_type
9457: FROM mtl_secondary_inventories sub
9458: WHERE sub.secondary_inventory_name = (SELECT subinventory_code
9459: FROM wms_license_plate_numbers
9460: WHERE lpn_id = p_lpn_id)
9461: AND organization_id = p_org_id;
9462:
9463: IF (l_debug = 1) THEN

Line 9507: ' , wms_license_plate_numbers wlpn ' ||

9503: ' , msi.reservable_type ' ||
9504: ' , NULL ' ||
9505: ' , msi.ont_pricing_qty_source ' ||
9506: ' FROM wms_lpn_contents wlc ' ||
9507: ' , wms_license_plate_numbers wlpn ' ||
9508: ' , mtl_system_items_b msi ' ||
9509: ' WHERE msi.inventory_item_id = wlc.inventory_item_id ' ||
9510: ' AND wlpn.lpn_id = wlc.parent_lpn_id ' ||
9511: ' AND wlpn.outermost_lpn_id = :p_lpn_id ' ||

Line 9546: ' , wms_license_plate_numbers wlpn ' ||

9542: ' , msi.reservable_type ' ||
9543: ' , msn.end_item_unit_number ' ||
9544: ' , msi.ont_pricing_qty_source ' ||
9545: ' FROM wms_lpn_contents wlc ' ||
9546: ' , wms_license_plate_numbers wlpn ' ||
9547: ' , mtl_system_items_b msi ' ||
9548: ' , (SELECT lpn_id ' ||
9549: ' , revision ' ||
9550: ' , lot_number ' ||

Line 9556: ' FROM wms_license_plate_numbers ' ||

9552: ' , end_item_unit_number ' ||
9553: ' , COUNT(1) quantity ' ||
9554: ' FROM mtl_serial_numbers ' ||
9555: ' WHERE lpn_id IN(SELECT lpn_id ' ||
9556: ' FROM wms_license_plate_numbers ' ||
9557: ' WHERE organization_id = :p_org_id ' ||
9558: ' AND outermost_lpn_id = :p_lpn_id) ' ||
9559: ' GROUP BY lpn_id, revision, lot_number, inventory_item_id, end_item_unit_number) msn ' ||
9560: ' WHERE msi.inventory_item_id = wlc.inventory_item_id ' ||

Line 12266: FROM wms_license_plate_numbers

12262:
12263: --
12264: CURSOR lpn_cur IS
12265: SELECT lpn_id
12266: FROM wms_license_plate_numbers
12267: WHERE outermost_lpn_id = p_lpn_id
12268: AND organization_id = p_org_id;
12269:
12270: -- query reservations

Line 13827: FROM wms_license_plate_numbers wlpn

13823: END IF;
13824:
13825: SELECT 1
13826: INTO l_ct_wt_enabled
13827: FROM wms_license_plate_numbers wlpn
13828: WHERE wlpn.organization_id = p_org_id
13829: AND wlpn.lpn_id = p_lpn_id
13830: AND EXISTS ( SELECT 'x'
13831: FROM wms_license_plate_numbers wlpn2

Line 13831: FROM wms_license_plate_numbers wlpn2

13827: FROM wms_license_plate_numbers wlpn
13828: WHERE wlpn.organization_id = p_org_id
13829: AND wlpn.lpn_id = p_lpn_id
13830: AND EXISTS ( SELECT 'x'
13831: FROM wms_license_plate_numbers wlpn2
13832: , wms_lpn_contents wlc
13833: , mtl_system_items msi
13834: WHERE wlpn2.outermost_lpn_id = wlpn.outermost_lpn_id
13835: AND wlc.parent_lpn_id = wlpn2.lpn_id