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.INV_RCV_COMMON_APIS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 322: FROM wms_lpn_contents wlc, wms_license_plate_numbers wln

318: --
319: /*
320: CURSOR get_all_items_in_lpn(p_lpn_id NUMBER) IS
321: SELECT wlc.inventory_item_id
322: FROM wms_lpn_contents wlc, wms_license_plate_numbers wln
323: WHERE wln.lpn_id = wlc.parent_lpn_id
324: AND lpn_id IN(SELECT lpn_id
325: FROM wms_license_plate_numbers
326: START WITH lpn_id = p_lpn_id

Line 325: FROM wms_license_plate_numbers

321: SELECT wlc.inventory_item_id
322: FROM wms_lpn_contents wlc, wms_license_plate_numbers wln
323: WHERE wln.lpn_id = wlc.parent_lpn_id
324: AND lpn_id IN(SELECT lpn_id
325: FROM wms_license_plate_numbers
326: START WITH lpn_id = p_lpn_id
327: CONNECT BY parent_lpn_id = PRIOR lpn_id);
328: */
329:

Line 335: FROM wms_license_plate_numbers

331: SELECT wlc.inventory_item_id
332: FROM wms_lpn_contents wlc
333: WHERE wlc.parent_lpn_id
334: IN ( SELECT lpn_id
335: FROM wms_license_plate_numbers
336: START WITH lpn_id = p_lpn_id
337: CONNECT BY parent_lpn_id = PRIOR lpn_id);
338:
339: l_item_id NUMBER;

Line 2390: FROM wms_license_plate_numbers wlpn

