ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D46F2E51A9E05362FB09050512 SELECT HCA.account_number customer_code ,ARL.meaning invoice_type ,RCT.trx_number invoice_number ,RCT.trx_date transaction_date ,RCT.customer_trx_id customer_trx_id ,HZP.party_name customer_name ,APSA.gl_date gl_date ,RCT.invoice_currency_code currency_code ,APSA.amount_due_original amount ,AR_DEP_BAL_RPT_PKG.Description(RCT.attribute5,'ATTRIBUTE5') issuing_dept_name ,RCT1.trx_number source_invoice_number ,fnd_flex_xml_publisher_apis.process_kff_combination_1('company_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') company ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'VALUE') department ,fnd_flex_xml_publisher_apis.process_kff_combination_1('account_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') account ,GCC.segment1 segment1 ,GCC.segment2 segment2 ,GCC.segment3 segment3 ,GCC.segment4 segment4 ,GCC.segment5 segment5 ,GCC.segment6 segment6 ,GCC.segment7 segment7 ,GCC.segment8 segment8 ,GCC.segment9 segment9 ,GCC.segment10 segment10 ,GCC.segment11 segment11 ,GCC.segment12 segment12 ,GCC.segment13 segment13 ,GCC.segment14 segment14 ,GCC.segment15 segment15 ,GCC.segment16 segment16 ,GCC.segment17 segment17 ,GCC.segment18 segment18 ,GCC.segment19 segment19 ,GCC.segment20 segment20 ,GCC.segment21 segment21 ,GCC.segment22 segment22 ,GCC.segment23 segment23 ,GCC.segment24 segment24 ,GCC.segment25 segment25 ,GCC.segment26 segment26 ,GCC.segment27 segment27 ,GCC.segment28 segment28 ,GCC.segment29 segment29 ,GCC.segment30 segment30 ,RCT.attribute1 attribute1 ,RCT.attribute2 attribute2 ,RCT.attribute3 attribute3 ,RCT.attribute4 attribute4 ,RCT.attribute5 attribute5 ,RCT.attribute6 attribute6 ,RCT.attribute7 attribute7 ,RCT.attribute8 attribute8 ,RCT.attribute9 attribute9 ,RCT.attribute10 attribute10 ,RCT.attribute11 attribute11 ,RCT.attribute12 attribute12 ,RCT.attribute13 attribute13 ,RCT.attribute14 attribute14 ,RCT.attribute15 attribute15 ,fnd_flex_xml_publisher_apis.process_kff_combination_1('company_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') company_desc ,fnd_flex_xml_publisher_apis.process_kff_combination_1('account_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') account_desc ,AR_DEP_BAL_RPT_PKG.description(GCC.segment4,'SEGMENT4') segment4_desc FROM ra_customer_trx RCT ,ra_customer_trx RCT1 ,ra_cust_trx_line_gl_dist_all RCTD ,ra_cust_trx_types_all RCTT ,hz_cust_accounts HCA ,hz_parties HZP ,gl_code_combinations GCC ,ar_payment_schedules_all APSA ,ar_lookups ARL WHERE RCT.previous_customer_trx_id = :MAIN_CUSTOMER_TRX_ID AND RCT1.customer_trx_id = RCT.previous_customer_trx_id AND RCTD.customer_trx_id = RCT.customer_trx_id AND RCT.cust_trx_type_id = RCTT.cust_trx_type_id AND RCT.org_id = RCTT.org_id AND RCT.bill_to_customer_id = HCA.cust_account_id AND HCA.party_id = HZP.party_id AND APSA.customer_trx_id = RCT.customer_trx_id AND RCTD.code_combination_id = GCC.code_combination_id AND RCTD.gl_date >= :gc_per_start_date AND RCTD.gl_date <= :gc_per_end_date AND ARL.lookup_type ='INVOICE_TYPE' AND ARL.lookup_code ='CD' AND RCTT.type = 'CM' AND RCT.complete_flag = 'Y' AND RCTT.post_to_gl = 'Y' AND RCTD.account_class = 'REC' AND RCTD.latest_rec_flag = 'Y' &gc_customer &gc_currency UNION ALL --Queries all the Deposits for adjustments are done SELECT HCA.account_number customer_code ,ARL.meaning invoice_type ,RCT.trx_number invoice_number ,RCT.trx_date transaction_date ,RCT.customer_trx_id customer_trx_id ,HZP.party_name customer_name ,ARA.gl_date gl_date ,RCT.invoice_currency_code currency_code ,ARA.amount amount ,AR_DEP_BAL_RPT_PKG.Description(RCT.attribute5,'ATTRIBUTE5') issuing_dept_name ,NULL source_invoice_number ,fnd_flex_xml_publisher_apis.process_kff_combination_1('company_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') company ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'VALUE') department ,fnd_flex_xml_publisher_apis.process_kff_combination_1('account_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') account ,gcc.segment1 segment1 ,gcc.segment2 segment2 ,gcc.segment3 segment3 ,gcc.segment4 segment4 ,gcc.segment5 segment5 ,gcc.segment6 segment6 ,gcc.segment7 segment7 ,gcc.segment8 segment8 ,gcc.segment9 segment9 ,gcc.segment10 segment10 ,gcc.segment11 segment11 ,gcc.segment12 segment12 ,gcc.segment13 segment13 ,gcc.segment14 segment14 ,gcc.segment15 segment15 ,gcc.segment16 segment16 ,gcc.segment17 segment17 ,gcc.segment18 segment18 ,gcc.segment19 segment19 ,gcc.segment20 segment20 ,gcc.segment21 segment21 ,gcc.segment22 segment22 ,gcc.segment23 segment23 ,gcc.segment24 segment24 ,gcc.segment25 segment25 ,gcc.segment26 segment26 ,gcc.segment27 segment27 ,gcc.segment28 segment28 ,gcc.segment29 segment29 ,gcc.segment30 segment30 ,RCT.attribute1 attribute1 ,RCT.attribute2 attribute2 ,RCT.attribute3 attribute3 ,RCT.attribute4 attribute4 ,RCT.attribute5 attribute5 ,RCT.attribute6 attribute6 ,RCT.attribute7 attribute7 ,RCT.attribute8 attribute8 ,RCT.attribute9 attribute9 ,RCT.attribute10 attribute10 ,RCT.attribute11 attribute11 ,RCT.attribute12 attribute12 ,RCT.attribute13 attribute13 ,RCT.attribute14 attribute14 ,RCT.attribute15 attribute15 ,fnd_flex_xml_publisher_apis.process_kff_combination_1('company_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') company_desc ,fnd_flex_xml_publisher_apis.process_kff_combination_1('account_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') account_desc ,AR_DEP_BAL_RPT_PKG.description(gcc.segment4,'SEGMENT4') segment4_desc FROM ra_customer_trx RCT ,ra_cust_trx_types_all RCTT ,ra_cust_trx_line_gl_dist_all RCTD ,gl_code_combinations GCC ,hz_cust_accounts HCA ,hz_parties HZP ,ar_adjustments_all ARA ,ar_distributions_all ARD ,ar_lookups ARL WHERE RCTD.customer_trx_id = RCT.customer_trx_id AND RCT.customer_trx_id = :MAIN_CUSTOMER_TRX_ID AND RCT.cust_trx_type_id = RCTT.cust_trx_type_id AND RCT.org_id = RCTT.org_id AND RCTT.type = 'DEP' AND RCT.complete_flag = 'Y' AND RCTT.post_to_gl = 'Y' AND ARA.gl_date >= :gc_per_start_date AND ARA.gl_date <= :gc_per_end_date AND ARL.lookup_type ='INVOICE_TYPE' AND ARL.lookup_code ='CD' AND RCTD.account_class = 'REC' AND RCTD.latest_rec_flag = 'Y' AND ARA.adjustment_id = ARD.source_id AND ARD.source_table = 'ADJ' AND ARD.source_type = 'REC' AND ARD.code_combination_id = GCC.code_combination_id AND RCT.bill_to_customer_id = HCA.cust_account_id AND HCA.party_id = HZP.party_id AND RCT.customer_trx_id = ARA.customer_trx_id AND ARA.subsequent_trx_id IS NULL &gc_customer &gc_currency UNION ALL --Queries all the Invoices for which the Deposits are applied SELECT HCA.account_number customer_code ,ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('INV/CM',RCTT.type) invoice_type ,RCT.trx_number invoice_number ,RCT.trx_date transaction_date ,RCT.customer_trx_id customer_trx_id ,HZP.party_name customer_name ,ARA.gl_date gl_date ,RCT.invoice_currency_code currency_code ,ARA.amount amount ,AR_DEP_BAL_RPT_PKG.Description(RCT.attribute5,'ATTRIBUTE5') issuing_dept_name ,NULL source_invoice_number ,fnd_flex_xml_publisher_apis.process_kff_combination_1('company_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') company ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'VALUE') department ,fnd_flex_xml_publisher_apis.process_kff_combination_1('account_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') account ,GCC.segment1 segment1 ,GCC.segment2 segment2 ,GCC.segment3 segment3 ,GCC.segment4 segment4 ,GCC.segment5 segment5 ,GCC.segment6 segment6 ,GCC.segment7 segment7 ,GCC.segment8 segment8 ,GCC.segment9 segment9 ,GCC.segment10 segment10 ,GCC.segment11 segment11 ,GCC.segment12 segment12 ,GCC.segment13 segment13 ,GCC.segment14 segment14 ,GCC.segment15 segment15 ,GCC.segment16 segment16 ,GCC.segment17 segment17 ,GCC.segment18 segment18 ,GCC.segment19 segment19 ,GCC.segment20 segment20 ,GCC.segment21 segment21 ,GCC.segment22 segment22 ,GCC.segment23 segment23 ,GCC.segment24 segment24 ,GCC.segment25 segment25 ,GCC.segment26 segment26 ,GCC.segment27 segment27 ,GCC.segment28 segment28 ,GCC.segment29 segment29 ,GCC.segment30 segment30 ,RCT.attribute1 attribute1 ,RCT.attribute2 attribute2 ,RCT.attribute3 attribute3 ,RCT.attribute4 attribute4 ,RCT.attribute5 attribute5 ,RCT.attribute6 attribute6 ,RCT.attribute7 attribute7 ,RCT.attribute8 attribute8 ,RCT.attribute9 attribute9 ,RCT.attribute10 attribute10 ,RCT.attribute11 attribute11 ,RCT.attribute12 attribute12 ,RCT.attribute13 attribute13 ,RCT.attribute14 attribute14 ,RCT.attribute15 attribute15 ,fnd_flex_xml_publisher_apis.process_kff_combination_1('company_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') company_desc ,fnd_flex_xml_publisher_apis.process_kff_combination_1('account_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') account_desc ,AR_DEP_BAL_RPT_PKG.description(GCC.segment4,'SEGMENT4') segment4_desc FROM ra_customer_trx RCT ,ra_cust_trx_line_gl_dist_all RCTD ,ra_cust_trx_types_all RCTT ,hz_cust_accounts HCA ,hz_parties HZP ,gl_code_combinations GCC ,ar_adjustments_all ARA ,ar_distributions_all ARD WHERE RCT.initial_customer_trx_id = :MAIN_CUSTOMER_TRX_ID AND RCTD.customer_trx_id = RCT.customer_trx_id AND RCT.customer_trx_id = ARA.customer_trx_id AND RCT.cust_trx_type_id = RCTT.cust_trx_type_id AND RCT.org_id = RCTT.org_id AND RCT.bill_to_customer_id = HCA.cust_account_id AND HCA.party_id = HZP.party_id AND ARD.code_combination_id = GCC.code_combination_id AND ARA.gl_date >= :gc_per_start_date AND ARA.gl_date <= :gc_per_end_date AND ARA.adjustment_id = ARD.source_id AND ARD.source_table = 'ADJ' AND ARD.source_type = 'REC' AND RCTT.type = 'INV' AND RCT.complete_flag = 'Y' AND ARA.subsequent_trx_id IS NULL AND RCTT.post_to_gl = 'Y' AND RCTD.account_class = 'REC' AND RCTD.latest_rec_flag = 'Y' &gc_customer &gc_currency UNION ALL --Queries all the Credit Memos that are mapped to Invoices -- for which the Deposits are applied SELECT HCA.account_number customer_code ,ARL.meaning invoice_type ,RCT.trx_number invoice_number ,RCT.trx_date transaction_date ,RCT.customer_trx_id customer_trx_id ,HZP.party_name customer_name ,ARA.gl_date gl_date ,RCT.invoice_currency_code currency_code ,ARA.amount amount ,NULL issuing_dept_name ,RCT1.trx_number source_invoice_number ,fnd_flex_xml_publisher_apis.process_kff_combination_1('company_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') company ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'N', 'VALUE') department ,fnd_flex_xml_publisher_apis.process_kff_combination_1('account_select', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') account ,GCC.segment1 segment1 ,GCC.segment2 segment2 ,GCC.segment3 segment3 ,GCC.segment4 segment4 ,GCC.segment5 segment5 ,GCC.segment6 segment6 ,GCC.segment7 segment7 ,GCC.segment8 segment8 ,GCC.segment9 segment9 ,GCC.segment10 segment10 ,GCC.segment11 segment11 ,GCC.segment12 segment12 ,GCC.segment13 segment13 ,GCC.segment14 segment14 ,GCC.segment15 segment15 ,GCC.segment16 segment16 ,GCC.segment17 segment17 ,GCC.segment18 segment18 ,GCC.segment19 segment19 ,GCC.segment20 segment20 ,GCC.segment21 segment21 ,GCC.segment22 segment22 ,GCC.segment23 segment23 ,GCC.segment24 segment24 ,GCC.segment25 segment25 ,GCC.segment26 segment26 ,GCC.segment27 segment27 ,GCC.segment28 segment28 ,GCC.segment29 segment29 ,GCC.segment30 segment30 ,RCT.attribute1 attribute1 ,RCT.attribute2 attribute2 ,RCT.attribute3 attribute3 ,RCT.attribute4 attribute4 ,NULL attribute5 ,RCT.attribute6 attribute6 ,RCT.attribute7 attribute7 ,RCT.attribute8 attribute8 ,RCT.attribute9 attribute9 ,RCT.attribute10 attribute10 ,RCT.attribute11 attribute11 ,RCT.attribute12 attribute12 ,RCT.attribute13 attribute13 ,RCT.attribute14 attribute14 ,RCT.attribute15 attribute15 ,fnd_flex_xml_publisher_apis.process_kff_combination_1('company_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') company_desc ,fnd_flex_xml_publisher_apis.process_kff_combination_1('account_desc', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') account_desc ,AR_DEP_BAL_RPT_PKG.description(GCC.segment4,'SEGMENT4') segment4_desc FROM ra_customer_trx RCT ,ra_customer_trx RCT1 ,ra_cust_trx_line_gl_dist_all RCTD ,ra_cust_trx_types_all RCTT ,hz_cust_accounts HCA ,hz_parties HZP ,gl_code_combinations GCC ,ar_adjustments_all ARA ,ar_distributions_all ARD ,ar_lookups ARL WHERE RCT.initial_customer_trx_id = :MAIN_CUSTOMER_TRX_ID AND RCT1.customer_trx_id = RCT.previous_customer_trx_id AND RCTD.customer_trx_id = RCT.customer_trx_id AND RCT.customer_trx_id = ARA.subsequent_trx_id AND RCT.cust_trx_type_id = RCTT.cust_trx_type_id AND RCT.org_id = RCTT.org_id AND RCT.bill_to_customer_id = HCA.cust_account_id AND HCA.party_id = HZP.party_id AND ARD.code_combination_id = GCC.code_combination_id AND ARA.gl_date >= :gc_per_start_date AND ARA.gl_date <= :gc_per_end_date AND ARL.lookup_type ='INVOICE_TYPE' AND ARL.lookup_code ='CAI' AND ARA.adjustment_id = ARD.source_id AND ARD.source_table = 'ADJ' AND ARD.source_type = 'REC' AND RCTT.type = 'CM' AND RCT.complete_flag = 'Y' AND RCTT.post_to_gl = 'Y' AND RCTD.account_class = 'REC' AND RCTD.latest_rec_flag = 'Y' &gc_customer &gc_currency Y AR ARDEPBALRPT AR AR تقرير رصيد الإيداع - اليابان Imported from BI Publisher Application: المقبوضات Source: تقرير رصيد الإيداع - اليابان Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG D AR Anzahlungssaldo - Japan Imported from BI Publisher Description: Auswertung "Anzahlungssaldo" - Japan Application: Debitoren Source: Anzahlungssaldo - Japan Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG E AR Japón - Informe Saldo de Depósito Imported from BI Publisher Description: Japón - Informe de saldo de depósito Application: Receivables Source: Japón - Informe Saldo de Depósito Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG F AR Etat de solde des remises - Japon Imported from BI Publisher Application: Receivables Source: Etat de solde des remises - Japon Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG I AR Rapporto Saldo versamento (Giappone) Imported from BI Publisher Application: Receivables Source: Rapporto Saldo versamento (Giappone) Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG JA AR 前受/預り金残高レポート - 日本 Imported from BI Publisher Application: Receivables Source: 前受/預り金残高レポート - 日本 Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG KO AR 예금 잔액 보고서 - 일본 Imported from BI Publisher Application: Receivables Source: 예금 잔액 보고서 - 일본 Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG PTB AR Relatório de Saldo de Depósito - Japão Imported from BI Publisher Application: Receivables Source: Relatório de Saldo de Depósito - Japão Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG RU AR Отчет о сальдо депозита - Япония Imported from BI Publisher Application: Дебиторы Source: Отчет о сальдо депозита - Япония Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG S AR Rapport om insättningssaldo - Japan Imported from BI Publisher Application: Receivables Source: Rapport om insättningssaldo - Japan Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG TR AR Mevduat Bakiyesi Raporu - Japonya Imported from BI Publisher Application: Alacaklar Muhasebesi Source: Mevduat Bakiyesi Raporu - Japonya Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG US AR Deposit Balance Report - Japan Imported from BI Publisher Application: Receivables Source: Deposit Balance Report - Japan Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG ZHS AR 存款余额报表 - 日本 Imported from BI Publisher Application: 应收帐款 Source: 存款余额报表 - 日本 Short Name: ARDEPBALRPT DB package: AR_DEP_BAL_RPT_PKG BI Publisher &gc_currency &gc_customer :gc_currency :gc_customer :gc_per_end_date :gc_per_start_date :gn_cust_id :gn_ledger_id :main_customer_trx_id :operating_unit :p_currency :p_customer :p_customer_dummy :p_customer_name :p_period_from :p_period_to 1 -10 :p_customer_dummy Char SELECT :$flex$.customer.VALUE FROM DUAL AR البيانات الافتراضية للعميل البيانات الافتراضية للعميل D Kunde - Dummy Kunde - Dummy E Cliente Ficticio Cliente ficticio F Client - Fictif Client - Fictif I Cliente fittizio Cliente fittizio JA 顧客ダミー 顧客ダミー KO 고객 Dummy 고객 Dummy PTB Fictício do Cliente Fictício do Cliente RU Фиктивный заказчик Фиктивный заказчик S Dummy-kund Dummy-kund TR Sözde Müşteri Sözde Müşteri US Customer Dummy Customer Dummy ZHS 客户虚拟 客户虚拟 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_period_from LOV Oracle AR_SRS_PERIOD_NAMES Y select period_name id, period_name value, null description from gl_period_statuses where set_of_books_id= (select set_of_books_id from ar_system_parameters) and application_id=222 order by period_year desc,period_num desc SELECT glp.period_name FROM gl_periods glp, hr_operating_units hou, gl_ledgers gll WHERE mo_global.check_access(hou.organization_id) = 'Y' AND gll.ledger_id=hou.set_of_books_id AND glp.period_set_name=gll.period_set_name AND SYSDATE BETWEEN start_date and end_date AND glp.period_type=gll.accounted_period_type Y AR الفترة من الفترة من D Von Periode Von Periode E De Período De período F Période - De Période - De I Periodo - Da Periodo - Da JA 期間:自 期間:自 KO 기간: 부터 기간: 부터 PTB Período - De Período - De RU Период с Период с S Från period Från period TR Dönem, İlk Dönem, İlk US Period From Period From ZHS 期间自 期间自 4 20 :p_period_to LOV Oracle AR_SRS_PERIOD_NAMES_TO Y select period_name id, period_name value, null description from gl_period_statuses where set_of_books_id= (select set_of_books_id from ar_system_parameters) and application_id=222 and effective_period_num>=(select effective_period_num from gl_period_statuses where set_of_books_id= (select set_of_books_id from ar_system_parameters) and application_id=222 and period_name=:$flex$.ar_srs_period_names) order by period_year desc,period_num desc SELECT glp.period_name FROM gl_periods glp, hr_operating_units hou, gl_ledgers gll WHERE mo_global.check_access(hou.organization_id) = 'Y' AND gll.ledger_id=hou.set_of_books_id AND glp.period_set_name=gll.period_set_name AND SYSDATE BETWEEN start_date and end_date AND glp.period_type=gll.accounted_period_type Y AR الفترة إلى الفترة إلى D Bis Periode Bis Periode E A Período A período F Période - A Période - A I Periodo - A Periodo - A JA 期間:至 期間:至 KO 기간: 까지 기간: 까지 PTB Período - Até Período - Até RU Период по Период по S Till period Till period TR Dönem, Son Dönem, Son US Period To Period To ZHS 期间至 期间至 5 30 :p_customer_name LOV Oracle AR_BR_CUSTOMER_NAME Y Y select ca.cust_account_id id, party.party_name value, null description from hz_cust_accounts ca,hz_parties party where ca.party_id=party.party_id order by party.party_name AR العميل العميل D Kunde Kunde E Cliente Cliente F Client Client I Cliente Cliente JA 顧客 顧客 KO 고객 고객 PTB Cliente Cliente RU Заказчик Заказчик S Kund Kund TR Müşteri Müşteri US Customer Customer ZHS 客户 客户 6 40 :p_currency LOV Oracle AR_BR_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies where enabled_flag='Y' and currency_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) order by value,description AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 :$flex$.ar_srs_period_names Period From Period To :$flex$.customer.VALUE Customer Customer Dummy value