APPS.ARP_CINT dependencies on RA_CUSTOMERS_INTERFACE

Line 49: FROM ra_customers_interface rci ,

45: rci.address_attribute8 attribute8,
46: rci.address_attribute9 attribute9,
47: rci.address_attribute10 attribute10,
48: rci.rowid row_id
49: FROM ra_customers_interface rci ,
50: ar_system_parameters sp
51: WHERE rci.interface_status is null
52: AND rci.orig_system_address_ref is not null
53: AND rci.request_id = request_id

Line 56: FROM ra_customers_interface rci2

52: AND rci.orig_system_address_ref is not null
53: AND rci.request_id = request_id
54: AND rci.country = sp.default_country
55: AND rci.rowid in (SELECT min(rci2.rowid)
56: FROM ra_customers_interface rci2
57: WHERE rci2.interface_status is null
58: AND rci2.orig_system_address_ref =
59: rci.orig_system_address_ref
60: /* Added the site_use_code clause for Bug 235747 which causes all of the *

Line 62: * clause causes only 1 of the row from ra_customers_interface to be *

58: AND rci2.orig_system_address_ref =
59: rci.orig_system_address_ref
60: /* Added the site_use_code clause for Bug 235747 which causes all of the *
61: * relevant rows to be considered for error checking. Leaving this where *
62: * clause causes only 1 of the row from ra_customers_interface to be *
63: * selected. In order to do proper error checking we would like to have *
64: * all those rows which have a distinct combination of address ref and *
65: * site use code. */
66: AND NVL(rci2.site_use_code,'X') = NVL(rci.site_use_code,'X')

Line 84: UPDATE ra_customers_interface

80: rowid_in in rowid
81: ) IS
82: BEGIN
83:
84: UPDATE ra_customers_interface
85: SET warning_text = warning_text_in,
86: location_ccid = location_ccid_in,
87: message_text = message_text_in,
88: interface_status = interface_status_in