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_CONTENTS

Line 319: FROM wms_lpn_contents wlc

315: ELSE
316: g_mixed_expense_lpn_id := p_lpn_id ;
317: END IF;
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

Line 2252: wms_lpn_contents_interface wmslpnci,

2248: wmslpnci.attribute13 attribute13,
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;

Line 2456: FROM wms_lpn_contents_interface

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
2455: --And EDI TXN will have WLPNCI
2456: FROM wms_lpn_contents_interface
2457: WHERE group_id = p_group_id);
2458: EXCEPTION
2459: WHEN OTHERS THEN
2460: IF (l_debug = 1) THEN

Line 2966: (exists ( select 'x' from wms_lpn_contents_interface wlc

2962: WHERE rti.lpn_group_id IS NULL
2963: AND ( ( (rti.lpn_id IS NOT NULL
2964: OR rti.license_plate_number IS NOT NULL)
2965: ) or
2966: (exists ( select 'x' from wms_lpn_contents_interface wlc
2967: where wlc.interface_transaction_id =
2968: rti.interface_transaction_id
2969: )
2970: )

Line 8879: -- wms_lpn_contents and null out the lpn_id on mtl_serial_numbers

8875:
8876: -- We should not be doing full unpack. Instead if one of
8877: -- the conditions used to set l_full_unpack to true is
8878: -- met then we should null out the lot_number on
8879: -- wms_lpn_contents and null out the lpn_id on mtl_serial_numbers
8880:
8881: UPDATE wms_lpn_contents
8882: SET lot_number = NULL,
8883: SERIAL_SUMMARY_ENTRY=2,--15951100

Line 8881: UPDATE wms_lpn_contents

8877: -- the conditions used to set l_full_unpack to true is
8878: -- met then we should null out the lot_number on
8879: -- wms_lpn_contents and null out the lpn_id on mtl_serial_numbers
8880:
8881: UPDATE wms_lpn_contents
8882: SET lot_number = NULL,
8883: SERIAL_SUMMARY_ENTRY=2,--15951100
8884: revision = NULL
8885: WHERE parent_lpn_id = l_rti_rec.lpn_id

Line 9650: update wms_lpn_contents

9646:
9647: if l_serial_control_code not in (1,6) then
9648: --bug10298326 for serial control items where serial number is not defined, serial_summary_entry is set as 2...need to update to 1
9649: --this happens in case of ASN import.
9650: update wms_lpn_contents
9651: set serial_summary_entry = 1
9652: where parent_lpn_id = l_rti_rec.lpn_id
9653: and inventory_item_id = l_rti_rec.item_id
9654: and organization_id = l_rti_rec.to_organization_id

Line 11490: from wms_lpn_contents wlc

11486:
11487: For l_lot_rec in ( select lot_number,
11488: uom_code,
11489: sum(quantity) quantity
11490: from wms_lpn_contents wlc
11491: where wlc.inventory_item_id = p_item_id
11492: and wlc.organization_id = p_org_id
11493: and wlc.parent_lpn_id = p_lpn_id
11494: group by lot_number, uom_code )

Line 12924: wms_lpn_contents wlc

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
12928: wlpn.lpn_id

Line 13523: from wms_lpn_contents wlc

13519: ,wlc.organization_id organization_id
13520: --,wlc.item_description item_description
13521: ,sum(get_primary_qty(wlc.organization_id, wlc.inventory_item_id, wlc.uom_code,nvl(wlc.quantity,0)))
13522: primary_quantity
13523: from wms_lpn_contents wlc
13524: where wlc.parent_lpn_id = l_wln_csr.lpn_id
13525: -- 4507808
13526: -- Commented the exists statement below
13527: -- by the l_wln_csr above.

Line 13626: from wms_lpn_contents wlc

13622: --,wlc.item_description item_description
13623: ,wlc.lot_number lot_number
13624: ,sum(get_primary_qty(wlc.organization_id, wlc.inventory_item_id, wlc.uom_code,nvl(wlc.quantity,0)))
13625: primary_quantity
13626: from wms_lpn_contents wlc
13627: where wlc.parent_lpn_id = l_wln_csr.lpn_id
13628: -- 4507808
13629: -- Commented the exists statement below
13630: -- and replaced by the outer cursor l_wln_csr

Line 13855: from wms_lpn_contents

13851: cursor c_lpn_contents(p_child_lpn_id varchar2) is
13852: select parent_lpn_id
13853: ,inventory_item_id
13854: ,quantity
13855: from wms_lpn_contents
13856: where parent_lpn_id = p_child_lpn_id;
13857:
13858: l_lpn_contents_rec c_lpn_contents%rowtype;
13859:

Line 16521: AND NOT exists ( SELECT 'x' FROM wms_lpn_contents

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
16522: WHERE parent_lpn_id = c_wlpni_rec.LPN_ID
16523: )
16524: AND ROWNUM = 1
16525: ;