APPS.INV_RCV_INTEGRATION_PVT dependencies on WMS_LPN_CONTENTS_INTERFACE

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: )