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 101: l_epc_sql := l_epc_sql || ' FROM wms_lpn_interface';

97: x_epc_value := NULL;
98: ELSE
99: IF (p_mode = 1) THEN
100: l_epc_sql := 'SELECT ' || l_epc_column;
101: l_epc_sql := l_epc_sql || ' FROM wms_lpn_interface';
102: l_epc_sql := l_epc_sql || ' WHERE license_plate_number = :lpn';
103: l_epc_sql := l_epc_sql || ' AND source_group_id = :src_grp_id';
104:
105: IF (l_debug = 1) THEN

Line 218: from wms_lpn_interface

214: is
215: BEGIN
216: x_exists := 0;
217: select 1 into x_exists
218: from wms_lpn_interface
219: where ( ( license_plate_number = p_license_plate_number ) or ( lpn_id = p_lpn_id ))
220: and source_group_id = p_lpn_group_id
221: and rownum = 1;
222: EXCEPTION

Line 2421: UPDATE wms_lpn_interface

2417: --WLPNI will have rti.group_id
2418: --Update them to RTI.LPN_GROUP_ID so that it will get
2419: --picked up when the transaction is processed
2420: BEGIN
2421: UPDATE wms_lpn_interface
2422: SET source_group_id = l_rti_rec.lpn_group_id
2423: ,organization_id = l_rti_rec.to_organization_id
2424: WHERE source_group_id = p_group_id
2425: AND EXISTS (SELECT 1 --Only for EDI TXN we are doing this

Line 11864: insert into wms_lpn_interface (

11860: print_debug('insert_wlpni : - WLPNI for LPNID = ' || p_lpn_id || ' LPN =' ||
11861: p_license_plate_number || ' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
11862: END IF;
11863:
11864: insert into wms_lpn_interface (
11865: LPN_ID ,
11866: LICENSE_PLATE_NUMBER ,
11867: INVENTORY_ITEM_ID ,
11868: LAST_UPDATE_DATE ,

Line 12059: FROM wms_lpn_interface wlpni

12055: l_source_name,
12056: l_source_line_id,
12057: l_source_line_detail_id,
12058: l_parent_lpn_id
12059: FROM wms_lpn_interface wlpni
12060: WHERE wlpni.license_plate_number = p_license_plate_number
12061: AND wlpni.source_group_id = p_lpn_group_id;
12062: EXCEPTION
12063: WHEN no_data_found THEN

Line 12276: delete from wms_lpn_interface where source_group_id = p_lpn_group_id

12272:
12273: -- Initialize API return status to success
12274: x_return_status := g_ret_sts_success;
12275:
12276: delete from wms_lpn_interface where source_group_id = p_lpn_group_id
12277: and ( ( lpn_id = p_lpn_id ) or (license_plate_number = p_license_plate_number) ) ;
12278:
12279: Exception
12280: When others then null;

Line 12856: from wms_lpn_interface

12852: select PARENT_LPN_ID,
12853: PARENT_LICENSE_PLATE_NUMBER
12854: into x_parent_lpn_id,
12855: x_parent_lpn
12856: from wms_lpn_interface
12857: where lpn_id = p_lpn_id
12858: and source_group_id = p_lpn_group_id
12859: ;
12860: else

Line 12865: from wms_lpn_interface

12861: select PARENT_LPN_ID,
12862: PARENT_LICENSE_PLATE_NUMBER
12863: into x_parent_lpn_id,
12864: x_parent_lpn
12865: from wms_lpn_interface
12866: where license_plate_number = p_license_plate_number
12867: and source_group_id = p_lpn_group_id;
12868: end if;
12869: EXCEPTION

Line 12915: FROM wms_lpn_interface

12911:
12912: BEGIN
12913: SELECT '1'
12914: INTO l_dummy
12915: FROM wms_lpn_interface
12916: WHERE source_group_id = p_lpn_group_id
12917: AND (lpn_id = l_outermost_lpn.lpn_id
12918: OR license_plate_number = l_outermost_lpn.license_plate_number)
12919: AND Nvl(parent_lpn_id, -1) <> l_outermost_lpn.parent_lpn_id;

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

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

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

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

Line 14187: from wms_lpn_interface wlpni

14183: parent_lpn_id,
14184: parent_license_plate_number
14185: into l_PTLPN_ID,
14186: l_PTLPN
14187: from wms_lpn_interface wlpni
14188: where ( nvl(wlpni.license_plate_number,'-1') = nvl(l_WLPNIQLPN,'-1') or
14189: nvl(wlpni.lpn_id,'-1') = nvl(l_WLPNIQLPN_ID,'-1') )
14190: and wlpni.source_group_id = p_lpn_group_id;
14191:

Line 15686: from wms_lpn_interface

15682: parent_lpn_id,
15683: parent_license_plate_number,
15684: organization_id,
15685: rowid
15686: from wms_lpn_interface
15687: where source_group_id = p_lpn_group_id)
15688: Loop
15689: l_progress := 'WMSINB-20081';
15690:

Line 15867: delete from wms_lpn_interface where source_group_id = p_lpn_group_id;

15863: End Loop;
15864:
15865: -- Finally delete the processed rows.
15866: l_progress := 'WMSINB-20153';
15867: delete from wms_lpn_interface where source_group_id = p_lpn_group_id;
15868:
15869:
15870: EXCEPTION
15871: WHEN fnd_api.g_exc_error THEN