ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4703351A9E05362FB09050512 SELECT TABLE1.APPLICATION_ID APPLICATION_ID ,TABLE1.EVENT_CLASS_CODE EVENT_CLASS_CODE ,TABLE1.EVENT_CLASS_NAME EVENT_CLASS_NAME ,TABLE1.EVENT_TYPE_NAME EVENT_TYPE_NAME ,TABLE1.EVENT_ID EVENT_ID ,TABLE1.EVENT_STATUS_CODE EVENT_STATUS_CODE ,TABLE1.EVENT_STATUS EVENT_STATUS ,TABLE1.EVENT_NUMBER EVENT_NUMBER ,TABLE1.EVENT_DATE EVENT_DATE ,TABLE1.ENTITY_ID ENTITY_ID ,TABLE1.LEDGER_ID LEDGER_ID ,TABLE1.LEDGER_NAME LEDGER_NAME ,TABLE1.LEDGER_CURRENCY LEDGER_CURRENCY ,TABLE1.COA_ID COA_ID ,TABLE1.PAD_NAME PAD_NAME ,TABLE1.PAD_VERSION PAD_VERSION ,TABLE1.AE_HEADER_ID AE_HEADER_ID ,TABLE1.BALANCE_TYPE BALANCE_TYPE ,TABLE1.BALANCE_TYPE_MEANING BALANCE_TYPE_MEANING ,TABLE1.GL_DATE GL_DATE ,TABLE1.AE_DESCRIPTION AE_DESCRIPTION ,TABLE1.AE_STATUS_CODE AE_STATUS_CODE ,TABLE1.AE_STATUS_MEANING AE_STATUS_MEANING ,TABLE1.DISPLAYED_LINE_NUM DISPLAYED_LINE_NUM ,TABLE1.AE_LINE_NUM AE_LINE_NUM ,TABLE1.ACCOUNT_CCID ACCOUNT_CCID ,TABLE1.ENTERED_CURRENCY ENTERED_CURRENCY ,TABLE1.ENTERED_DR ENTERED_DR ,TABLE1.ENTERED_CR ENTERED_CR ,TABLE1.ACCOUNTED_DR ACCOUNTED_DR ,TABLE1.ACCOUNTED_CR ACCOUNTED_CR ,TABLE1.ACCOUNTING_CLASS ACCOUNTING_CLASS ,TABLE1.ERROR_AE_LINE_NUM ERROR_AE_LINE_NUM ,TABLE1.MESSAGE_NUMBER MESSAGE_NUMBER ,TABLE1.ENCODED_MSG ENCODED_MSG ,TABLE1.ACCOUNT_SEGMENTS ACCOUNT_SEGMENTS ,substr(USERIDS,1,instr(USERIDS,'|',1,1)-1) USER_TRX_IDENTIFIER_NAME_1 ,substr(USERIDS,instr(USERIDS,'|',1,1)+1,(instr(USERIDS,'|',1,2)-1-instr(USERIDS,'|',1,1))) USER_TRX_IDENTIFIER_VALUE_1 ,substr(USERIDS,instr(USERIDS,'|',1,2)+1,(instr(USERIDS,'|',1,3)-1-instr(USERIDS,'|',1,2))) USER_TRX_IDENTIFIER_NAME_2 ,substr(USERIDS,instr(USERIDS,'|',1,3)+1,(instr(USERIDS,'|',1,4)-1-instr(USERIDS,'|',1,3))) USER_TRX_IDENTIFIER_VALUE_2 ,substr(USERIDS,instr(USERIDS,'|',1,4)+1,(instr(USERIDS,'|',1,5)-1-instr(USERIDS,'|',1,4))) USER_TRX_IDENTIFIER_NAME_3 ,substr(USERIDS,instr(USERIDS,'|',1,5)+1,(instr(USERIDS,'|',1,6)-1-instr(USERIDS,'|',1,5))) USER_TRX_IDENTIFIER_VALUE_3 ,substr(USERIDS,instr(USERIDS,'|',1,6)+1,(instr(USERIDS,'|',1,7)-1-instr(USERIDS,'|',1,6))) USER_TRX_IDENTIFIER_NAME_4 ,substr(USERIDS,instr(USERIDS,'|',1,7)+1,(instr(USERIDS,'|',1,8)-1-instr(USERIDS,'|',1,7))) USER_TRX_IDENTIFIER_VALUE_4 ,substr(USERIDS,instr(USERIDS,'|',1,8)+1,(instr(USERIDS,'|',1,9)-1-instr(USERIDS,'|',1,8))) USER_TRX_IDENTIFIER_NAME_5 ,substr(USERIDS,instr(USERIDS,'|',1,9)+1,(instr(USERIDS,'|',1,10)-1-instr(USERIDS,'|',1,9))) USER_TRX_IDENTIFIER_VALUE_5 ,substr(USERIDS,instr(USERIDS,'|',1,10)+1,(instr(USERIDS,'|',1,11)-1-instr(USERIDS,'|',1,10))) USER_TRX_IDENTIFIER_NAME_6 ,substr(USERIDS,instr(USERIDS,'|',1,11)+1,(instr(USERIDS,'|',1,12)-1-instr(USERIDS,'|',1,11))) USER_TRX_IDENTIFIER_VALUE_6 ,substr(USERIDS,instr(USERIDS,'|',1,12)+1,(instr(USERIDS,'|',1,13)-1-instr(USERIDS,'|',1,12))) USER_TRX_IDENTIFIER_NAME_7 ,substr(USERIDS,instr(USERIDS,'|',1,13)+1,(instr(USERIDS,'|',1,14)-1-instr(USERIDS,'|',1,13))) USER_TRX_IDENTIFIER_VALUE_7 ,substr(USERIDS,instr(USERIDS,'|',1,14)+1,(instr(USERIDS,'|',1,15)-1-instr(USERIDS,'|',1,14))) USER_TRX_IDENTIFIER_NAME_8 ,substr(USERIDS,instr(USERIDS,'|',1,15)+1,(instr(USERIDS,'|',1,16)-1-instr(USERIDS,'|',1,15))) USER_TRX_IDENTIFIER_VALUE_8 ,substr(USERIDS,instr(USERIDS,'|',1,16)+1,(instr(USERIDS,'|',1,17)-1-instr(USERIDS,'|',1,16))) USER_TRX_IDENTIFIER_NAME_9 ,substr(USERIDS,instr(USERIDS,'|',1,17)+1,(instr(USERIDS,'|',1,18)-1-instr(USERIDS,'|',1,17))) USER_TRX_IDENTIFIER_VALUE_9 ,substr(USERIDS,instr(USERIDS,'|',1,18)+1,(instr(USERIDS,'|',1,19)-1-instr(USERIDS,'|',1,18))) USER_TRX_IDENTIFIER_NAME_10 ,substr(USERIDS,instr(USERIDS,'|',1,19)+1,(length(USERIDS)-instr(USERIDS,'|',1,19))) USER_TRX_IDENTIFIER_VALUE_10 FROM ( SELECT EVT.APPLICATION_ID APPLICATION_ID ,XET.EVENT_CLASS_CODE EVENT_CLASS_CODE ,XEC.NAME EVENT_CLASS_NAME ,XET.NAME EVENT_TYPE_NAME ,EVT.EVENT_ID EVENT_ID ,EVT.PROCESS_STATUS_CODE EVENT_STATUS_CODE ,XL3.MEANING EVENT_STATUS ,EVT.EVENT_NUMBER EVENT_NUMBER ,TO_CHAR(EVT.EVENT_DATE,'YYYY-MM-DD') EVENT_DATE ,EVT.ENTITY_ID ENTITY_ID ,XGL.LEDGER_ID LEDGER_ID ,XGL.NAME LEDGER_NAME ,XGL.CURRENCY_CODE LEDGER_CURRENCY ,XGL.CHART_OF_ACCOUNTS_ID COA_ID ,XPR.NAME PAD_NAME ,XPR.PRODUCT_RULE_VERSION PAD_VERSION ,AEH.AE_HEADER_ID AE_HEADER_ID ,AEH.BALANCE_TYPE_CODE BALANCE_TYPE ,XLK.MEANING BALANCE_TYPE_MEANING ,TO_CHAR(AEH.ACCOUNTING_DATE ,'YYYY-MM-DD') GL_DATE ,AEH.DESCRIPTION AE_DESCRIPTION ,AEH.ACCOUNTING_ENTRY_STATUS_CODE AE_STATUS_CODE ,XL1.MEANING AE_STATUS_MEANING ,AEL.DISPLAYED_LINE_NUMBER DISPLAYED_LINE_NUM ,AEL.AE_LINE_NUM AE_LINE_NUM ,AEL.CODE_COMBINATION_ID ACCOUNT_CCID ,AEL.CURRENCY_CODE ENTERED_CURRENCY ,AEL.ENTERED_DR ENTERED_DR ,AEL.ENTERED_CR ENTERED_CR ,AEL.ACCOUNTED_DR ACCOUNTED_DR ,AEL.ACCOUNTED_CR ACCOUNTED_CR ,XL2.MEANING ACCOUNTING_CLASS ,NULL ERROR_AE_LINE_NUM ,NULL MESSAGE_NUMBER ,NULL ENCODED_MSG ,FND_FLEX_EXT.GET_SEGS ('SQLGL' ,'GL#' ,XGL.CHART_OF_ACCOUNTS_ID ,AEL.CODE_COMBINATION_ID) ACCOUNT_SEGMENTS &P_TRX_IDENTIFIERS_1 &P_TRX_IDENTIFIERS_2 &P_TRX_IDENTIFIERS_3 &P_TRX_IDENTIFIERS_4 &P_TRX_IDENTIFIERS_5 FROM XLA_EVENTS EVT ,XLA_TRANSACTION_ENTITIES ENT ,XLA_EVENT_TYPES_VL XET ,XLA_EVENT_CLASSES_TL XEC ,XLA_AE_HEADERS AEH ,XLA_AE_LINES AEL ,XLA_GL_LEDGERS_V XGL ,XLA_PRODUCT_RULES_VL XPR ,XLA_LOOKUPS XLK ,XLA_LOOKUPS XL1 ,XLA_LOOKUPS XL2 ,XLA_LOOKUPS XL3 WHERE EVT.APPLICATION_ID = :APPLICATION_ID AND EVT.REQUEST_ID = :REQUEST_ID AND ENT.APPLICATION_ID = EVT.APPLICATION_ID AND ENT.ENTITY_ID = EVT.ENTITY_ID AND XET.APPLICATION_ID = ENT.APPLICATION_ID AND XET.ENTITY_CODE = ENT.ENTITY_CODE AND XET.EVENT_TYPE_CODE = EVT.EVENT_TYPE_CODE AND XEC.APPLICATION_ID = XET.APPLICATION_ID AND XEC.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE AND XEC.LANGUAGE = USERENV('LANG') AND AEH.APPLICATION_ID = EVT.APPLICATION_ID AND AEH.EVENT_ID = EVT.EVENT_ID AND AEH.ACCOUNTING_ENTRY_STATUS_CODE <> 'N' AND AEL.APPLICATION_ID = AEH.APPLICATION_ID AND AEL.AE_HEADER_ID = AEH.AE_HEADER_ID AND XGL.LEDGER_ID = AEH.LEDGER_ID AND XPR.APPLICATION_ID = AEH.APPLICATION_ID AND XPR.PRODUCT_RULE_TYPE_CODE = AEH.PRODUCT_RULE_TYPE_CODE AND XPR.PRODUCT_RULE_CODE = AEH.PRODUCT_RULE_CODE AND XPR.AMB_CONTEXT_CODE = AEH.AMB_CONTEXT_CODE AND XLK.LOOKUP_TYPE = 'XLA_BALANCE_TYPE' AND XLK.LOOKUP_CODE = AEH.BALANCE_TYPE_CODE AND XL1.LOOKUP_TYPE = 'XLA_ACCOUNTING_ENTRY_STATUS' AND XL1.LOOKUP_CODE = AEH.ACCOUNTING_ENTRY_STATUS_CODE AND XL2.LOOKUP_TYPE = 'XLA_ACCOUNTING_CLASS' AND XL2.LOOKUP_CODE = AEL.ACCOUNTING_CLASS_CODE AND XL3.LOOKUP_TYPE = 'XLA_EVENT_PROCESS_STATUS' AND XL3.LOOKUP_CODE = EVT.PROCESS_STATUS_CODE &P_EVENT_FILTER &P_ZERO_AMT_FILTER AND :P_REPORT_STYLE <> 'N' UNION SELECT EVT.APPLICATION_ID APPLICATION_ID ,XET.EVENT_CLASS_CODE EVENT_CLASS_CODE ,XEC.NAME EVENT_CLASS_NAME ,XET.NAME EVENT_TYPE_NAME ,EVT.EVENT_ID EVENT_ID ,EVT.PROCESS_STATUS_CODE EVENT_STATUS_CODE ,XLK.MEANING EVENT_STATUS ,EVT.EVENT_NUMBER EVENT_NUMBER ,TO_CHAR(EVT.EVENT_DATE,'YYYY-MM-DD') EVENT_DATE ,EVT.ENTITY_ID ENTITY_ID ,XGL.LEDGER_ID LEDGER_ID ,XGL.NAME LEDGER_NAME ,XGL.CURRENCY_CODE LEDGER_CURRENCY ,XGL.CHART_OF_ACCOUNTS_ID COA_ID ,NULL PAD_NAME ,NULL PAD_VERSION ,ERR.AE_HEADER_ID AE_HEADER_ID ,NULL BALANCE_TYPE ,NULL BALANCE_TYPE_MEANING ,NULL GL_DATE ,NULL AE_DESCRIPTION ,NULL AE_STATUS_CODE ,NULL AE_STATUS_MEANING ,ERR.AE_LINE_NUM DISPLAYED_LINE_NUM ,ERR.AE_LINE_NUM AE_LINE_NUM ,NULL ACCOUNT_CCID ,NULL ENTERED_CURRENCY ,NULL ENTERED_DR ,NULL ENTERED_CR ,NULL ACCOUNTED_DR ,NULL ACCOUNTED_CR ,NULL ACCOUNTING_CLASS ,ERR.AE_LINE_NUM ERROR_AE_LINE_NUM ,ERR.MESSAGE_NUMBER MESSAGE_NUMBER ,ERR.ENCODED_MSG ENCODED_MSG ,NULL ACCOUNT_SEGMENTS &P_TRX_IDENTIFIERS_1 &P_TRX_IDENTIFIERS_2 &P_TRX_IDENTIFIERS_3 &P_TRX_IDENTIFIERS_4 &P_TRX_IDENTIFIERS_5 FROM XLA_EVENTS EVT ,XLA_TRANSACTION_ENTITIES ENT ,XLA_EVENT_TYPES_VL XET ,XLA_EVENT_CLASSES_TL XEC ,XLA_ACCOUNTING_ERRORS ERR ,XLA_GL_LEDGERS_V XGL ,XLA_LOOKUPS XLK WHERE EVT.APPLICATION_ID = :APPLICATION_ID AND EVT.REQUEST_ID = :REQUEST_ID AND EVT.PROCESS_STATUS_CODE IN ('I','E','R') AND XLK.LOOKUP_TYPE = 'XLA_EVENT_PROCESS_STATUS' AND XLK.LOOKUP_CODE = EVT.PROCESS_STATUS_CODE AND ENT.APPLICATION_ID = EVT.APPLICATION_ID AND ENT.ENTITY_ID = EVT.ENTITY_ID AND XET.APPLICATION_ID = ENT.APPLICATION_ID AND XET.ENTITY_CODE = ENT.ENTITY_CODE AND XET.EVENT_TYPE_CODE = EVT.EVENT_TYPE_CODE AND XEC.APPLICATION_ID = XET.APPLICATION_ID AND XEC.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE AND XEC.LANGUAGE = USERENV('LANG') AND ERR.EVENT_ID = EVT.EVENT_ID AND XGL.LEDGER_ID(+) = ERR.LEDGER_ID AND :P_REPORT_STYLE <> 'N' )TABLE1 Y JA JAARAPAC Y JA JA アジア/太平洋ARおよびAP向け会計の作成 Imported from BI Publisher Application: Asia/Pacific Localizations Source: アジア/太平洋ARおよびAP向け会計の作成 Short Name: JAARAPAC DB package: XLA_CREATE_ACCT_RPT_PVT KO JA 아시아/태평양 AR 및 AP용 회계 생성 Imported from BI Publisher Application: Asia/Pacific Localizations Source: 아시아/태평양 AR 및 AP용 회계 생성 Short Name: JAARAPAC DB package: XLA_CREATE_ACCT_RPT_PVT US JA Create Accounting for Asia/Pacific AR and AP Imported from BI Publisher Application: Asia/Pacific Localizations Source: Create Accounting for Asia/Pacific AR and AP Short Name: JAARAPAC DB package: XLA_CREATE_ACCT_RPT_PVT ZHS JA 创建亚太地区 AR 和 AP 的会计科目 Imported from BI Publisher Application: 亚太地区本地化 Source: 创建亚太地区 AR 和 AP 的会计科目 Short Name: JAARAPAC DB package: XLA_CREATE_ACCT_RPT_PVT BI Publisher &p_event_filter &p_trx_identifiers_1 &p_trx_identifiers_2 &p_trx_identifiers_3 &p_trx_identifiers_4 &p_trx_identifiers_5 &p_zero_amt_filter :application_id :c_acct_prog_return_code :g_launch_balance_program :p_accounting_mode :p_accounting_mode_name :p_accounting_report_level :p_application_id :p_application_name :p_application_query :p_conc_request_id :p_create_accounting :p_create_accounting_flag :p_dummy :p_dummy_param_1 :p_dummy_param_2 :p_dummy_param_3 :p_end_date :p_entity_id :p_errors_only :p_errors_only_flag :p_event_filter :p_gl_batch_name :p_group_id_str :p_include_user_trx_id_flag :p_include_user_trx_identifiers :p_include_zero_amount_lines :p_include_zero_amt_lines :p_launch_bal_program :p_launch_balance_program :p_ledger_id :p_ledger_name :p_min_precision :p_post_in_gl :p_post_in_gl_flag :p_process_category_code :p_process_category_name :p_report_style :p_req_id :p_request_id :p_security_char_1 :p_security_char_2 :p_security_char_3 :p_security_int_1 :p_security_int_2 :p_security_int_3 :p_source_application_id :p_source_application_name :p_transfer_to_gl :p_transfer_to_gl_flag :p_trx_identifiers :p_trx_identifiers_1 :p_trx_identifiers_2 :p_trx_identifiers_3 :p_trx_identifiers_4 :p_trx_identifiers_5 :p_user_id :p_valuation_method_code :p_zero_amt_filter :request_id 1 -210 :p_source_application_id LOV Oracle XLA_SRS_SOURCE_APPLICATION Y select application_id id, application_name value, null description from fnd_application_vl fvl order by value,description SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) JA ソース・アプリケーション ソース・アプリケーションID KO 출처 애플리케이션 출처 애플리케이션 ID US Source Application Source Application Id ZHS 来源应用产品 来源应用产品标识 2 -200 :p_application_id LOV Oracle XLA_SRS_SUBLEDGERS Y select application_id id, application_name value, null description from (select application_name,application_id from xla_subledgers_fvl union select application_name,application_id from fnd_application_vl where application_id=101) order by value,description SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) JA アプリケーション アプリケーションID KO 애플리케이션 애플리케이션 ID US Application Application ID ZHS 应用产品 应用产品标识 3 -190 :p_dummy Char SELECT 'Y' FROM DUAL WHERE :$flex$.source_application:NULL IS NOT NULL OR :$flex$.application:NULL IS NOT NULL US XLA_SRS_NO_VALIDATION 4 40 :p_dummy_param_1 Char SELECT 'Y' FROM DUAL WHERE :$flex$.create_accounting = 'Y' US XLA_SRS_NO_VALIDATION 5 -160 :p_dummy_param_3 Char SELECT 'Y' FROM DUAL WHERE :$flex$.transfer_to_general_ledger = 'Y' US XLA_SRS_NO_VALIDATION 6 -180 :p_create_accounting_flag LOV Oracle XLA_SRS_CREATE_ACCOUNTING_FLAG Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'Y' JA 会計の作成 会計の作成フラグ KO 회계 생성 회계 생성 플래그 US Create Accounting Create Accounting Flag ZHS 创建会计科目 创建会计科目标志 7 -170 :p_dummy_param_2 Char SELECT 'Y' FROM DUAL WHERE NVL(:$flex$.:NULL,'F') = 'F' US XLA_SRS_ACCOUNTING_MODE_DUMMY 8 -150 :p_min_precision Number fnd_profile.value('CURRENCY:MIXED_PRECISION') JA 混合通貨精度 KO 혼합 통화 소수점 이하 자리수 US Mixed Currency Precision ZHS 混合币种精确度 9 -140 :p_include_zero_amount_lines LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'N' JA ゼロ金額明細を含むフラグ ゼロ金額明細を含むフラグ KO 0 금액 라인 포함 플래그 0 금액 라인 포함 플래그 US Include Zero Amt lines Flag Include Zero Amt lines Flag ZHS 包括金额为零的行标志 包括金额为零的行标志 10 -130 :p_source_application_name Char SELECT :$flex$.source_application.VALUE FROM DUAL JA ソース・アプリケーション名 ソース・アプリケーション名 KO 출처 애플리케이션명 출처 애플리케이션명 US Source Application Name Source Application Name ZHS 来源应用产品名 来源应用产品名 11 -120 :p_application_name Char SELECT :$flex$.application.VALUE FROM DUAL JA アプリケーション名 アプリケーション名 KO 애플리케이션명 애플리케이션명 US Application Name Application Name ZHS 应用产品名 应用产品名 12 -110 :p_ledger_name Char SELECT :$flex$.ledger.VALUE FROM DUAL JA 元帳名 元帳名 KO 원장명 원장명 US Ledger Name Ledger Name ZHS 分类帐名称 分类帐名称 13 -100 :p_process_category_name Char SELECT :$flex$.process_category.VALUE FROM DUAL JA プロセス・カテゴリ名 プロセス・カテゴリ名 KO 프로세스 범주명 프로세스 범주명 US Process Category Name Process Category Name ZHS 流程类别名称 流程类别名称 14 -90 :p_create_accounting Char SELECT :$flex$.create_accounting.VALUE FROM DUAL JA 会計の作成 2 会計の作成 KO 회계 생성 2 회계 생성 US Create Accounting 2 Create Accounting ZHS 创建会计科目 2 创建会计科目 15 -80 :p_accounting_mode_name Char SELECT :$flex$.accounting_mode.VALUE FROM DUAL JA 会計モード名 会計モード名 KO 회계 모드명 회계 모드명 US Accounting Mode Name Accounting Mode Name ZHS 会计模式名称 会计模式名称 16 -70 :p_errors_only Char SELECT :$flex$.errors_only.VALUE FROM DUAL JA エラーのみ 2 エラーのみ KO 오류만 2 오류만 US Errors Only 2 Errors Only ZHS 仅显示错误 2 仅显示错误 17 -60 :p_accounting_report_level Char SELECT :$flex$.report.VALUE FROM DUAL JA レポート・レベル レポート・レベル KO 보고서 레벨 보고서 레벨 US Report Level Report Level ZHS 报表层 报表层 18 -50 :p_transfer_to_gl Char SELECT :$flex$.transfer_to_general_ledger.VALUE FROM DUAL JA GLへの転送 GLへの転送 KO GL로 이전 GL로 이전 US Transfer to GL Transfer to GL ZHS 传送至 GL 传送至 GL 19 -40 :p_post_in_gl Char SELECT :$flex$.post_in_general_ledger.VALUE FROM DUAL JA GLでの転記 GLでの転記 KO GL에 전기 GL에 전기 US Post in GL Post in GL ZHS 在 GL 中过帐 在 GL 中过帐 20 -30 :p_include_zero_amt_lines Char SELECT :$flex$.include_zero_amt_lines_flag.VALUE FROM DUAL JA ゼロ金額明細を含む ゼロ金額明細を含む KO 0 금액 라인 포함 0 금액 라인 포함 US Include Zero Amount Lines Include Zero Amount Lines ZHS 包括金额为零的行 包括金额为零的行 21 -20 :p_include_user_trx_identifiers Char SELECT :$flex$.include_user_transaction_identifiers.VALUE FROM DUAL JA P_INCLUDE_USER_TRX_IDENTIFIERS 「ユーザー取引識別子を含む」フラグの変換済値 KO P_INCLUDE_USER_TRX_IDENTIFIERS [사용자 거래 식별자 포함] 플래그의 변환 값 US P_INCLUDE_USER_TRX_IDENTIFIERS Translated value for 'Include User Transaction Identifiers' flag ZHS P_INCLUDE_USER_TRX_IDENTIFIERS “包括用户事务处理标识”标志的转换值 22 -10 :debugflag Char SELECT DECODE ( FND_PROFILE.VALUE('AFLOG_ENABLED') || FND_PROFILE.VALUE('AFLOG_LEVEL') , 'Y1', 'Y', 'N' ) FROM DUAL JA デバッグ・ログ使用可 デバッグ・ログを使用可能にするフラグ KO 디버그 로그 사용가능 디버그 로그 사용가능 플래그 US Enable Debug Log Flag to enable Debug log ZHS 启用调试日志 启用调试日志的标志 23 10 :p_ledger_id LOV Oracle XLA_SRS_SUBLEDGER_LEDGERS_JL Y select xso.ledger_id id, xso.name value, null description from xla_subledger_options_v xso where xso.application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and :$flex$.xla_srs_no_validation='Y' and xso.capture_event_flag='Y' and xso.enabled_flag='Y' and xso.sla_accounting_method_code is not null and ( (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N') or ( nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='Y' and exists (select 1 from gl_access_sets gas, gl_access_set_assignments asa where gas.access_set_id=asa.access_set_id and gas.chart_of_accounts_id=xso.chart_of_accounts_id and asa.ledger_id=xso.ledger_id and ( gas.access_set_id=nvl(fnd_profile.value('GL_ACCESS_SET_ID'),'-1') or gas.access_set_id=nvl(fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID'),'-1') ) ) ) ) order by value,description Y JA 元帳 元帳ID KO 원장 원장 ID US Ledger Ledger ID ZHS 分类帐 分类帐标识 24 20 :p_process_category_code LOV Oracle XLA_SRS_PROCESS_CATEGORY_JL Y select event_class_group_code id, name value, null description from xla_event_class_grps_vl where application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and name<>'All' order by value,description JA プロセス・カテゴリ プロセス・カテゴリ・コード KO 프로세스 범주 프로세스 범주 코드 US Process Category Process Category Code ZHS 流程类别 流程类别代码 25 30 :p_end_date Date Y JA 終了日 終了日 KO 종료 일자 종료 일자 US End Date End Date ZHS 终止日期 终止日期 26 50 :p_accounting_mode LOV Oracle XLA_SRS_ACCOUNTING_MODE_JL Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk,xla_subledger_options_v xso where xlk.lookup_type='XLA_ACCOUNTING_ENTRY_STATUS' and xlk.lookup_code in ('D','F') and :$flex$.xla_srs_no_validation='Y' and xso.ledger_id=:$flex$.xla_srs_subledger_ledgers_jl and xso.application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and decode(xso.accounting_mode_override_flag,'Y', xlk.lookup_code,xso.accounting_mode_code) =xlk.lookup_code order by value,description SELECT MEANING FROM XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE XLK.LOOKUP_TYPE = 'XLA_ACCOUNTING_ENTRY_STATUS' AND XLK.LOOKUP_CODE = XSO.ACCOUNTING_MODE_CODE AND XSO.APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) AND XSO.LEDGER_ID = :$flex$.ledger Y JA 会計モード 会計モード KO 회계 모드 회계 모드 US Accounting Mode Accounting Mode ZHS 会计模式 会计模式 27 60 :p_errors_only_flag LOV Oracle XLA_SRS_YES_NO_DEPENDENT Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' and :$flex$.xla_srs_no_validation='Y' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'N' Y JA エラーのみ エラーのみフラグ KO 오류만 오류만 플래그 US Errors Only Errors Only Flag ZHS 仅显示错误 “仅显示错误”标志 28 70 :p_report_style LOV Oracle XLA_SRS_REPORT_MODE_JL Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk,xla_subledger_options_v xso where xlk.lookup_type='XLA_ACCT_TRANSFER_MODE' and :$flex$.xla_srs_no_validation='Y' and xso.ledger_id=:$flex$.xla_srs_subledger_ledgers_jl and xso.application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and decode(xso.summary_report_override_flag,'Y', xlk.lookup_code,xso.summary_report_flag) =xlk.lookup_code order by value,description SELECT MEANING FROM XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE XLK.LOOKUP_TYPE = 'XLA_ACCT_TRANSFER_MODE' AND XLK.LOOKUP_CODE = XSO.SUMMARY_REPORT_FLAG AND XSO.APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) AND XSO.LEDGER_ID = :$flex$.ledger Y JA レポート レポート KO 보고서 보고서 US Report Report ZHS 报表 报表 29 80 :p_transfer_to_gl_flag LOV Oracle XLA_SRS_SUBMIT_TRANSFER_FLAG_JL Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk,xla_subledger_options_v xso where xlk.lookup_type='XLA_YES_NO' and :$flex$.xla_srs_accounting_mode_dummy='Y' and xso.ledger_id=:$flex$.xla_srs_subledger_ledgers_jl and xso.application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and decode(xso.submit_transfer_override_flag,'Y', xlk.lookup_code,xso.submit_transfer_to_gl_flag) =xlk.lookup_code order by value,description SELECT MEANING FROM XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE XLK.LOOKUP_TYPE = 'XLA_YES_NO' AND XLK.LOOKUP_CODE = XSO.SUBMIT_TRANSFER_TO_GL_FLAG AND XSO.APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) AND XSO.LEDGER_ID = :$flex$.ledger Y JA 一般会計への転送 GLへの転送フラグ KO 총계정원장으로 이전 GL로 이전 플래그 US Transfer to General Ledger Transfer to GL Flag ZHS 传送至 Oracle General Ledger 传送至 GL 标志 30 90 :p_post_in_gl_flag LOV Oracle XLA_SRS_SUBMIT_GLPOST_FLAG_JL Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk,xla_subledger_options_v xso where xlk.lookup_type='XLA_YES_NO' and :$flex$.xla_srs_no_validation='Y' and xso.ledger_id=:$flex$.xla_srs_subledger_ledgers_jl and xso.application_id=(select data_group_application_id from fnd_responsibility where responsibility_id=fnd_global.resp_id) and decode(xso.submit_gl_post_override_flag,'Y', xlk.lookup_code,xso.submit_gl_post_flag) =xlk.lookup_code order by value,description SELECT MEANING FROM XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE XLK.LOOKUP_TYPE = 'XLA_YES_NO' AND XLK.LOOKUP_CODE = XSO.SUBMIT_GL_POST_FLAG AND XSO.APPLICATION_ID = (SELECT DATA_GROUP_APPLICATION_ID FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')) AND XSO.LEDGER_ID = :$flex$.ledger Y JA 一般会計における転記 GLへの転記フラグ KO 총계정원장에 전기 GL에 전기 플래그 US Post in General Ledger Post to GL Flag ZHS 在 Oracle General Ledger 中过帐 过帐至 GL 标志 31 100 :p_gl_batch_name Char JA 一般会計バッチ名 KO 총계정원장 뱃치명 US General Ledger Batch Name ZHS 总帐批名 32 110 :p_include_user_trx_id_flag LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type ='XLA_YES_NO' and lookup_code ='N' Y JA ユーザー取引識別子を含む ユーザー取引識別子を含むフラグ KO 사용자 거래 식별자 포함 사용자 거래 식별자 포함 플래그 US Include User Transaction Identifiers Include User Transaction Identifiers flag ZHS 包括用户事务处理标识 “包括用户事务处理标识”标志 :$flex$.accounting_mode.VALUE Accounting Mode Accounting Mode Name value :$flex$.application.VALUE Application Application Name value :$flex$.create_accounting Create Accounting XLA_SRS_NO_VALIDATION :$flex$.create_accounting.VALUE Create Accounting Create Accounting 2 value :$flex$.errors_only.VALUE Errors Only Errors Only 2 value :$flex$.include_user_transaction_identifiers.VALUE Include User Transaction Identifiers P_INCLUDE_USER_TRX_IDENTIFIERS value :$flex$.include_zero_amt_lines_flag.VALUE Include Zero Amt lines Flag Include Zero Amount Lines value :$flex$.ledger Ledger Accounting Mode :$flex$.ledger Ledger Post in General Ledger :$flex$.ledger Ledger Report :$flex$.ledger Ledger Transfer to General Ledger :$flex$.ledger.VALUE Ledger Ledger Name value :$flex$.post_in_general_ledger.VALUE Post in General Ledger Post in GL value :$flex$.process_category.VALUE Process Category Process Category Name value :$flex$.report.VALUE Report Report Level value :$flex$.source_application.VALUE Source Application Source Application Name value :$flex$.transfer_to_general_ledger Transfer to General Ledger XLA_SRS_NO_VALIDATION :$flex$.transfer_to_general_ledger.VALUE Transfer to General Ledger Transfer to GL value :$flex$.xla_srs_accounting_mode_dummy XLA_SRS_ACCOUNTING_MODE_DUMMY Transfer to General Ledger :$flex$.xla_srs_no_validation XLA_SRS_NO_VALIDATION Accounting Mode :$flex$.xla_srs_no_validation XLA_SRS_NO_VALIDATION Errors Only :$flex$.xla_srs_no_validation XLA_SRS_NO_VALIDATION Ledger :$flex$.xla_srs_no_validation XLA_SRS_NO_VALIDATION Post in General Ledger :$flex$.xla_srs_no_validation XLA_SRS_NO_VALIDATION Report :$flex$.xla_srs_subledger_ledgers_jl Ledger Accounting Mode :$flex$.xla_srs_subledger_ledgers_jl Ledger Post in General Ledger :$flex$.xla_srs_subledger_ledgers_jl Ledger Report :$flex$.xla_srs_subledger_ledgers_jl Ledger Transfer to General Ledger