Query to display Transaction Type Details In Oracle Receivables

SELECT hou.name operating_unit      

      ,xep.name legal_entity

      ,rctta.name      

      ,rctta.description

      ,al.meaning class

      ,al2.meaning creation_sign

      ,al3.meaning transaction_status

      ,al4.meaning printing_option

      ,null invoice_type

      ,rctt2.name credit_memo_type

      ,aars.rule_set_name application_rule_set

      ,aat.payment_term_name terms

      ,rctta.start_date

      ,rctta.end_date      

      ,rctta.accounting_affect_flag open_receivable

      ,rctta.adj_post_to_gl allow_adjustment_posting

      ,rctta.post_to_gl post_to_gl

      ,rctta.allow_freight_flag allow_freight

      ,rctta.natural_application_only_flag natural_application_only

      ,rctta.tax_calculation_flag default_tax_classification

      ,rctta.exclude_from_late_charges exclude_from_late_charges_cal

      ,rctta.allow_overapplication_flag allow_over_application

      ,gcck.concatenated_segments receivable_account

      ,gcck3.concatenated_segments freight_account

      ,gcck2.concatenated_segments revenue_account

      ,gcck4.concatenated_segments clearing_account

      ,gcck5.concatenated_segments unbilled_receivable_account

      ,gcck6.concatenated_segments unearned_revenue_account

      ,gcck7.concatenated_segments tax_account

  FROM ra_cust_trx_types_all rctta

      ,hr_operating_units hou

      ,xle_entity_profiles xep

      ,ar_lookups al

      ,ar_lookups al2

      ,ar_lookups al3

      ,ar_lookups al4

      ,ra_cust_trx_types_all rctta2

      ,ar_app_rule_sets aars

      ,arfv_ar_terms aat

      ,gl_code_combinations_kfv gcck

      ,gl_code_combinations_kfv gcck2

      ,gl_code_combinations_kfv gcck3

      ,gl_code_combinations_kfv gcck4

      ,gl_code_combinations_kfv gcck5

      ,gl_code_combinations_kfv gcck6

      ,gl_code_combinations_kfv gcck7

 WHERE 1=1

   AND rctta.org_id= hou.organization_id

   AND xep.legal_entity_id(+)=rctta.legal_entity_id

   AND al.lookup_type='INV/CM'

   AND al.lookup_code=rctta.type

   AND al2.lookup_type='SIGN'

   AND al2.lookup_code=rctta.creation_sign

   AND al3.lookup_type='INVOICE_TRX_STATUS'

   AND al3.lookup_code=rctta.default_status

   AND al4.lookup_type='INVOICE_PRINT_OPTIONS'

   AND al4.lookup_code=rctta.default_printing_option

   AND rctta.credit_memo_type_id=rctta2.cust_trx_type_id(+)

   AND rctta.org_id=rctta2.org_id(+)

   AND rctta.rule_set_id=aars.rule_set_id(+)

   AND rctta.default_term=aat.term_id(+)

   AND gcck.code_combination_id(+)=rctta.gl_id_rec

   AND gcck2.code_combination_id(+)=rctta.gl_id_rev

   AND gcck3.code_combination_id(+)=rctta.gl_id_freight

   AND gcck4.code_combination_id(+)=rctta.gl_id_clearing

   AND gcck5.code_combination_id(+)=rctta.gl_id_unbilled

   AND gcck6.code_combination_id(+)=rctta.gl_id_unearned

   AND gcck7.code_combination_id(+)=rctta.gl_id_tax

;