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

Line 302: , wms_license_plate_numbers wlpn

298: INTO l_dummy
299: FROM dual
300: WHERE exists (SELECT '1'
301: FROM wms_lpn_contents wlc
302: , wms_license_plate_numbers wlpn
303: , mtl_system_items msi
304: WHERE wlc.parent_lpn_id = wlpn.lpn_id
305: AND wlc.inventory_item_id = msi.inventory_item_id
306: AND msi.organization_id = p_org_id

Line 310: FROM wms_license_plate_numbers wlpn2

306: AND msi.organization_id = p_org_id
307: AND wlpn.organization_id = p_org_id
308: AND msi.mtl_transactions_enabled_flag <> p_transactions_enabled_flag
309: AND wlpn.lpn_id IN (SELECT lpn_id
310: FROM wms_license_plate_numbers wlpn2
311: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
312: START WITH wlpn2.lpn_id = p_lpn_id
313: UNION ALL
314: SELECT lpn_id

Line 315: FROM wms_license_plate_numbers wlpn3

311: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
312: START WITH wlpn2.lpn_id = p_lpn_id
313: UNION ALL
314: SELECT lpn_id
315: FROM wms_license_plate_numbers wlpn3
316: CONNECT BY PRIOR wlpn3.parent_lpn_id = wlpn3.lpn_id
317: START WITH wlpn3.parent_lpn_id = p_lpn_id));
318:
319: RETURN TRUE;

Line 1211: FROM wms_license_plate_numbers

1207: IF l_asn_lpn_id IS NOT NULL THEN
1208: BEGIN
1209: SELECT lpn_context
1210: INTO l_lpn_context
1211: FROM wms_license_plate_numbers
1212: WHERE lpn_id = l_asn_lpn_id;
1213: EXCEPTION
1214: WHEN OTHERS THEN
1215: IF (l_debug = 1) THEN

Line 2042: from wms_license_plate_numbers

2038: x_license_plate_number,
2039: x_lpn_context,
2040: x_parent_lpn_id,
2041: x_source_header_id
2042: from wms_license_plate_numbers
2043: where lpn_id = x_lpn_id
2044: and license_plate_number = x_license_plate_number
2045: ;
2046: return TRUE;

Line 2058: from wms_license_plate_numbers

2054: x_license_plate_number,
2055: x_lpn_context,
2056: x_parent_lpn_id,
2057: x_source_header_id
2058: from wms_license_plate_numbers
2059: where lpn_id = x_lpn_id
2060: ;
2061: return TRUE;
2062: Elsif (x_lpn_id is null and x_license_plate_number is not null ) Then

Line 2073: from wms_license_plate_numbers

2069: x_license_plate_number,
2070: x_lpn_context,
2071: x_parent_lpn_id,
2072: x_source_header_id
2073: from wms_license_plate_numbers
2074: where license_plate_number = x_license_plate_number
2075: ;
2076: return TRUE;
2077: End if;

Line 2224: wms_license_plate_numbers wmslpn

2220: wmslpnci.attribute14 attribute14,
2221: wmslpnci.attribute15 attribute15
2222: FROM
2223: wms_lpn_contents_interface wmslpnci,
2224: wms_license_plate_numbers wmslpn
2225: WHERE
2226: wmslpnci.interface_transaction_id = l_intf_txn_id AND
2227: wmslpn.license_plate_number (+)= wmslpnci.license_plate_number;
2228:

Line 3437: l_lpn_rec WMS_LICENSE_PLATE_NUMBERS%rowtype;

3433: ,p_source_type_id IN NUMBER DEFAULT NULL) IS
3434:
3435: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3436: l_progress VARCHAR2(15) := '10';
3437: l_lpn_rec WMS_LICENSE_PLATE_NUMBERS%rowtype;
3438:
3439: BEGIN
3440:
3441: -- Initialize API return status to success

Line 8156: from wms_license_plate_numbers wlpn

8152: Begin
8153: -- Get the LPN's Org Here
8154: select organization_id
8155: into l_lpn_org
8156: from wms_license_plate_numbers wlpn
8157: where wlpn.lpn_id = l_rti_rec.lpn_id;
8158: --
8159: l_progress := 'WMSINB-14465';
8160: Exception

Line 8453: from wms_license_plate_numbers wlpn

8449: Begin
8450: -- Get the LPN's Org Here
8451: select organization_id
8452: into l_lpn_org
8453: from wms_license_plate_numbers wlpn
8454: where wlpn.lpn_id = l_rti_rec.lpn_id;
8455: --
8456: l_progress := 'WMSINB-14465';
8457: Exception

Line 8672: FROM wms_license_plate_numbers