2386: AND rsl.po_header_id = NVL(p_po_header_id, rsl.po_header_id)
2387: AND (( ( rsl.asn_lpn_id IS NOT NULL
2388: AND rsl.asn_lpn_id in
2389: (SELECT wlpn.lpn_id
2390: FROM wms_license_plate_numbers wlpn
2391: start with lpn_id = p_lpn_id
2392: CONNECT BY parent_lpn_id = PRIOR lpn_id
2393: )
2394: )

Line 3025: FROM wms_license_plate_numbers

3021: , NVL(locator_id, -1)
3022: INTO l_lpn_context
3023: , l_sub
3024: , l_locator_id
3025: FROM wms_license_plate_numbers
3026: WHERE lpn_id = p_lpn_id;
3027: EXCEPTION
3028: WHEN OTHERS THEN
3029: l_lpn_context := 5;

Line 3070: FROM wms_license_plate_numbers wlpn1

3066: AND wdt.status = 4
3067: AND mtrl.lpn_id IN
3068: (
3069: SELECT wlpn1.lpn_id
3070: FROM wms_license_plate_numbers wlpn1
3071: WHERE wlpn1.outermost_lpn_id =
3072: (
3073: SELECT outermost_lpn_id
3074: FROM wms_license_plate_numbers wlpn2

Line 3074: FROM wms_license_plate_numbers wlpn2

3070: FROM wms_license_plate_numbers wlpn1
3071: WHERE wlpn1.outermost_lpn_id =
3072: (
3073: SELECT outermost_lpn_id
3074: FROM wms_license_plate_numbers wlpn2
3075: WHERE wlpn2.lpn_id = p_lpn_id
3076: )
3077: )
3078: );

Line 3245: UPDATE wms_license_plate_numbers

3241: IF (l_lpn_context = 5) THEN
3242: -- Bug 2357196
3243: -- For an expense item do not set the lpn context to 1 or 3
3244: IF NVL(x_is_expense, 'N') <> 'Y' THEN
3245: UPDATE wms_license_plate_numbers
3246: SET lpn_context = DECODE(x_routing_id, 3, 1, 3)
3247: WHERE lpn_id = p_lpn_id;
3248: END IF;
3249: END IF;

Line 3338: FROM wms_license_plate_numbers

3334: l_progress := '30';
3335:
3336: SELECT lpn_id
3337: INTO p_lpn_id
3338: FROM wms_license_plate_numbers
3339: WHERE license_plate_number = p_lpn;
3340:
3341: l_progress := '40';
3342: END IF;

Line 4193: * LPN -> Sub and locator are derived from WMS_LICENSE_PLATE_NUMBERS

4189:
4190: /* Two new parameter x_lpn_context and x_default_source have been added
4191: * to return the lpn_context and a flag that indicates how the
4192: * subinventory and locator have been defaulted. Possible values are:
4193: * LPN -> Sub and locator are derived from WMS_LICENSE_PLATE_NUMBERS
4194: * RTI -> Sub and locator are derived from RCV_TRANSACTIONS_INTERFACE
4195: * DOC -> Sub and locator are derived from document (POD/RSL/REQ)
4196: * ITD -> Sub and locator are derived from item transaction defaults
4197: * NONE -> There is no default sub and locator being returned

Line 4232: FROM wms_license_plate_numbers

4228: , lpn_context
4229: INTO x_sub_code
4230: , l_locator_id
4231: , l_lpn_context
4232: FROM wms_license_plate_numbers
4233: WHERE lpn_id = p_lpn_id;
4234:
4235:
4236: --added for Bug 5928199

Line 5441: FROM wms_license_plate_numbers wlpn

5437: INTO l_serial_packed_in_other_lpn
5438: FROM mtl_serial_numbers msn
5439: WHERE msn.current_status IN (5, 7)
5440: AND EXISTS(SELECT 'x'
5441: FROM wms_license_plate_numbers wlpn
5442: WHERE wlpn.lpn_context NOT IN(5, 6, 7)
5443: AND wlpn.lpn_id = msn.lpn_id)
5444: AND msn.lpn_id IS NOT NULL
5445: AND msn.serial_number BETWEEN p_from_serial_number AND p_to_serial_number

Line 6334: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc,wms_license_plate_numbers wln

6330: SELECT DISTINCT rsl.shipment_header_id
6331: , rsl.from_organization_id
6332: INTO x_shipment_header_id
6333: , x_from_org_id
6334: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc,wms_license_plate_numbers wln
6335: WHERE rsl.item_id = wlc.inventory_item_id
6336: AND to_organization_id = p_organization_id
6337: AND wln.lpn_id IN ( SELECT lpn_id
6338: FROM wms_license_plate_numbers

Line 6338: FROM wms_license_plate_numbers

6334: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc,wms_license_plate_numbers wln
6335: WHERE rsl.item_id = wlc.inventory_item_id
6336: AND to_organization_id = p_organization_id
6337: AND wln.lpn_id IN ( SELECT lpn_id
6338: FROM wms_license_plate_numbers
6339: START WITH lpn_id = p_lpn_id
6340: CONNECT BY parent_lpn_id = PRIOR lpn_id)
6341: AND wlc.parent_lpn_id = wln.lpn_id
6342: AND EXISTS(

Line 6363: FROM wms_license_plate_numbers

6359: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc
6360: WHERE rsl.item_id = wlc.inventory_item_id
6361: AND to_organization_id = p_organization_id
6362: AND wlc.parent_lpn_id IN ( SELECT lpn_id
6363: FROM wms_license_plate_numbers
6364: START WITH lpn_id = p_lpn_id
6365: CONNECT BY parent_lpn_id = PRIOR lpn_id)
6366: AND EXISTS(
6367: SELECT 1

Line 7441: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc

7437: -- Bug 3440456
7438: -- The following is changed because the join with WLPN is unnecessary
7439: /*SELECT 'Y'
7440: INTO x_lpn_flag
7441: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc
7442: WHERE lpn.lpn_id = wlc.parent_lpn_id
7443: AND lpn_id IN (SELECT lpn_id
7444: FROM wms_license_plate_numbers wln
7445: START WITH lpn_id = p_lpn_id

Line 7444: FROM wms_license_plate_numbers wln

7440: INTO x_lpn_flag
7441: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc
7442: WHERE lpn.lpn_id = wlc.parent_lpn_id
7443: AND lpn_id IN (SELECT lpn_id
7444: FROM wms_license_plate_numbers wln
7445: START WITH lpn_id = p_lpn_id
7446: CONNECT BY parent_lpn_id = PRIOR lpn_id);*/
7447:
7448: -- Bug# 3633708: Performance Fixes

Line 7454: FROM wms_license_plate_numbers wln

7450: /*SELECT 'Y'
7451: INTO x_lpn_flag
7452: FROM wms_lpn_contents wlc
7453: WHERE wlc.parent_lpn_id IN (SELECT lpn_id
7454: FROM wms_license_plate_numbers wln
7455: START WITH lpn_id = p_lpn_id
7456: CONNECT BY parent_lpn_id = PRIOR lpn_id);*/
7457:
7458: -- Bug# 3633708: Performance Fixes

Line 7462: FROM wms_license_plate_numbers wln

7458: -- Bug# 3633708: Performance Fixes
7459: -- Use this query instead
7460: SELECT 'Y'
7461: INTO x_lpn_flag
7462: FROM wms_license_plate_numbers wln
7463: WHERE EXISTS (SELECT '1'
7464: FROM wms_lpn_contents wlc
7465: WHERE wlc.parent_lpn_id = wln.lpn_id)
7466: START WITH wln.lpn_id = p_lpn_id

Line 7489: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc, rcv_transactions_interface rti

7485: -- Retrieval of x_lpn_flag is changed
7486: --
7487: SELECT 'Y'
7488: INTO x_lpn_flag
7489: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc, rcv_transactions_interface rti
7490: WHERE lpn.lpn_id = wlc.parent_lpn_id
7491: AND lpn.lpn_id = rti.lpn_id
7492: AND rti.transaction_status_code = 'PENDING'
7493: AND lpn.lpn_id IN(SELECT lpn_id

Line 7494: FROM wms_license_plate_numbers wln

7490: WHERE lpn.lpn_id = wlc.parent_lpn_id
7491: AND lpn.lpn_id = rti.lpn_id
7492: AND rti.transaction_status_code = 'PENDING'
7493: AND lpn.lpn_id IN(SELECT lpn_id
7494: FROM wms_license_plate_numbers wln
7495: START WITH lpn_id = p_lpn_id
7496: CONNECT BY parent_lpn_id = PRIOR lpn_id);
7497: EXCEPTION
7498: WHEN NO_DATA_FOUND THEN

Line 7558: FROM wms_license_plate_numbers

7554: , locator_id
7555: INTO x_lpn_context
7556: , l_sub_code
7557: , l_locator_id
7558: FROM wms_license_plate_numbers
7559: WHERE lpn_id = p_lpn_id;
7560: EXCEPTION
7561: WHEN OTHERS THEN
7562: x_lpn_context := 5;

Line 7766: WHERE lpn_id IN ( SELECT lpn_id FROM wms_license_plate_numbers

7762:
7763: BEGIN
7764: SELECT 'N' INTO x_lpn_flag
7765: FROM rcv_transactions_interface
7766: WHERE lpn_id IN ( SELECT lpn_id FROM wms_license_plate_numbers
7767: START WITH lpn_id = p_lpn_id
7768: CONNECT BY parent_lpn_id = PRIOR lpn_id)
7769: AND transaction_status_code = 'PENDING'
7770: AND processing_status_code <> 'ERROR'

Line 7825: (SELECT lpn_id FROM wms_license_plate_numbers

7821: FROM wsh_delivery_details wdd,
7822: wsh_delivery_assignments wda,
7823: wsh_delivery_details wdd1
7824: WHERE wdd.lpn_id IN
7825: (SELECT lpn_id FROM wms_license_plate_numbers
7826: START WITH lpn_id = p_lpn_id
7827: CONNECT BY parent_lpn_id = PRIOR lpn_id)
7828: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
7829: AND wda.delivery_detail_id = wdd1.delivery_detail_id

Line 7856: FOR l_lpn_rec IN (SELECT lpn_id FROM wms_license_plate_numbers

7852: IF(x_lpn_flag = 'Y') THEN
7853:
7854: --BUG 4237975: break up query that joins wlpn with wsh
7855: --to improve performance
7856: FOR l_lpn_rec IN (SELECT lpn_id FROM wms_license_plate_numbers
7857: START WITH lpn_id = p_lpn_id
7858: CONNECT BY parent_lpn_id = PRIOR lpn_id) LOOP
7859: BEGIN
7860: SELECT 'N' INTO x_lpn_flag

Line 7909: (SELECT lpn_id FROM wms_license_plate_numbers

7905: FROM wsh_delivery_details wdd,
7906: wsh_delivery_assignments wda,
7907: wsh_delivery_details wdd1
7908: WHERE wdd.lpn_id NOT IN
7909: (SELECT lpn_id FROM wms_license_plate_numbers
7910: START WITH lpn_id = p_lpn_id
7911: CONNECT BY parent_lpn_id = PRIOR lpn_id)
7912: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
7913: AND wda.delivery_detail_id = wdd1.delivery_detail_id

Line 7940: FROM wms_license_plate_numbers wlpn1, rcv_shipment_headers rsh

7936: END IF;
7937:
7938: BEGIN
7939: SELECT 1 INTO x_count_of_lpns
7940: FROM wms_license_plate_numbers wlpn1, rcv_shipment_headers rsh
7941: WHERE rsh.shipment_num = p_shipment_num
7942: AND wlpn1.source_name = rsh.shipment_num
7943: AND ((wlpn1.lpn_context = 6 AND wlpn1.organization_id = rsh.organization_id) OR
7944: (wlpn1.lpn_context = 7 AND wlpn1.organization_id = rsh.ship_to_org_id))

Line 7946: FROM wms_license_plate_numbers wlpn2

7942: AND wlpn1.source_name = rsh.shipment_num
7943: AND ((wlpn1.lpn_context = 6 AND wlpn1.organization_id = rsh.organization_id) OR
7944: (wlpn1.lpn_context = 7 AND wlpn1.organization_id = rsh.ship_to_org_id))
7945: AND EXISTS (SELECT wlpn2.lpn_id
7946: FROM wms_license_plate_numbers wlpn2
7947: START WITH wlpn2.lpn_id = wlpn1.lpn_id
7948: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
7949: INTERSECT
7950: SELECT rsl.asn_lpn_id

Line 7962: FROM wms_license_plate_numbers wlpn3

7958: AND rti.processing_status_code <> 'ERROR'
7959: AND rti.transaction_status_code <> 'ERROR'
7960: )
7961: AND rsl.asn_lpn_id NOT IN (SELECT wlpn3.lpn_id
7962: FROM wms_license_plate_numbers wlpn3
7963: START WITH wlpn3.lpn_id = p_lpn_id
7964: CONNECT BY PRIOR wlpn3.lpn_id = wlpn3.parent_lpn_id
7965: )
7966: );