DBA Data[Home] [Help]

APPS.AR_LL_RCV_GROUPING_HOOK dependencies on RA_CUSTOMER_TRX_LINES

Line 14: --update ra_customer_Trx_lines

10: -- Uncomment the following update, to do your own grouping
11: -- Remember not to update Source_data_key4 with 0, as it is reserved
12: -- for lines without any groups
13: --
14: --update ra_customer_Trx_lines
15: --set source_data_key5 = decode(mod(line_number,4),1,'Printers',2,'Scanners',3,'Monitors')
16: -- ,source_data_key4 = mod(line_number,4)
17: --where interface_line_attribute9 <> 'Service';
18: --

Line 21: update ra_customer_Trx_lines

17: --where interface_line_attribute9 <> 'Service';
18: --
19: -- Don't change any of the updates below.
20:
21: update ra_customer_Trx_lines
22: set source_data_key5 = get_group_name (source_data_key1, source_data_key2)
23: ,source_data_key4 = get_group_id (source_data_key1, source_data_key2)
24: where customer_trx_id = x_customer_trx_id
25: AND interface_line_attribute9 = 'Service';