ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4ED3869E053B46B63588994Y 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 SQLGL GLXRLTCL_XML AR GL أخرى - قائمة رموز الحركات (بتنسيق XML) Application: الأستاذ العام Source: أخرى - قائمة رموز الحركات (بتنسيق XML) Short Name: GLXRLTCL_XML DB package: GL_GLXRLTCL_XMLP_PKG D GL Sonstiges - Transaktionsschlüssel Application: Rechnungswesen Source: Sonstiges - Transaktionsschlüssel (XML) Short Name: GLXRLTCL_XML DB package: GL_GLXRLTCL_XMLP_PKG F GL Autres - Liste des codes mouvement Application: General Ledger Source: Autres - Liste des codes mouvement (XML) Short Name: GLXRLTCL_XML DB package: GL_GLXRLTCL_XMLP_PKG US GL Other - Transaction Code Listing Application: General Ledger Source: Other - Transaction Code Listing (XML) Short Name: GLXRLTCL_XML DB package: GL_GLXRLTCL_XMLP_PKG ZHS GL 其它 - 事务处理代码列表 Application: 总帐管理系统 Source: 其它 - 事务处理代码列表 (XML) Short Name: GLXRLTCL_XML DB package: GL_GLXRLTCL_XMLP_PKG BI Publisher :p_conc_request_id :p_set_of_books_id :p_txn_code :pageno :set_of_books_name :struct_num :value_set_id 1 10 :p_set_of_books_id LOV Oracle PSA_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id order by l.name Y AR الأستاذ D Buch F Livre US Ledger ZHS 分类账 2 20 :p_txn_code LOV Oracle PSA_SRS_USSGL_TRANSACTION_CODES Y select ussgl_transaction_code id, ussgl_transaction_code value, description description from gl_ussgl_transaction_codes where chart_of_accounts_id=(select chart_of_accounts_id from gl_access_sets_v where access_set_id=fnd_profile.value('GL_ACCESS_SET_ID')) order by ussgl_transaction_code AR رمز الحركة D Transaktionsschlüssel F Code mouvement US Transaction Code ZHS 事务处理代码