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 2272: FROM wms_license_plate_numbers wlpn

2268: AND rsl.po_header_id = NVL(p_po_header_id, rsl.po_header_id)
2269: AND (( ( rsl.asn_lpn_id IS NOT NULL
2270: AND rsl.asn_lpn_id in
2271: (SELECT wlpn.lpn_id
2272: FROM wms_license_plate_numbers wlpn
2273: start with lpn_id = p_lpn_id
2274: CONNECT BY parent_lpn_id = PRIOR lpn_id
2275: )
2276: )

Line 2847: FROM wms_license_plate_numbers

2843: , NVL(locator_id, -1)
2844: INTO l_lpn_context
2845: , l_sub
2846: , l_locator_id
2847: FROM wms_license_plate_numbers
2848: WHERE lpn_id = p_lpn_id;
2849: EXCEPTION
2850: WHEN OTHERS THEN
2851: l_lpn_context := 5;

Line 2892: FROM wms_license_plate_numbers wlpn1

2888: AND wdt.status = 4
2889: AND mtrl.lpn_id IN
2890: (
2891: SELECT wlpn1.lpn_id
2892: FROM wms_license_plate_numbers wlpn1
2893: WHERE wlpn1.outermost_lpn_id =
2894: (
2895: SELECT outermost_lpn_id
2896: FROM wms_license_plate_numbers wlpn2

Line 2896: FROM wms_license_plate_numbers wlpn2

2892: FROM wms_license_plate_numbers wlpn1
2893: WHERE wlpn1.outermost_lpn_id =
2894: (
2895: SELECT outermost_lpn_id
2896: FROM wms_license_plate_numbers wlpn2
2897: WHERE wlpn2.lpn_id = p_lpn_id
2898: )
2899: )
2900: );

Line 3067: UPDATE wms_license_plate_numbers

3063: IF (l_lpn_context = 5) THEN
3064: -- Bug 2357196
3065: -- For an expense item do not set the lpn context to 1 or 3
3066: IF NVL(x_is_expense, 'N') <> 'Y' THEN
3067: UPDATE wms_license_plate_numbers
3068: SET lpn_context = DECODE(x_routing_id, 3, 1, 3)
3069: WHERE lpn_id = p_lpn_id;
3070: END IF;
3071: END IF;

Line 3160: FROM wms_license_plate_numbers

3156: l_progress := '30';
3157:
3158: SELECT lpn_id
3159: INTO p_lpn_id
3160: FROM wms_license_plate_numbers
3161: WHERE license_plate_number = p_lpn;
3162:
3163: l_progress := '40';
3164: END IF;

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

3706:
3707: /* Two new parameter x_lpn_context and x_default_source have been added
3708: * to return the lpn_context and a flag that indicates how the
3709: * subinventory and locator have been defaulted. Possible values are:
3710: * LPN -> Sub and locator are derived from WMS_LICENSE_PLATE_NUMBERS
3711: * RTI -> Sub and locator are derived from RCV_TRANSACTIONS_INTERFACE
3712: * DOC -> Sub and locator are derived from document (POD/RSL/REQ)
3713: * ITD -> Sub and locator are derived from item transaction defaults
3714: * NONE -> There is no default sub and locator being returned

Line 3749: FROM wms_license_plate_numbers

3745: , lpn_context
3746: INTO x_sub_code
3747: , l_locator_id
3748: , l_lpn_context
3749: FROM wms_license_plate_numbers
3750: WHERE lpn_id = p_lpn_id;
3751:
3752:
3753: --added for Bug 5928199

Line 4914: FROM wms_license_plate_numbers wlpn

4910: INTO l_serial_packed_in_other_lpn
4911: FROM mtl_serial_numbers msn
4912: WHERE msn.current_status IN (5, 7)
4913: AND EXISTS(SELECT 'x'
4914: FROM wms_license_plate_numbers wlpn
4915: WHERE wlpn.lpn_context NOT IN(5, 6, 7)
4916: AND wlpn.lpn_id = msn.lpn_id)
4917: AND msn.lpn_id IS NOT NULL
4918: AND msn.serial_number BETWEEN p_from_serial_number AND p_to_serial_number

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

5798: SELECT DISTINCT rsl.shipment_header_id
5799: , rsl.from_organization_id
5800: INTO x_shipment_header_id
5801: , x_from_org_id
5802: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc,wms_license_plate_numbers wln
5803: WHERE rsl.item_id = wlc.inventory_item_id
5804: AND to_organization_id = p_organization_id
5805: AND wln.lpn_id IN ( SELECT lpn_id
5806: FROM wms_license_plate_numbers

Line 5806: FROM wms_license_plate_numbers

5802: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc,wms_license_plate_numbers wln
5803: WHERE rsl.item_id = wlc.inventory_item_id
5804: AND to_organization_id = p_organization_id
5805: AND wln.lpn_id IN ( SELECT lpn_id
5806: FROM wms_license_plate_numbers
5807: START WITH lpn_id = p_lpn_id
5808: CONNECT BY parent_lpn_id = PRIOR lpn_id)
5809: AND wlc.parent_lpn_id = wln.lpn_id
5810: AND EXISTS(

Line 5831: FROM wms_license_plate_numbers

5827: FROM rcv_shipment_lines rsl, wms_lpn_contents wlc
5828: WHERE rsl.item_id = wlc.inventory_item_id
5829: AND to_organization_id = p_organization_id
5830: AND wlc.parent_lpn_id IN ( SELECT lpn_id
5831: FROM wms_license_plate_numbers
5832: START WITH lpn_id = p_lpn_id
5833: CONNECT BY parent_lpn_id = PRIOR lpn_id)
5834: AND EXISTS(
5835: SELECT 1

Line 6909: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc

6905: -- Bug 3440456
6906: -- The following is changed because the join with WLPN is unnecessary
6907: /*SELECT 'Y'
6908: INTO x_lpn_flag
6909: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc
6910: WHERE lpn.lpn_id = wlc.parent_lpn_id
6911: AND lpn_id IN (SELECT lpn_id
6912: FROM wms_license_plate_numbers wln
6913: START WITH lpn_id = p_lpn_id

Line 6912: FROM wms_license_plate_numbers wln

6908: INTO x_lpn_flag
6909: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc
6910: WHERE lpn.lpn_id = wlc.parent_lpn_id
6911: AND lpn_id IN (SELECT lpn_id
6912: FROM wms_license_plate_numbers wln
6913: START WITH lpn_id = p_lpn_id
6914: CONNECT BY parent_lpn_id = PRIOR lpn_id);*/
6915:
6916: -- Bug# 3633708: Performance Fixes

Line 6922: FROM wms_license_plate_numbers wln

6918: /*SELECT 'Y'
6919: INTO x_lpn_flag
6920: FROM wms_lpn_contents wlc
6921: WHERE wlc.parent_lpn_id IN (SELECT lpn_id
6922: FROM wms_license_plate_numbers wln
6923: START WITH lpn_id = p_lpn_id
6924: CONNECT BY parent_lpn_id = PRIOR lpn_id);*/
6925:
6926: -- Bug# 3633708: Performance Fixes

Line 6930: FROM wms_license_plate_numbers wln

6926: -- Bug# 3633708: Performance Fixes
6927: -- Use this query instead
6928: SELECT 'Y'
6929: INTO x_lpn_flag
6930: FROM wms_license_plate_numbers wln
6931: WHERE EXISTS (SELECT '1'
6932: FROM wms_lpn_contents wlc
6933: WHERE wlc.parent_lpn_id = wln.lpn_id)
6934: START WITH wln.lpn_id = p_lpn_id

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

6953: -- Retrieval of x_lpn_flag is changed
6954: --
6955: SELECT 'Y'
6956: INTO x_lpn_flag
6957: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc, rcv_transactions_interface rti
6958: WHERE lpn.lpn_id = wlc.parent_lpn_id
6959: AND lpn.lpn_id = rti.lpn_id
6960: AND rti.transaction_status_code = 'PENDING'
6961: AND lpn.lpn_id IN(SELECT lpn_id

Line 6962: FROM wms_license_plate_numbers wln

6958: WHERE lpn.lpn_id = wlc.parent_lpn_id
6959: AND lpn.lpn_id = rti.lpn_id
6960: AND rti.transaction_status_code = 'PENDING'
6961: AND lpn.lpn_id IN(SELECT lpn_id
6962: FROM wms_license_plate_numbers wln
6963: START WITH lpn_id = p_lpn_id
6964: CONNECT BY parent_lpn_id = PRIOR lpn_id);
6965: EXCEPTION
6966: WHEN NO_DATA_FOUND THEN

Line 7026: FROM wms_license_plate_numbers

7022: , locator_id
7023: INTO x_lpn_context
7024: , l_sub_code
7025: , l_locator_id
7026: FROM wms_license_plate_numbers
7027: WHERE lpn_id = p_lpn_id;
7028: EXCEPTION
7029: WHEN OTHERS THEN
7030: x_lpn_context := 5;

Line 7234: WHERE lpn_id IN ( SELECT lpn_id FROM wms_license_plate_numbers

7230:
7231: BEGIN
7232: SELECT 'N' INTO x_lpn_flag
7233: FROM rcv_transactions_interface
7234: WHERE lpn_id IN ( SELECT lpn_id FROM wms_license_plate_numbers
7235: START WITH lpn_id = p_lpn_id
7236: CONNECT BY parent_lpn_id = PRIOR lpn_id)
7237: AND transaction_status_code = 'PENDING'
7238: AND processing_status_code <> 'ERROR'

Line 7293: (SELECT lpn_id FROM wms_license_plate_numbers

7289: FROM wsh_delivery_details wdd,
7290: wsh_delivery_assignments wda,
7291: wsh_delivery_details wdd1
7292: WHERE wdd.lpn_id IN
7293: (SELECT lpn_id FROM wms_license_plate_numbers
7294: START WITH lpn_id = p_lpn_id
7295: CONNECT BY parent_lpn_id = PRIOR lpn_id)
7296: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
7297: AND wda.delivery_detail_id = wdd1.delivery_detail_id

Line 7324: FOR l_lpn_rec IN (SELECT lpn_id FROM wms_license_plate_numbers

7320: IF(x_lpn_flag = 'Y') THEN
7321:
7322: --BUG 4237975: break up query that joins wlpn with wsh
7323: --to improve performance
7324: FOR l_lpn_rec IN (SELECT lpn_id FROM wms_license_plate_numbers
7325: START WITH lpn_id = p_lpn_id
7326: CONNECT BY parent_lpn_id = PRIOR lpn_id) LOOP
7327: BEGIN
7328: SELECT 'N' INTO x_lpn_flag

Line 7377: (SELECT lpn_id FROM wms_license_plate_numbers

7373: FROM wsh_delivery_details wdd,
7374: wsh_delivery_assignments wda,
7375: wsh_delivery_details wdd1
7376: WHERE wdd.lpn_id NOT IN
7377: (SELECT lpn_id FROM wms_license_plate_numbers
7378: START WITH lpn_id = p_lpn_id
7379: CONNECT BY parent_lpn_id = PRIOR lpn_id)
7380: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id
7381: AND wda.delivery_detail_id = wdd1.delivery_detail_id

Line 7408: FROM wms_license_plate_numbers wlpn1, rcv_shipment_headers rsh

7404: END IF;
7405:
7406: BEGIN
7407: SELECT 1 INTO x_count_of_lpns
7408: FROM wms_license_plate_numbers wlpn1, rcv_shipment_headers rsh
7409: WHERE rsh.shipment_num = p_shipment_num
7410: AND wlpn1.source_name = rsh.shipment_num
7411: AND ((wlpn1.lpn_context = 6 AND wlpn1.organization_id = rsh.organization_id) OR
7412: (wlpn1.lpn_context = 7 AND wlpn1.organization_id = rsh.ship_to_org_id))

Line 7414: FROM wms_license_plate_numbers wlpn2

7410: AND wlpn1.source_name = rsh.shipment_num
7411: AND ((wlpn1.lpn_context = 6 AND wlpn1.organization_id = rsh.organization_id) OR
7412: (wlpn1.lpn_context = 7 AND wlpn1.organization_id = rsh.ship_to_org_id))
7413: AND EXISTS (SELECT wlpn2.lpn_id
7414: FROM wms_license_plate_numbers wlpn2
7415: START WITH wlpn2.lpn_id = wlpn1.lpn_id
7416: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
7417: INTERSECT
7418: SELECT rsl.asn_lpn_id

Line 7430: FROM wms_license_plate_numbers wlpn3

7426: AND rti.processing_status_code <> 'ERROR'
7427: AND rti.transaction_status_code <> 'ERROR'
7428: )
7429: AND rsl.asn_lpn_id NOT IN (SELECT wlpn3.lpn_id
7430: FROM wms_license_plate_numbers wlpn3
7431: START WITH wlpn3.lpn_id = p_lpn_id
7432: CONNECT BY PRIOR wlpn3.lpn_id = wlpn3.parent_lpn_id
7433: )
7434: );