SQL Query related to Receivables Transaction Class and Transaction Type

There is no provision to disable Invoice Class on AR Transaction window.
These value are hard coded for the list of values and are not derived from Look ups.
So, users will not be able to add or disable the existing values.

SQL Query related to R12  Receivables Transaction Class and Transaction Type:

---- AR Transaction Class------

select c.TRX_NUMBER, a.name,  b.MEANING "CLASS" 

from RA_CUST_TRX_TYPES_ALL a, FND_LOOKUP_VALUES_VL b, RA_CUSTOMER_TRX_ALL c

where

a.CUST_TRX_TYPE_ID=c.CUST_TRX_TYPE_ID

and b.LOOKUP_TYPE = 'INV/CM'

and a.type=b.lookup_code

--and c.TRX_NUMBER in (‘XXXXXXXX’)

order by c.TRX_NUMBER;

-------- Transaction Types-----------

SELECT hou.name operating_unit
      ,xep.name legal_entity
      ,rctt.name    
      ,rctt.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
      ,rctt.start_date
      ,rctt.end_date    
      ,rctt.accounting_affect_flag open_receivable
      ,rctt.adj_post_to_gl allow_adjustment_posting
      ,rctt.post_to_gl post_to_gl
      ,rctt.allow_freight_flag allow_freight
      ,rctt.natural_application_only_flag natural_application_only
      ,rctt.tax_calculation_flag default_tax_classification
      ,rctt.exclude_from_late_charges exclude_from_late_charges_cal
      ,rctt.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 rctt
      ,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 rctt2
      ,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 rctt.org_id= hou.organization_id
   AND rctt.name=nvl(:P_TYPE,rctt.name)
   AND hou.organization_id=nvl(:P_ORG_ID, hou.organization_id)
   AND xep.legal_entity_id(+)=rctt.legal_entity_id
   AND al.lookup_type='INV/CM'
   AND al.lookup_code=rctt.TYPE
   AND al2.lookup_type='SIGN'
   AND al2.lookup_code=rctt.creation_sign
   AND al3.lookup_type='INVOICE_TRX_STATUS'
   AND al3.lookup_code=rctt.default_status
   AND al4.lookup_type='INVOICE_PRINT_OPTIONS'
   AND al4.lookup_code=rctt.default_printing_option
   AND rctt.credit_memo_type_id=rctt2.cust_trx_type_id(+)
   AND rctt.org_id=rctt2.org_id(+)
   AND rctt.rule_set_id=aars.rule_set_id(+)
   AND rctt.default_term=aat.term_id(+)
   AND gcck.code_combination_id(+)=rctt.gl_id_rec
   AND gcck2.code_combination_id(+)=rctt.gl_id_rev
   AND gcck3.code_combination_id(+)=rctt.gl_id_freight
   AND gcck4.code_combination_id(+)=rctt.gl_id_clearing
   AND gcck5.code_combination_id(+)=rctt.gl_id_unbilled
   AND gcck6.code_combination_id(+)=rctt.gl_id_unearned
   AND gcck7.code_combination_id(+)=rctt.gl_id_tax;