DBA Data[Home] [Help]

APPS.AR_EXCHANGE_INTERFACE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

	select nvl(generate_customer_number,'N')
	from 	ar_system_parameters;
Line: 67

	update ra_customers_interface_all
	set customer_number = decode(l_cust_autonum_flag, 'Y', NULL, customer_number)
	where orig_system_customer_ref  like 'EXCHANGE_CUST%';