AR Revenue Recognition

Description
Categories: BI Publisher, Financials
Application: Receivables
Source: Revenue Recognition (XML)
Short Name: ARBARL_XML
DB package: AR_ARBARL_XMLP_PKG
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
Parameter Name SQL text Validation
Debug: Skip Rounding
 
LOV Oracle
Continue On Error
 
LOV Oracle
Org Id
 
Number
Generate Distributions
 
LOV Oracle
Chart Of Accounts
 
User ID
 
Number
Commit Work
 
LOV Oracle
Print Format
 
LOV Oracle
Ask a question