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 322: FROM wms_license_plate_numbers wlpn2

318: SELECT '1' INTO l_dummy
319: FROM wms_lpn_contents wlc
320: , mtl_system_items msi
321: , (SELECT lpn_id
322: FROM wms_license_plate_numbers wlpn2
323: WHERE wlpn2.organization_id = p_org_id
324: AND wlpn2.lpn_context <> G_LPN_CONTEXT_STORES
325: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
326: START WITH wlpn2.lpn_id = p_lpn_id

Line 329: FROM wms_license_plate_numbers wlpn3

325: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
326: START WITH wlpn2.lpn_id = p_lpn_id
327: UNION ALL
328: SELECT lpn_id
329: FROM wms_license_plate_numbers wlpn3
330: WHERE wlpn3.organization_id = p_org_id
331: AND wlpn3.lpn_context <> G_LPN_CONTEXT_STORES
332: CONNECT BY PRIOR wlpn3.parent_lpn_id = wlpn3.lpn_id
333: START WITH wlpn3.parent_lpn_id = p_lpn_id) wlpn

Line 1235: FROM wms_license_plate_numbers

1231: IF l_asn_lpn_id IS NOT NULL THEN
1232: BEGIN
1233: SELECT lpn_context
1234: INTO l_lpn_context
1235: FROM wms_license_plate_numbers
1236: WHERE lpn_id = l_asn_lpn_id;
1237: EXCEPTION
1238: WHEN OTHERS THEN
1239: IF (l_debug = 1) THEN

Line 2071: from wms_license_plate_numbers

2067: x_license_plate_number,
2068: x_lpn_context,
2069: x_parent_lpn_id,
2070: x_source_header_id
2071: from wms_license_plate_numbers
2072: where lpn_id = x_lpn_id
2073: and license_plate_number = x_license_plate_number
2074: ;
2075: return TRUE;

Line 2087: from wms_license_plate_numbers

2083: x_license_plate_number,
2084: x_lpn_context,
2085: x_parent_lpn_id,
2086: x_source_header_id
2087: from wms_license_plate_numbers
2088: where lpn_id = x_lpn_id
2089: ;
2090: return TRUE;
2091: Elsif (x_lpn_id is null and x_license_plate_number is not null ) Then

Line 2102: from wms_license_plate_numbers

2098: x_license_plate_number,
2099: x_lpn_context,
2100: x_parent_lpn_id,
2101: x_source_header_id
2102: from wms_license_plate_numbers
2103: where license_plate_number = x_license_plate_number
2104: ;
2105: return TRUE;
2106: End if;

Line 2253: wms_license_plate_numbers wmslpn

2249: wmslpnci.attribute14 attribute14,
2250: wmslpnci.attribute15 attribute15
2251: FROM
2252: wms_lpn_contents_interface wmslpnci,
2253: wms_license_plate_numbers wmslpn
2254: WHERE
2255: wmslpnci.interface_transaction_id = l_intf_txn_id AND
2256: wmslpn.license_plate_number (+)= wmslpnci.license_plate_number;
2257:

Line 3490: l_lpn_rec WMS_LICENSE_PLATE_NUMBERS%rowtype;

3486: ,p_source_type_id IN NUMBER DEFAULT NULL) IS
3487:
3488: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3489: l_progress VARCHAR2(15) := '10';
3490: l_lpn_rec WMS_LICENSE_PLATE_NUMBERS%rowtype;
3491:
3492: BEGIN
3493:
3494: -- Initialize API return status to success

Line 7541: FROM wms_license_plate_numbers wlpn, mtl_txn_request_lines mtrl

7537: SELECT 'Y', mtrl.from_subinventory_code, mtrl.from_locator_id,
7538: mtrl.quantity
7539: INTO l_discrepancy_exist, l_mol_sub, l_mol_loc_id,
7540: l_mol_qty_in_puom
7541: FROM wms_license_plate_numbers wlpn, mtl_txn_request_lines mtrl
7542: WHERE wlpn.lpn_id = p_transfer_lpn_id
7543: AND wlpn.lpn_context = 3
7544: AND wlpn.organization_id = p_org_id
7545: AND wlpn.organization_id = mtrl.organization_id