8668: --Also null out source_name and source_header_id.
8669: --This needs to be done only if the LPN is getting unpacked completely.
8670: SELECT lpn_context
8671: INTO l_current_lpn_context
8672: FROM wms_license_plate_numbers
8673: WHERE lpn_id = l_rti_rec.lpn_id;
8674:
8675: IF (l_current_lpn_context = 5) THEN
8676: IF (l_debug = 1) THEN

Line 10575: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn

10571: Decode(rsh.receipt_source_code,'INTERNAL
10572: ORDER','REQ','INVENTORY','INVENTORY','VENDOR','PO','CUSTOMER','RMA')
10573: INTO l_receipt_source_code
10574: , l_source_document_code
10575: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
10576: WHERE RSH.SHIPMENT_HEADER_ID = WLPN.SOURCE_HEADER_ID
10577: AND WLPN.SOURCE_HEADER_ID IS NOT NULL
10578: AND wlpn.lpn_id = p_lpn_id
10579: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 10590: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn

10586: Decode(rsh.receipt_source_code,'INTERNAL
10587: ORDER','REQ','INVENTORY','INVENTORY','VENDOR','PO','CUSTOMER','RMA')
10588: INTO l_receipt_source_code
10589: , l_source_document_code
10590: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
10591: WHERE RSH.SHIPMENT_NUM = WLPN.SOURCE_NAME
10592: AND WLPN.SOURCE_NAME IS NOT NULL
10593: AND wlpn.lpn_id = p_lpn_id
10594: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 12328: from wms_license_plate_numbers

12324:
12325: cursor c_child_lpn(p_child_lpn_id NUMBER) is
12326: select distinct lpn_id
12327: ,license_plate_number
12328: from wms_license_plate_numbers
12329: connect by prior lpn_id = parent_lpn_id
12330: start with lpn_id = p_child_lpn_id
12331: ;
12332:

Line 12349: from wms_license_plate_numbers wlpn,

12345: ,NULL project_id
12346: ,NULL task_id
12347: ,0 mmtt_quantity
12348: ,sum(nvl(wlc.quantity,0)) mol_quantity
12349: from wms_license_plate_numbers wlpn,
12350: wms_lpn_contents wlc
12351: where wlc.parent_lpn_id = wlpn.lpn_id
12352: and wlpn.lpn_id = p_child_lpn_id1
12353: group by

Line 12369: from wms_license_plate_numbers

12365: select lpn_id
12366: ,license_plate_number
12367: ,parent_lpn_id
12368: ,organization_id
12369: from wms_license_plate_numbers
12370: where parent_lpn_id = p_lpn_id1;
12371:
12372: l_immediate_child_rec c_immediate_child%rowtype;
12373:

Line 12792: FROM wms_license_plate_numbers wlpn

12788: x_return_status := g_ret_sts_success;
12789:
12790: SELECT 'Y'
12791: INTO l_sub_match
12792: FROM wms_license_plate_numbers wlpn
12793: WHERE wlpn.lpn_id = p_lpn_id
12794: AND ((wlpn.lpn_context <> 5
12795: AND (Nvl(wlpn.subinventory_code,'@@@') = Nvl(p_subinventory,'@@@'))
12796: AND (Nvl(wlpn.locator_id,-1) = Nvl(p_locator_id,-1)))

Line 12833: from wms_license_plate_numbers

12829: is
12830: BEGIN
12831: select PARENT_LPN_ID
12832: into x_parent_lpn_id
12833: from wms_license_plate_numbers
12834: where license_plate_number = p_license_plate_number
12835: ;
12836: EXCEPTION
12837: WHEN OTHERS THEN

Line 12906: FROM wms_license_plate_numbers

12902: END If;
12903:
12904: FOR l_outermost_lpn IN (SELECT lpn_id, license_plate_number,
12905: Nvl(parent_lpn_id, outermost_lpn_id) parent_lpn_id
12906: FROM wms_license_plate_numbers
12907: START WITH lpn_id = p_from_lpn_id
12908: CONNECT BY lpn_id = PRIOR parent_lpn_id)
12909: LOOP
12910: l_outermost_lpn_id := l_outermost_lpn.lpn_id;

Line 12933: from wms_license_plate_numbers wlpn

12929: IF Nvl(p_transaction_type,'@@@') <> 'RECEIVE' THEN
12930: For l_wln_csr in (
12931: select lpn_id lpn_id,
12932: license_plate_number license_plate_number
12933: from wms_license_plate_numbers wlpn
12934: connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
12935: start with wlpn.lpn_id = l_outermost_lpn_id
12936: )
12937: Loop

Line 12954: -- AND exists ( select '1' from wms_license_plate_numbers wlpn

12950: -- 4507808
12951: -- Commented the exists statement below
12952: -- by the l_wln_csr above.
12953: -- where wlc.parent_lpn_id = wln.lpn_id
12954: -- AND exists ( select '1' from wms_license_plate_numbers wlpn
12955: -- where wlc.parent_lpn_id = wlpn.lpn_id
12956: -- connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
12957: -- start with wlpn.lpn_id = l_outermost_lpn_id
12958: --union all

Line 12959: --select '1' from wms_license_plate_numbers wlpn1

12955: -- where wlc.parent_lpn_id = wlpn.lpn_id
12956: -- connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
12957: -- start with wlpn.lpn_id = l_outermost_lpn_id
12958: --union all
12959: --select '1' from wms_license_plate_numbers wlpn1
12960: --where wlc.parent_lpn_id = wlpn1.lpn_id
12961: --and not exists ( select 1 from wms_lpn_interface wlpni
12962: -- where wlpni.lpn_id = p_from_lpn_id and
12963: -- Nvl(wlpni.parent_lpn_id, -1) <> Nvl(p_parent_lpn_id, -1)

Line 13034: from wms_license_plate_numbers wlpn

13030: ELSE --IF Nvl(p_transaction_type,'@@@') <> 'RECEIVE' THEN
13031: For l_wln_csr in (
13032: select lpn_id lpn_id,
13033: license_plate_number license_plate_number
13034: from wms_license_plate_numbers wlpn
13035: connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
13036: start with wlpn.lpn_id = l_outermost_lpn_id
13037: )
13038: Loop

Line 13056: -- AND exists ( select '1' from wms_license_plate_numbers wlpn

13052: -- 4507808
13053: -- Commented the exists statement below
13054: -- and replaced by the outer cursor l_wln_csr
13055: -- where wlc.parent_lpn_id = wln.lpn_id
13056: -- AND exists ( select '1' from wms_license_plate_numbers wlpn
13057: -- where wlc.parent_lpn_id = wlpn.lpn_id
13058: -- connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
13059: -- start with wlpn.lpn_id = l_outermost_lpn_id
13060: --union all

Line 13061: --select '1' from wms_license_plate_numbers wlpn1

13057: -- where wlc.parent_lpn_id = wlpn.lpn_id
13058: -- connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
13059: -- start with wlpn.lpn_id = l_outermost_lpn_id
13060: --union all
13061: --select '1' from wms_license_plate_numbers wlpn1
13062: --where wlc.parent_lpn_id = wlpn1.lpn_id
13063: --and not exists ( select 1 from wms_lpn_interface wlpni
13064: -- where wlpni.lpn_id = p_from_lpn_id and
13065: -- Nvl(wlpni.parent_lpn_id, -1) <> Nvl(p_parent_lpn_id, -1)

Line 13254: from wms_license_plate_numbers

13250:
13251: cursor c_child_lpn(p_child_lpn_id varchar2) is
13252: select lpn_id
13253: ,license_plate_number
13254: from wms_license_plate_numbers
13255: where outermost_lpn_id = p_child_lpn_id;
13256:
13257: l_child_lpn_rec c_child_lpn%rowtype;
13258:

Line 13262: from wms_license_plate_numbers

13258:
13259: cursor c_immd_child_lpn(p_child_lpn_id varchar2) is
13260: select lpn_id
13261: ,license_plate_number
13262: from wms_license_plate_numbers
13263: where parent_lpn_id = p_child_lpn_id;
13264:
13265: l_immd_child_rec c_immd_child_lpn%rowtype;
13266:

Line 13703: from WMS_LICENSE_PLATE_NUMBERS WLPN,

13699: WLPN.LPN_CONTEXT
13700: into l_source_header_id ,
13701: l_asn_type,
13702: l_lpn_context
13703: from WMS_LICENSE_PLATE_NUMBERS WLPN,
13704: RCV_SHIPMENT_HEADERS RSH
13705: where WLPN.lpn_id = l_lpn_rec.lpn_id
13706: AND (
13707: ((rsh.receipt_source_code IN ('INVENTORY','INTERNAL ORDER')

Line 14138: FROM wms_license_plate_numbers

14134: SELECT subinventory_code
14135: , locator_id
14136: INTO l_validate_sub
14137: , l_validate_loc_id
14138: FROM wms_license_plate_numbers
14139: WHERE lpn_id = l_lpn_rec.transfer_lpn_id
14140: OR license_plate_number = l_lpn_rec.transfer_license_plate_number;
14141: EXCEPTION
14142: WHEN OTHERS THEN

Line 15763: FROM wms_license_plate_numbers wlpn2

15759: FROM rcv_transactions_interface rti
15760: WHERE rti.lpn_id = rti.transfer_lpn_id
15761: AND rti.lpn_group_id = p_lpn_group_id
15762: AND rti.lpn_id IN (SELECT lpn_id
15763: FROM wms_license_plate_numbers wlpn2
15764: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
15765: START WITH wlpn2.lpn_id = c_wlpni_rec.LPN_ID
15766: )
15767: AND NOT exists ( SELECT 'x' FROM wms_lpn_contents