ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726E51A9E05362FB09050512Y select null FLEX_DATA_ALL, null FLEX_DATA_BAL, null FLEX_DATA_SEG, decode(gcc.detail_posting_allowed_flag, 'Y', '*', '') POSTING_ALLOWED, decode(gcc.detail_budgeting_allowed_flag, 'Y', '*', '') BUDGET_ALLOWED, decode ( gcc.summary_flag, 'Y', ' ', gl1.description ) ACCOUNT_TYPE, gcc.summary_flag SUMMARY_FLAG, decode(gcc.summary_flag, 'Y', '*', '') SUMMARY, gcc.enabled_flag ENABLED_FLAG, decode(gcc.enabled_flag, 'Y', '*', '') ENABLED, gcc.start_date_active START_DATE, gcc.end_date_active END_DATE, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_bal_unpad', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') FLEX_FIELD_BAL_UNPAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_bal_pad', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'PADDED_VALUE') FLEX_FIELD_BAL_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_desc_bal', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') FLEX_DESC_BAL, --null FLEX_APROMPT_BAL, --null FLEX_LPROMPT_BAL, &FLEX_FIELD_SEG_UNPAD FLEX_FIELD_SEG_UNPAD, &FLEX_FIELD_SEG_PAD FLEX_FIELD_SEG_PAD, &FLEX_DESC_SEG FLEX_DESC_SEG, --null FLEX_APROMPT_SEG, --null FLEX_LPROMPT_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_all', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_FIELD_ALL from gl_lookups gl1, gl_code_combinations gcc where gcc.chart_of_accounts_id = :P_STRUCT_NUM and &FLEX_WHERE_ALL and gcc.account_type = gl1.lookup_code and gl1.lookup_type = 'ACCOUNT TYPE' order by gcc.summary_flag, gcc.enabled_flag desc, &FLEX_ORDERBY_BAL, &FLEX_ORDERBY_SEG, &FLEX_ORDERBY_ALL SQLGL GLXRLCOA_XML AR GL جدول تصنيف الحسابات - قائمة التفاصيل (بتنسيق XML) Imported from BI Publisher Description: تقرير قائمة جداول تصنيف الحسابات Application: الأستاذ العام Source: جدول تصنيف الحسابات - قائمة التفاصيل (بتنسيق XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG D GL Kontenplan Imported from BI Publisher Description: Kontenplan Application: Rechnungswesen Source: Kontenplan (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG E GL Plan de Cuentas - Listado Detallado Imported from BI Publisher Description: Informe Plan de Cuentas - Listado Detallado Application: General Ledger Source: Plan de Cuentas - Listado Detallado (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG F GL Plan de comptes - Liste détaillée Imported from BI Publisher Description: Liste du plan de comptes Application: General Ledger Source: Plan de comptes - Liste détaillée (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG I GL Piano dei conti - Elenco dettagli Imported from BI Publisher Description: Rapporto Elenco piani dei conti Application: General Ledger Source: Piano dei conti - Elenco dettagli (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG JA GL 勘定体系 - 詳細リスト Imported from BI Publisher Description: 勘定体系リスト・レポート Application: General Ledger Source: 勘定体系 - 詳細リスト (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG KO GL 계정 코드집 - 상세 목록 Imported from BI Publisher Description: 계정 코드집 목록 보고서 Application: General Ledger Source: 계정 코드집 - 상세 목록(XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG PTB GL Plano de Contas - Lista Detalhada Imported from BI Publisher Description: Relatório de Lista de Planos de Contas Application: General Ledger Source: Plano de Contas - Lista Detalhada (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG RU GL План счетов - подробный список Imported from BI Publisher Description: План счетов Application: Главная книга Source: План счетов - подробный список (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG S GL Kontoplansdetaljer Imported from BI Publisher Description: Kontoplan - listrapport Application: General Ledger Source: Kontoplansdetaljer (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG TR GL Hesap Planı - Detay Listesi Imported from BI Publisher Description: Hesap Planı Liste Raporu Application: Genel Muhasebe Source: Hesap Planı - Detay Listesi (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG US GL Chart of Accounts - Detail Listing Imported from BI Publisher Description: Chart of Accounts Listing Report Application: General Ledger Source: Chart of Accounts - Detail Listing (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG ZHS GL 科目表 - 明细列表 Imported from BI Publisher Description: 科目表列表报表 Application: 总帐管理系统 Source: 科目表 - 明细列表 (XML) Short Name: GLXRLCOA_XML DB package: GL_GLXRLCOA_XMLP_PKG BI Publisher &flex_desc_seg &flex_field_seg_pad &flex_field_seg_unpad &flex_orderby_all &flex_orderby_bal &flex_orderby_seg &flex_where_all :flex_nodata_select_all :flex_orderby_all :flex_orderby_bal :flex_orderby_seg :flex_select_all :flex_select_bal :flex_select_seg :flex_where_all :p_conc_request_id :p_flex_high :p_flex_low :p_orderby_seg :p_struct_num 1 -20 :p_struct_num Number SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR GL_SRS_COA_UNVALIDATED جدول تصنيف الحسابات D GL_SRS_COA_UNVALIDATED Kontenplan E GL_SRS_COA_UNVALIDATED Plan de Cuentas F GL_SRS_COA_UNVALIDATED Plan de comptes I GL_SRS_COA_UNVALIDATED Piano dei conti JA GL_SRS_COA_UNVALIDATED 勘定体系 KO GL_SRS_COA_UNVALIDATED 계정 코드집 PTB GL_SRS_COA_UNVALIDATED Plano de contas RU GL_SRS_COA_UNVALIDATED План счетов S GL_SRS_COA_UNVALIDATED Kontoplan TR GL_SRS_COA_UNVALIDATED Hesap Planı US GL_SRS_COA_UNVALIDATED Chart of accounts ZHS GL_SRS_COA_UNVALIDATED 科目表 2 10 :p_flex_low Char Y AR الحساب من الحساب من D Von Konto Von Konto E De Cuenta De Cuenta F Compte - De Compte - De I Conto - Da Conto - Da JA 勘定科目:自 勘定科目:自 KO 계정: 부터 계정: 부터 PTB Conta - De Conta - De RU Счет с Счет с S Från konto Från konto TR Hesap, İlk Hesap, İlk US Account From Account From ZHS 账户自 账户自 3 20 :p_flex_high Char Y AR حساب إلى حساب إلى D Bis Konto Bis Konto E A Cuenta A Cuenta F Compte - A Compte - A I Conto - A Conto - A JA 勘定科目:至 勘定科目:至 KO 계정: 까지 계정: 까지 PTB Conta - Até Conta - Até RU Счет по Счет по S Till konto Till konto TR Hesap, Son Hesap, Son US Account To Account To ZHS 账户至 账户至 4 30 :p_orderby_seg LOV Oracle GL_SRS_COA_ORDERBY_SEGS Y select segment_num id, segment_name value, s.description description from fnd_id_flex_segments_vl s,fnd_segment_attribute_values v where s.id_flex_code='GL#' and v.id_flex_code='GL#' and s.id_flex_num=:$flex$.gl_srs_coa_unvalidated and v.id_flex_num=:$flex$.gl_srs_coa_unvalidated and s.enabled_flag='Y' and s.application_column_name=v.application_column_name and s.application_id=101 and v.application_id=101 and v.segment_attribute_type='GL_BALANCING' and v.attribute_value='N' order by segment_num SELECT segment_name, s.description, segment_num FROM fnd_id_flex_segments_vl S, fnd_segment_attribute_values V WHERE S.id_flex_code = 'GL#' AND V.id_flex_code = 'GL#' AND S.id_flex_num = :$FLEX$.GL_SRS_COA_UNVALIDATED AND V.id_flex_num = :$FLEX$.GL_SRS_COA_UNVALIDATED AND S.enabled_flag = 'Y'AND S.application_column_name = V.application_column_name AND S.application_id = 101 AND V.application_id = 101 AND V.segment_attribute_type = 'GL_ACCOUNT' AND V.attribute_value = 'Y' Y AR ترتيب بواسطة ترتيب بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Ord. Por Ord. Por RU Сортировка Сортировка S Ordna per Ordna per TR Sıralama Bazı Sıralama Bazı US Order By Order By ZHS 排序依据 排序依据