Line 8480: from wms_license_plate_numbers wlpn

8476: Begin
8477: -- Get the LPN's Org Here
8478: select organization_id
8479: into l_lpn_org
8480: from wms_license_plate_numbers wlpn
8481: where wlpn.lpn_id = l_rti_rec.lpn_id;
8482: --
8483: l_progress := 'WMSINB-14465';
8484: Exception

Line 8837: from wms_license_plate_numbers wlpn

8833: Begin
8834: -- Get the LPN's Org Here
8835: select organization_id
8836: into l_lpn_org
8837: from wms_license_plate_numbers wlpn
8838: where wlpn.lpn_id = l_rti_rec.lpn_id;
8839: --
8840: l_progress := 'WMSINB-14465';
8841: Exception

Line 9075: FROM wms_license_plate_numbers

9071: --Also null out source_name and source_header_id.
9072: --This needs to be done only if the LPN is getting unpacked completely.
9073: SELECT lpn_context
9074: INTO l_current_lpn_context
9075: FROM wms_license_plate_numbers
9076: WHERE lpn_id = l_rti_rec.lpn_id;
9077:
9078: IF (l_current_lpn_context = 5) THEN
9079: IF (l_debug = 1) THEN

Line 11052: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn

11048: Decode(rsh.receipt_source_code,'INTERNAL
11049: ORDER','REQ','INVENTORY','INVENTORY','VENDOR','PO','CUSTOMER','RMA')
11050: INTO l_receipt_source_code
11051: , l_source_document_code
11052: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
11053: WHERE RSH.SHIPMENT_HEADER_ID = WLPN.SOURCE_HEADER_ID
11054: AND WLPN.SOURCE_HEADER_ID IS NOT NULL
11055: AND wlpn.lpn_id = p_lpn_id
11056: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 11067: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn

11063: Decode(rsh.receipt_source_code,'INTERNAL
11064: ORDER','REQ','INVENTORY','INVENTORY','VENDOR','PO','CUSTOMER','RMA')
11065: INTO l_receipt_source_code
11066: , l_source_document_code
11067: FROM rcv_shipment_headers rsh, wms_license_plate_numbers wlpn
11068: WHERE RSH.SHIPMENT_NUM = WLPN.SOURCE_NAME
11069: AND WLPN.SOURCE_NAME IS NOT NULL
11070: AND wlpn.lpn_id = p_lpn_id
11071: AND exists (SELECT '1' FROM rcv_shipment_lines rsl

Line 12902: from wms_license_plate_numbers

12898:
12899: cursor c_child_lpn(p_child_lpn_id NUMBER) is
12900: select distinct lpn_id
12901: ,license_plate_number
12902: from wms_license_plate_numbers
12903: connect by prior lpn_id = parent_lpn_id
12904: start with lpn_id = p_child_lpn_id
12905: ;
12906:

Line 12923: from wms_license_plate_numbers wlpn,

12919: ,NULL project_id
12920: ,NULL task_id
12921: ,0 mmtt_quantity
12922: ,sum(nvl(wlc.quantity,0)) mol_quantity
12923: from wms_license_plate_numbers wlpn,
12924: wms_lpn_contents wlc
12925: where wlc.parent_lpn_id = wlpn.lpn_id
12926: and wlpn.lpn_id = p_child_lpn_id1
12927: group by

Line 12943: from wms_license_plate_numbers

12939: select lpn_id
12940: ,license_plate_number
12941: ,parent_lpn_id
12942: ,organization_id
12943: from wms_license_plate_numbers
12944: where parent_lpn_id = p_lpn_id1;
12945:
12946: l_immediate_child_rec c_immediate_child%rowtype;
12947:

Line 13366: FROM wms_license_plate_numbers wlpn

13362: x_return_status := g_ret_sts_success;
13363:
13364: SELECT 'Y'
13365: INTO l_sub_match
13366: FROM wms_license_plate_numbers wlpn
13367: WHERE wlpn.lpn_id = p_lpn_id
13368: AND ((wlpn.lpn_context <> 5
13369: AND (Nvl(wlpn.subinventory_code,'@@@') = Nvl(p_subinventory,'@@@'))
13370: AND (Nvl(wlpn.locator_id,-1) = Nvl(p_locator_id,-1)))

Line 13407: from wms_license_plate_numbers

13403: is
13404: BEGIN
13405: select PARENT_LPN_ID
13406: into x_parent_lpn_id
13407: from wms_license_plate_numbers
13408: where license_plate_number = p_license_plate_number
13409: ;
13410: EXCEPTION
13411: WHEN OTHERS THEN

Line 13481: FROM wms_license_plate_numbers

13477: END If;
13478:
13479: FOR l_outermost_lpn IN (SELECT lpn_id, license_plate_number,
13480: Nvl(parent_lpn_id, outermost_lpn_id) parent_lpn_id
13481: FROM wms_license_plate_numbers
13482: START WITH lpn_id = p_from_lpn_id
13483: CONNECT BY lpn_id = PRIOR parent_lpn_id)
13484: LOOP
13485: l_outermost_lpn_id := l_outermost_lpn.lpn_id;

Line 13508: from wms_license_plate_numbers wlpn

13504: IF Nvl(p_transaction_type,'@@@') <> 'RECEIVE' THEN
13505: For l_wln_csr in (
13506: select lpn_id lpn_id,
13507: license_plate_number license_plate_number
13508: from wms_license_plate_numbers wlpn
13509: connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
13510: start with wlpn.lpn_id = l_outermost_lpn_id
13511: )
13512: Loop

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

13525: -- 4507808
13526: -- Commented the exists statement below
13527: -- by the l_wln_csr above.
13528: -- where wlc.parent_lpn_id = wln.lpn_id
13529: -- AND exists ( select '1' from wms_license_plate_numbers wlpn
13530: -- where wlc.parent_lpn_id = wlpn.lpn_id
13531: -- connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
13532: -- start with wlpn.lpn_id = l_outermost_lpn_id
13533: --union all

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

13530: -- where wlc.parent_lpn_id = wlpn.lpn_id
13531: -- connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
13532: -- start with wlpn.lpn_id = l_outermost_lpn_id
13533: --union all
13534: --select '1' from wms_license_plate_numbers wlpn1
13535: --where wlc.parent_lpn_id = wlpn1.lpn_id
13536: --and not exists ( select 1 from wms_lpn_interface wlpni
13537: -- where wlpni.lpn_id = p_from_lpn_id and
13538: -- Nvl(wlpni.parent_lpn_id, -1) <> Nvl(p_parent_lpn_id, -1)

Line 13610: from wms_license_plate_numbers wlpn

13606: ELSE --IF Nvl(p_transaction_type,'@@@') <> 'RECEIVE' THEN
13607: For l_wln_csr in (
13608: select lpn_id lpn_id,
13609: license_plate_number license_plate_number
13610: from wms_license_plate_numbers wlpn
13611: connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
13612: start with wlpn.lpn_id = l_outermost_lpn_id
13613: )
13614: Loop

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

13628: -- 4507808
13629: -- Commented the exists statement below
13630: -- and replaced by the outer cursor l_wln_csr
13631: -- where wlc.parent_lpn_id = wln.lpn_id
13632: -- AND exists ( select '1' from wms_license_plate_numbers wlpn
13633: -- where wlc.parent_lpn_id = wlpn.lpn_id
13634: -- connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
13635: -- start with wlpn.lpn_id = l_outermost_lpn_id
13636: --union all

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

13633: -- where wlc.parent_lpn_id = wlpn.lpn_id
13634: -- connect by prior wlpn.lpn_id = wlpn.parent_lpn_id
13635: -- start with wlpn.lpn_id = l_outermost_lpn_id
13636: --union all
13637: --select '1' from wms_license_plate_numbers wlpn1
13638: --where wlc.parent_lpn_id = wlpn1.lpn_id
13639: --and not exists ( select 1 from wms_lpn_interface wlpni
13640: -- where wlpni.lpn_id = p_from_lpn_id and
13641: -- Nvl(wlpni.parent_lpn_id, -1) <> Nvl(p_parent_lpn_id, -1)

Line 13838: from wms_license_plate_numbers

13834:
13835: cursor c_child_lpn(p_child_lpn_id varchar2) is
13836: select lpn_id
13837: ,license_plate_number
13838: from wms_license_plate_numbers
13839: where outermost_lpn_id = p_child_lpn_id;
13840:
13841: l_child_lpn_rec c_child_lpn%rowtype;
13842:

Line 13846: from wms_license_plate_numbers

13842:
13843: cursor c_immd_child_lpn(p_child_lpn_id varchar2) is
13844: select lpn_id
13845: ,license_plate_number
13846: from wms_license_plate_numbers
13847: where parent_lpn_id = p_child_lpn_id;
13848:
13849: l_immd_child_rec c_immd_child_lpn%rowtype;
13850:

Line 14394: from WMS_LICENSE_PLATE_NUMBERS WLPN,

14390: WLPN.LPN_CONTEXT
14391: into l_source_header_id ,
14392: l_asn_type,
14393: l_lpn_context
14394: from WMS_LICENSE_PLATE_NUMBERS WLPN,
14395: RCV_SHIPMENT_HEADERS RSH
14396: where WLPN.lpn_id = l_lpn_rec.lpn_id
14397: AND (
14398: ((rsh.receipt_source_code IN ('INVENTORY','INTERNAL ORDER')

Line 14841: FROM wms_license_plate_numbers

14837: SELECT subinventory_code
14838: , locator_id
14839: INTO l_validate_sub
14840: , l_validate_loc_id
14841: FROM wms_license_plate_numbers
14842: WHERE lpn_id = l_lpn_rec.transfer_lpn_id
14843: OR license_plate_number = l_lpn_rec.transfer_license_plate_number;
14844: EXCEPTION
14845: WHEN OTHERS THEN

Line 16517: FROM wms_license_plate_numbers wlpn2

16513: FROM rcv_transactions_interface rti
16514: WHERE rti.lpn_id = rti.transfer_lpn_id
16515: AND rti.lpn_group_id = p_lpn_group_id
16516: AND rti.lpn_id IN (SELECT lpn_id
16517: FROM wms_license_plate_numbers wlpn2
16518: CONNECT BY PRIOR wlpn2.lpn_id = wlpn2.parent_lpn_id
16519: START WITH wlpn2.lpn_id = c_wlpni_rec.LPN_ID
16520: )
16521: AND NOT exists ( SELECT 'x' FROM wms_lpn_contents

Line 29195: WMS_LICENSE_PLATE_NUMBERS WLPN

29191: IS
29192: SELECT
29193: lpn_context, license_plate_number
29194: FROM
29195: WMS_LICENSE_PLATE_NUMBERS WLPN
29196: WHERE
29197: WLPN.LPN_ID = p_lpn_id ;
29198: l_progress VARCHAR2(15) := '00';
29199: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 29232: FROM WMS_LICENSE_PLATE_NUMBERS

29228: END IF;
29229: /*
29230: SELECT license_plate_number
29231: INTO l_lpn
29232: FROM WMS_LICENSE_PLATE_NUMBERS
29233: WHERE LPN_ID = p_lpn_id ;*/
29234:
29235: IF (l_debug = 1) THEN
29236: print_debug('VALIDATE_LPN - Checking LPN '||l_lpn||' is in receiving or not' || l_progress || '' || p_lpn_id,1 );