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
SQL 25 lines
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 |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger | LOV Oracle | |
| Transaction Code | LOV Oracle |