APPS.AR_LL_RCV_GROUPING_HOOK SQL Statements

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

Line: 5

procedure update_source_data_keys (x_customer_Trx_id in number) is
--This sample procedure inserts dummy group names into Source_data_key5
-- and the corresponding dummy group id to source_data_key4
begin
  --
  -- Uncomment the following update, to do your own grouping
  -- Remember not to update Source_data_key4 with 0, as it is reserved
  -- for lines without any groups
  --
  --update ra_customer_Trx_lines
  --set source_data_key5 = decode(mod(line_number,4),1,'Printers',2,'Scanners',3,'Monitors')
  --   ,source_data_key4 = mod(line_number,4)
  --where interface_line_attribute9 <> 'Service';

Line: 21

  update ra_customer_Trx_lines
  set source_data_key5 = get_group_name (source_data_key1, source_data_key2)
     ,source_data_key4 = get_group_id (source_data_key1, source_data_key2)
  where customer_trx_id = x_customer_trx_id
  AND interface_line_attribute9 = 'Service';

Line: 40

 select srv.id
   into group_id
 from oks_billprst_srvline_v srv
 where srv.id(+) = sdk1
  and srv.bcl_id(+) = sdk2
  and rownum = 1;

Line: 59

 select srv.name
 into group_name
 from oks_billprst_srvline_v srv
 where srv.id(+) = sdk1
  and srv.bcl_id(+) = sdk2
  and rownum = 1;