ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEB83869E053B46B63588994 select gr1.name groupring_rule_name, gr1.description grouping_rule_desc, gr1.start_date, gr1.end_date, ord.name ordering_rule_name, al.meaning type, gc.description column_name from ra_grouping_rules gr1, ra_line_ordering_rules ord, ra_grouping_trx_types gt, ra_group_bys gb, ra_group_by_columns gc, ar_lookups al where gr1.ordering_rule_id = ord.ordering_rule_id(+) and gr1.grouping_rule_id = gt.grouping_rule_id(+) and gt.grouping_trx_type_id = gb.grouping_trx_type_id(+) and gb.column_id = gc.column_id and al.lookup_type = 'GROUPING_TRX_TYPE' and al.lookup_code = gt.class &LP_GROUPING_LOW &LP_GROUPING_HIGH --order by 1,2,3,4,5,6,7 ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,6 ASC Y AR ARXGRL_XML AR AR قائمة قواعد الترتيب والتجميع (بتنسيق XML) Application: المقبوضات Source: قائمة قواعد الترتيب والتجميع (بتنسيق XML) Short Name: ARXGRL_XML DB package: AR_ARXGRL_XMLP_PKG D AR Liste Gruppierungsregeln Application: Debitoren Source: Liste Gruppierungsregeln (XML) Short Name: ARXGRL_XML DB package: AR_ARXGRL_XMLP_PKG F AR Liste des règles de regroupement et de tri Application: Receivables Source: Liste des règles de regroupement et de tri (XML) Short Name: ARXGRL_XML DB package: AR_ARXGRL_XMLP_PKG US AR Ordering and Grouping Rules Listing Application: Receivables Source: Ordering and Grouping Rules Listing (XML) Short Name: ARXGRL_XML DB package: AR_ARXGRL_XMLP_PKG ZHS AR 排序和分组规则列表 Application: 应收帐款 Source: 排序和分组规则列表 (XML) Short Name: ARXGRL_XML DB package: AR_ARXGRL_XMLP_PKG BI Publisher &lp_grouping_high &lp_grouping_low :acct_bal_aprompt :lp_grouping_high :lp_grouping_low :lp_ordering_high :lp_ordering_low :operating_unit :p_conc_request_id :p_grouping_name_high :p_grouping_name_low :p_ordering_name_high :p_ordering_name_low :p_run_grouping :p_run_grouping_meaning :p_run_ordering :p_run_ordering_meaning :p_set_of_books_id :rp_company_name :rp_data_found :rp_report_name :rp_sub_title 1 10 :p_run_ordering LOV Oracle AR_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR تكوين تقرير قواعد الترتيب D Mit Positionsfolgen F Créer les règles de tri dans l'état US Create Ordering Rules Report ZHS 创建排序规则报表 2 20 :p_run_grouping LOV Oracle AR_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR تكوين تقرير قواعد التجميع D Mit Gruppierungsregeln F Créer les règles de regroupement dans l'état US Create Grouping Rules Report ZHS 创建分组规则报表 3 30 :p_ordering_name_low LOV Oracle AR_SRS_ORDERING_RULE Y select name id, name value, description description from ra_line_ordering_rules order by name,description AR اسم قاعدة ترتيب من D Von Positionsfolge F Nom de règle de tri - De US Ordering Rule Name Low ZHS 排序规则名称下限 4 40 :p_ordering_name_high LOV Oracle AR_SRS_ORDERING_RULE Y select name id, name value, description description from ra_line_ordering_rules order by name,description AR اسم قاعدة ترتيب إلى D Bis Positionsfolge F Nom de règle de tri - A US Ordering Rule Name High ZHS 排序规则名称上限 5 50 :p_grouping_name_low LOV Oracle AR_SRS_GROUPING_RULE Y select name id, name value, description description from ra_grouping_rules order by name,description AR اسم قاعدة تجميع من D Von Gruppierungsregel F Nom de règle de regroupement - De US Grouping Rule Name Low ZHS 分组规则名称下限 6 60 :p_grouping_name_high LOV Oracle AR_SRS_GROUPING_RULE Y select name id, name value, description description from ra_grouping_rules order by name,description AR اسم قاعدة تجميع إلى D Bis Gruppierungsregel F Nom de règle de regroupement - A US Grouping Rule Name High ZHS 分组规则名称上限