AR Transaction Types Listing
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Print a listing of the Transaction Types
Application: Receivables
Source: Transaction Types Listing (XML)
Short Name: RAXTTL_XML
DB package: AR_RAXTTL_XMLP_PKG
Description: Print a listing of the Transaction Types
Application: Receivables
Source: Transaction Types Listing (XML)
Short Name: RAXTTL_XML
DB package: AR_RAXTTL_XMLP_PKG
Run
AR Transaction Types Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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 | |
---|---|---|---|
Operating Unit |
|
LOV |