AR Revenue Recognition
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Revenue Recognition
Application: Receivables
Source: Revenue Recognition (XML)
Short Name: ARBARL_XML
DB package: AR_ARBARL_XMLP_PKG
Description: Revenue Recognition
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 | |
---|---|---|---|
Operating Unit |
|
LOV | |
Print Format |
|
LOV Oracle | |
Commit Work |
|
LOV Oracle |