AR Revenue Recognition

select   
          trx_class.meaning                 c_trx_type
,         t.trx_number                          c_trx_number  
,         account_class.meaning         c_account_class
,         d.gl_date                                c_gl_date
,         rtrim(rpad(null,100) )    c_flex_acc
,         t.invoice_currency_code       c_currency
,         d.amount                               c_amount_dist
,         d.acctd_amount                    c_accounted_amount
,          substrb(party.party_name,1,50)                c_customer_name
,   decode(gcc.enabled_flag, 'N', '+',
                         decode(gcc.summary_flag, 'Y','+',
                           decode(least(d.gl_date,
                             nvl(gcc.start_date_active+1,
                                 to_date('01/01/0001','MM/DD/RRRR'))),
                                                 d.gl_date, '+',
                           decode(greatest(d.gl_date,
                             nvl(gcc.end_date_active-1,
                                 to_date('12/31/4712','MM/DD/RRRR'))),
                                     d.gl_date, '+', NULL))))   c_invalid_ccid, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_acc_disp', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_flex_acc_disp
from      
          ra_cust_trx_line_gl_dist    d
,         gl_code_combinations        gcc
,         hz_cust_accounts                      c
,         hz_parties	party
,         ra_customer_trx                 t
,         ra_cust_trx_types              y
,         ar_lookups                          trx_class
,         ar_lookups                          account_class
where     
             d.CODE_COMBINATION_ID  = gcc.code_combination_id
and       t.customer_trx_id                  = d.customer_trx_id
and       d.request_id                           = :p_conc_request_id
and       t.cust_trx_type_id                 = y.cust_trx_type_id
and       t.bill_to_customer_id            = c.cust_account_id
and       c.party_id = party.party_id
and       gcc.chart_of_accounts_id      = :structure_acc
and       d.account_set_flag                = 'N'
and       trx_class.lookup_type          = 'INV/CM'
and       trx_class.lookup_code          = y.type
and       account_class.lookup_type  = 'AUTOGL_TYPE'
and       account_class.lookup_code  = d.account_class
and       :p_report_mode                     = 'D'
order by  
          trx_class.meaning
,         t.trx_number
,         account_class.meaning
,         d.gl_date
,         t.invoice_currency_code