ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4703451A9E05362FB09050512 SELECT AEH.LEDGER_ID LEDGER_ID , GLL.NAME LEDGER_NAME -- the following two columns are intentionally kept null as there is a -- possibility that the following query will not perform and then -- we will have to rely on this information coming from transfer package -- In that case we will not be able to provide this information. -- If this query performs okay, the two null columns can be replaced by -- actual values. , NULL BALANCE_TYPE_CODE , NULL BALANCE_TYPE , COUNT(DECODE(AEH.GL_TRANSFER_STATUS_CODE,'Y',1,NULL)) JE_TRANSFERRED_COUNT , COUNT(DECODE(AEH.GL_TRANSFER_STATUS_CODE,'Y',NULL,1)) JE_NOT_TRANSFERRED_COUNT FROM XLA_AE_HEADERS AEH , GL_LEDGERS GLL --, XLA_LOOKUPS XLK WHERE AEH.APPLICATION_ID = :APPLICATION_ID AND AEH.REQUEST_ID = &P_REQ_ID AND GLL.LEDGER_ID = AEH.LEDGER_ID AND AEH.GROUP_ID IN (&P_GROUP_ID_STR) --AND XLK.LOOKUP_TYPE = 'XLA_BALANCE_TYPE' --AND XLK.LOOKUP_CODE = AEH.BALANCE_TYPE_CODE GROUP BY AEH.LEDGER_ID ,GLL.NAME --,AEH.BALANCE_TYPE_CODE --,XLK.MEANING Y JA JAARAPTR JA JA アジア/太平洋ARおよびAP向けGLへの仕訳転送 Imported from BI Publisher Description: このプログラムを使用して、 アジア/太平洋ARおよびAP向けの会計の作成プログラムを以前実行したときに生成されたGL補助元帳仕訳に転送します Application: Asia/Pacific Localizations Source: アジア/太平洋ARおよびAP向けGLへの仕訳転送 Short Name: JAARAPTR DB package: XLA_CREATE_ACCT_RPT_PVT KO JA 아시아/태평양 AR 및 AP에 대해 GL로 분개 입력 이전 Imported from BI Publisher Description: 이 프로그램을 사용하여 아시아/태평양 AR 및 AP용 회계 생성 프로그램의 이전 실행에서 생성된 보조원장 분개를 GL로 이전합니다. Application: Asia/Pacific Localizations Source: 아시아/태평양 AR 및 AP에 대해 GL로 분개 입력 이전 Short Name: JAARAPTR DB package: XLA_CREATE_ACCT_RPT_PVT US JA Transfer Journal Entries to GL for Asia/Pacific AR and AP Imported from BI Publisher Description: Use this program to transfer to GL subledger journal entries generated by previous executions of the create accounting program for Asia/Pacific AR and AP Application: Asia/Pacific Localizations Source: Transfer Journal Entries to GL for Asia/Pacific AR and AP Short Name: JAARAPTR DB package: XLA_CREATE_ACCT_RPT_PVT ZHS JA 将亚太地区 AR 和 AP 的日记帐分录传送至 GL Imported from BI Publisher Description: 使用此程序可以将以前执行“创建亚太地区 AR 和 AP 的会计科目”程序所生成的子分类账日记账分录传送至 GL Application: 亚太地区本地化 Source: 将亚太地区 AR 和 AP 的日记帐分录传送至 GL Short Name: JAARAPTR DB package: XLA_CREATE_ACCT_RPT_PVT BI Publisher &p_group_id_str &p_req_id :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 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 -170 :p_dummy_param_1 Char SELECT 'Y' FROM DUAL WHERE :$flex$.create_accounting = 'Y' US XLA_SRS_NO_VALIDATION 5 -130 :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 = 'N' JA 会計の作成 会計の作成フラグ KO 회계 생성 회계 생성 플래그 US Create Accounting Create Accounting Flag ZHS 创建会计科目 创建会计科目标志 7 -160 :p_dummy_param_2 Char SELECT 'Y' FROM DUAL WHERE NVL(:$flex$.:NULL,'F') = 'F' US XLA_SRS_ACCOUNTING_MODE_DUMMY 8 -150 :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 报表 报表 9 -140 :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 标志 10 -120 :p_min_precision Number fnd_profile.value('CURRENCY:MIXED_PRECISION') JA 混合通貨精度 KO 혼합 통화 소수점 이하 자리수 US Mixed Currency Precision ZHS 混合币种精确度 11 -110 :p_source_application_name Char SELECT :$flex$.source_application.VALUE FROM DUAL JA ソース・アプリケーション名 ソース・アプリケーション名 KO 출처 애플리케이션명 출처 애플리케이션명 US Source Application Name Source Application Name ZHS 来源应用产品名 来源应用产品名 12 -100 :p_application_name Char SELECT :$flex$.application.VALUE FROM DUAL JA アプリケーション名 アプリケーション名 KO 애플리케이션명 애플리케이션명 US Application Name Application Name ZHS 应用产品名 应用产品名 13 -90 :p_ledger_name Char SELECT :$flex$.ledger.VALUE FROM DUAL JA 元帳名 元帳名 KO 원장명 원장명 US Ledger Name Ledger Name ZHS 分类帐名称 分类帐名称 14 -80 :p_process_category_name Char SELECT :$flex$.ledger.VALUE FROM DUAL JA プロセス・カテゴリ名 プロセス・カテゴリ名 KO 프로세스 범주명 프로세스 범주명 US Process Category Name Process Category Name ZHS 流程类别名称 流程类别名称 15 -70 :p_create_accounting Char SELECT :$flex$.create_accounting.VALUE FROM DUAL JA 会計の作成 2 会計の作成 KO 회계 생성 2 회계 생성 US Create Accounting 2 Create Accounting ZHS 创建会计科目 2 创建会计科目 16 -60 :p_accounting_mode_name Char SELECT :$flex$.mode.VALUE FROM DUAL JA 会計モード名 会計モード名 KO 회계 모드명 회계 모드명 US Accounting Mode Name Accounting Mode Name ZHS 会计模式名称 会计模式名称 17 -50 :p_errors_only Char SELECT :$flex$.errors_only.VALUE FROM DUAL JA エラーのみ エラーのみ KO 오류만 오류만 US Errors Only Errors Only ZHS 仅显示错误 仅显示错误 18 -40 :p_accounting_report_level Char SELECT :$flex$.report.VALUE FROM DUAL JA レポート・レベル レポート・レベル KO 보고서 레벨 보고서 레벨 US Report Level Report Level ZHS 报表层 报表层 19 -30 :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 20 -20 :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 中过帐 21 -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 启用调试日志 启用调试日志的标志 22 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 分类帐 分类帐标识 23 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 流程类别 流程类别代码 24 30 :p_end_date Date Y JA 終了日 終了日 KO 종료 일자 종료 일자 US End Date End Date ZHS 终止日期 终止日期 25 40 :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 标志 26 50 :p_gl_batch_name Char JA 一般会計バッチ名 一般会計バッチ名 KO 총계정원장 뱃치명 총계정원장 뱃치명 US General Ledger Batch Name General Ledger Batch Name ZHS 总帐批名 总帐批名 :$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 :$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$.ledger.VALUE Ledger Process Category Name value :$flex$.post_in_general_ledger.VALUE Post in General Ledger Post in GL 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 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 Post in General Ledger :$flex$.xla_srs_subledger_ledgers_jl Ledger Report :$flex$.xla_srs_subledger_ledgers_jl Ledger Transfer to General Ledger