GL Other - Transaction Code Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: General Ledger
Source: Other - Transaction Code Listing (XML)
Short Name: GLXRLTCL_XML
DB package: GL_GLXRLTCL_XMLP_PKG
Run GL Other - Transaction Code Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select  gltc.ussgl_transaction_code  code,gltc.start_date_active  start_date ,gltc.end_date_active  end_date, glap.dr_account_segment_value  debit_account,
vt1.description,
 glap.cr_account_segment_value  credit_account,
vt2.description
from  gl_ussgl_transaction_codes  gltc,
         gl_ussgl_account_pairs  glap,
          fnd_flex_values v1,
          fnd_flex_values_tl vt1,
         fnd_flex_values v2,
          fnd_flex_values_tl vt2
where  gltc.chart_of_accounts_id  = :STRUCT_NUM
and   gltc.ussgl_transaction_code = nvl(:P_TXN_CODE,gltc.ussgl_transaction_code)
and      glap.chart_of_accounts_id = :STRUCT_NUM
and  glap.ussgl_transaction_code = gltc.ussgl_transaction_code || ''
and  v1.flex_value_set_id = :VALUE_SET_ID
and  v1.flex_value = glap.dr_account_segment_value||''
and  vt1.flex_value_id = v1.flex_value_id +0
and  vt1.language = userenv('LANG')
and  v2.flex_value_set_id =:VALUE_SET_ID
and  v2.flex_value = glap.cr_account_segment_value||''
and  vt2.flex_value_id = v2.flex_value_id +0
and  vt2.language = userenv('LANG')
order by  gltc.ussgl_transaction_code,glap.dr_account_segment_value,
                glap.cr_account_segment_value
Parameter Name SQL text Validation
Ledger 
 
 LOV Oracle
Transaction Code 
 
 LOV Oracle
Download
Related Blitz Reports
JA Third Party Detail Trial Balance with Contra Accounts GL Account Analysis MAD GL Account Analysis (Distributions) Item Material Account Distributions MAD material dist report MAD1 Inventory mad Inventory MAD - Material account dist
Blitz Report™

Blitz Report™ provides multiple benefits: