APPS.INV_RCV_INTEGRATION_PVT dependencies on WMS_LPN_CONTENTS_INTERFACE

Line 2223: wms_lpn_contents_interface wmslpnci,

2219: wmslpnci.attribute13 attribute13,
2220: wmslpnci.attribute14 attribute14,
2221: wmslpnci.attribute15 attribute15
2222: FROM
2223: wms_lpn_contents_interface wmslpnci,
2224: wms_license_plate_numbers wmslpn
2225: WHERE
2226: wmslpnci.interface_transaction_id = l_intf_txn_id AND
2227: wmslpn.license_plate_number (+)= wmslpnci.license_plate_number;

Line 2427: FROM wms_lpn_contents_interface

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
2426: --And EDI TXN will have WLPNCI
2427: FROM wms_lpn_contents_interface
2428: WHERE group_id = p_group_id);
2429: EXCEPTION
2430: WHEN OTHERS THEN
2431: IF (l_debug = 1) THEN

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

2931: WHERE rti.lpn_group_id IS NULL
2932: AND ( ( (rti.lpn_id IS NOT NULL
2933: OR rti.license_plate_number IS NOT NULL)
2934: ) or
2935: (exists ( select 'x' from wms_lpn_contents_interface wlc
2936: where wlc.interface_transaction_id =
2937: rti.interface_transaction_id
2938: )
2939: )