AR Transaction Types Listing

Description
Categories: BI Publisher, Financials
Application: Receivables
Source: Transaction Types Listing (XML)
Short Name: RAXTTL_XML
DB package: AR_RAXTTL_XMLP_PKG
SELECT
null revenue_account,
null freight_account,
null  receivable_account, 
null clearing_account,
null unbilled_account,
null  unearned_account,
null  tax_account,
   rtt.name                                     "Transaction Name",&Acct_Flex_All_Seg4  clearing_account,
   rtt.description
                                                "Transaction Description",
   look2.meaning                                "Transaction Class",
   DECODE(rtt.accounting_affect_flag,
          'Y', :yes, :no)                       "Open Receivable",
   DECODE(rtt.post_to_gl, 'Y', :yes, :no)       "Post to GL",
   rtt.default_term term_id,
   look3.meaning                   "Printing Option",
   look4.meaning                                "Transaction Status",
   rtt.subsequent_trx_type_id invoice_type_type_id,
   rtt.credit_memo_type_id credit_memo_type_id,
   DECODE(rtt.allow_freight_flag, 'Y', :yes, :no) allow_freight,
   DECODE(rtt.tax_calculation_flag, 'Y', :yes, :no) tax_calculation,
   look1.meaning creation_sign,
   DECODE(rtt.natural_application_only_flag, 'Y', :yes, :no) natural_application_only,
   DECODE(rtt.allow_overapplication_flag, 'Y', :yes, :no) allow_overapplication,
   rtt.start_date start_date, rtt.end_date end_date, 
	AR_RAXTTL_XMLP_PKG.invoice_typeformula(rtt.subsequent_trx_type_id) invoice_type, 
	AR_RAXTTL_XMLP_PKG.credit_memo_typeformula(rtt.credit_memo_type_id) credit_memo_type, 
	AR_RAXTTL_XMLP_PKG.term_nameformula(rtt.default_term) term_name, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('tax_account_dsp', 'SQLGL', 'GL#', gl7.CHART_OF_ACCOUNTS_ID, NULL, gl7.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') tax_account_dsp, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('revenue_account_dsp', 'SQLGL', 'GL#', gl1.CHART_OF_ACCOUNTS_ID, NULL, gl1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') revenue_account_dsp, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('freight_account_dsp', 'SQLGL', 'GL#', gl2.CHART_OF_ACCOUNTS_ID, NULL, gl2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') freight_account_dsp, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('receivable_account_dsp', 'SQLGL', 'GL#', gl3.CHART_OF_ACCOUNTS_ID, NULL, gl3.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') receivable_account_dsp, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('clearing_account_dsp', 'SQLGL', 'GL#', gl4.CHART_OF_ACCOUNTS_ID, NULL, gl4.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') clearing_account_dsp, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('unbilled_account_dsp', 'SQLGL', 'GL#', gl5.CHART_OF_ACCOUNTS_ID, NULL, gl5.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') unbilled_account_dsp, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('unearned_account_dsp', 'SQLGL', 'GL#', gl6.CHART_OF_ACCOUNTS_ID, NULL, gl6.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') unearned_account_dsp
FROM   ra_cust_trx_types rtt, ar_lookups look1,
       ar_lookups look2, ar_lookups look3,
       ar_lookups look4, gl_code_combinations gl1, gl_code_combinations gl2,
       gl_code_combinations gl3, gl_code_combinations gl4,
       gl_code_combinations gl5, gl_code_combinations gl6,
       gl_code_combinations gl7
WHERE  rtt.creation_sign = look1.lookup_code
AND    look1.lookup_type = 'SIGN'
AND    rtt.type  = look2.lookup_code(+)
AND    look2.lookup_type(+)  = 'INV/CM'
AND    rtt.default_printing_option = look3.lookup_code
AND    look3.lookup_type = 'INVOICE_PRINT_OPTIONS'
AND    rtt.default_status = look4.lookup_code
AND    look4.lookup_type = 'INVOICE_TRX_STATUS'
AND    gl1.code_combination_id(+) = rtt.gl_id_rev
AND    gl2.code_combination_id(+) = rtt.gl_id_freight
AND    gl3.code_combination_id(+) = rtt.gl_id_rec
AND    gl4.code_combination_id(+) = rtt.gl_id_clearing
AND    gl5.code_combination_id(+) = rtt.gl_id_unbilled
AND    gl6.code_combination_id(+) = rtt.gl_id_unearned
AND    gl7.code_combination_id(+) = rtt.gl_id_tax
ORDER BY rtt.name
Parameter Name SQL text Validation
Chart of Accounts Id
 
LOV Oracle