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_LPN_INTERFACE

Line 108: l_epc_sql := l_epc_sql || ' FROM wms_lpn_interface';

104: x_epc_value := NULL;
105: ELSE
106: IF (p_mode = 1) THEN
107: l_epc_sql := 'SELECT ' || l_epc_column;
108: l_epc_sql := l_epc_sql || ' FROM wms_lpn_interface';
109: l_epc_sql := l_epc_sql || ' WHERE license_plate_number = :lpn';
110: l_epc_sql := l_epc_sql || ' AND source_group_id = :src_grp_id';
111:
112: IF (l_debug = 1) THEN

Line 225: from wms_lpn_interface

221: is
222: BEGIN
223: x_exists := 0;
224: select 1 into x_exists
225: from wms_lpn_interface
226: where ( ( license_plate_number = p_license_plate_number ) or ( lpn_id = p_lpn_id ))
227: and source_group_id = p_lpn_group_id
228: and rownum = 1;
229: EXCEPTION

Line 2450: UPDATE wms_lpn_interface

2446: --WLPNI will have rti.group_id
2447: --Update them to RTI.LPN_GROUP_ID so that it will get
2448: --picked up when the transaction is processed
2449: BEGIN
2450: UPDATE wms_lpn_interface
2451: SET source_group_id = l_rti_rec.lpn_group_id
2452: ,organization_id = l_rti_rec.to_organization_id
2453: WHERE source_group_id = p_group_id
2454: AND EXISTS (SELECT 1 --Only for EDI TXN we are doing this

Line 12349: insert into wms_lpn_interface (

12345: print_debug('insert_wlpni : - WLPNI for LPNID = ' || p_lpn_id || ' LPN =' ||
12346: p_license_plate_number || ' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
12347: END IF;
12348:
12349: insert into wms_lpn_interface (
12350: LPN_ID ,
12351: LICENSE_PLATE_NUMBER ,
12352: INVENTORY_ITEM_ID ,
12353: LAST_UPDATE_DATE ,

Line 12572: FROM wms_lpn_interface wlpni

12568: l_tare_wt_uom,
12569: l_tare_wt,
12570: l_container_item_id
12571: /*Bug 6600013 */
12572: FROM wms_lpn_interface wlpni
12573: WHERE wlpni.license_plate_number = p_license_plate_number
12574: AND wlpni.source_group_id = p_lpn_group_id;
12575: EXCEPTION
12576: WHEN no_data_found THEN

Line 12850: delete from wms_lpn_interface where source_group_id = p_lpn_group_id

12846:
12847: -- Initialize API return status to success
12848: x_return_status := g_ret_sts_success;
12849:
12850: delete from wms_lpn_interface where source_group_id = p_lpn_group_id
12851: and ( ( lpn_id = p_lpn_id ) or (license_plate_number = p_license_plate_number) ) ;
12852:
12853: Exception
12854: When others then null;

Line 13430: from wms_lpn_interface

13426: select PARENT_LPN_ID,
13427: PARENT_LICENSE_PLATE_NUMBER
13428: into x_parent_lpn_id,
13429: x_parent_lpn
13430: from wms_lpn_interface
13431: where lpn_id = p_lpn_id
13432: and source_group_id = p_lpn_group_id
13433: ;
13434: else

Line 13439: from wms_lpn_interface

13435: select PARENT_LPN_ID,
13436: PARENT_LICENSE_PLATE_NUMBER
13437: into x_parent_lpn_id,
13438: x_parent_lpn
13439: from wms_lpn_interface
13440: where license_plate_number = p_license_plate_number
13441: and source_group_id = p_lpn_group_id;
13442: end if;
13443: EXCEPTION

Line 13490: FROM wms_lpn_interface

13486:
13487: BEGIN
13488: SELECT '1'
13489: INTO l_dummy
13490: FROM wms_lpn_interface
13491: WHERE source_group_id = p_lpn_group_id
13492: AND (lpn_id = l_outermost_lpn.lpn_id
13493: OR license_plate_number = l_outermost_lpn.license_plate_number)
13494: AND Nvl(parent_lpn_id, -1) <> l_outermost_lpn.parent_lpn_id;

Line 13536: --and not exists ( select 1 from wms_lpn_interface wlpni

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)
13539: -- )
13540: --connect by prior wlpn1.parent_lpn_id = wlpn1.lpn_id

Line 13639: --and not exists ( select 1 from wms_lpn_interface wlpni

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)
13642: -- )
13643: --connect by prior wlpn1.parent_lpn_id = wlpn1.lpn_id

Line 14890: from wms_lpn_interface wlpni

14886: parent_lpn_id,
14887: parent_license_plate_number
14888: into l_PTLPN_ID,
14889: l_PTLPN
14890: from wms_lpn_interface wlpni
14891: where ( nvl(wlpni.license_plate_number,'-1') = nvl(l_WLPNIQLPN,'-1') or
14892: nvl(wlpni.lpn_id,'-1') = nvl(l_WLPNIQLPN_ID,'-1') )
14893: and wlpni.source_group_id = p_lpn_group_id;
14894:

Line 16440: from wms_lpn_interface

16436: parent_lpn_id,
16437: parent_license_plate_number,
16438: organization_id,
16439: rowid
16440: from wms_lpn_interface
16441: where source_group_id = p_lpn_group_id)
16442: Loop
16443: l_progress := 'WMSINB-20081';
16444:

Line 16621: delete from wms_lpn_interface where source_group_id = p_lpn_group_id;

16617: End Loop;
16618:
16619: -- Finally delete the processed rows.
16620: l_progress := 'WMSINB-20153';
16621: delete from wms_lpn_interface where source_group_id = p_lpn_group_id;
16622:
16623:
16624: EXCEPTION
16625: WHEN fnd_api.g_exc_error THEN