GL Other - Transaction Code Listing

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
Blitz Report™