ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B027D79DDFA70A1FE0530100007F2EFD select x.account liability_account ,x.third_party_name supplier_name &sum_or_detail_cols from (select xtb.account ,xtb.third_party_name ,xtb.user_trx_identifier_value_3 ,xtb.user_trx_identifier_value_10 ,xtb.user_trx_identifier_value_8 ,xtb.ledger_currency_code ,xtb.src_acctd_rounded_orig_amt ,xtb.src_acctd_rounded_rem_amt ,sum(xtb.src_acctd_rounded_rem_amt) over(partition by xtb.account,xtb.third_party_name) sum_supp_liability from (&p_template_sql_statement &p_sql_statement ) xtb ) x where 1=1 and x.sum_supp_liability < 0 &summary_group_by Y SQLAP APXNVBAL AR AP Negative Supplier Balance Application: المدفوعات Source: رصيد المورِّد السالب لحسابات المدفوعات Short Name: APXNVBAL DB package: XLA_TB_AP_REPORT_PVT D AP Negative Supplier Balance Application: Kreditoren Source: Kreditoren - Negativer Lieferantensaldo Short Name: APXNVBAL DB package: XLA_TB_AP_REPORT_PVT E AP Negative Supplier Balance Aplicación: Cuentas por pagar Fuente: Saldo negativo de proveedores en cuentas a pagar Nombre corto: APXNVBAL Paquete DB: XLA_TB_AP_REPORT_PVT F AP Negative Supplier Balance Application: Payables Source: Accounts Payable - Solde fournisseur négatif Short Name: APXNVBAL DB package: XLA_TB_AP_REPORT_PVT I AP Negative Supplier Balance Application: Payables Source: Saldo fornitore negativo conto fornitori Short Name: APXNVBAL DB package: XLA_TB_AP_REPORT_PVT JA AP Negative Supplier Balance アプリケーション代金支払い 出典：「買掛金のマイナス残高仕入債務残高マイナス ショートネームです。APXNVBAL DB パッケージ。XLA_TB_AP_REPORT_PVT KO AP Negative Supplier Balance 신청 : Payables 출처 : 미지급금 음의 공급자 잔액 짧은 이름 : APXNVBAL DB 패키지 : XLA_TB_AP_REPORT_PVT PTB AP Negative Supplier Balance Aplicação: Contas a pagar Fonte: Contas a Pagar Saldo Negativo de Fornecedores Nome curto: APXNVBAL Pacote DB: XLA_TB_AP_REPORT_PVT RU AP Negative Supplier Balance Приложение: Кредиторская задолженность Источник: Кредиторская задолженность Отрицательный баланс поставщика Короткое имя: APXNVBAL БД-пакет: XLA_TB_AP_REPORT_PVT S AP Negative Supplier Balance Ansökan: Skulder Källa: Leverantörsskulder Negativ leverantörsbalans Kort namn: APXNVBAL DB-paket: XLA_TB_AP_REPORT_PVT TR AP Negative Supplier Balance Uygulama: Borçlar Kaynak: Borç Hesapları Eksi Tedarikçi Bakiyesi Kısa isim: APXNVBAL DB paketi: XLA_TB_AP_REPORT_PVT US AP Negative Supplier Balance Application: Payables Source: Accounts Payable Negative Supplier Balance Short Name: APXNVBAL DB package: XLA_TB_AP_REPORT_PVT ZHS AP Negative Supplier Balance Application: 应付帐款 Source: 应付帐款供应商负余额 Short Name: APXNVBAL DB package: XLA_TB_AP_REPORT_PVT Enginatics R12 only &p_sql_statement &p_template_sql_statement &sum_or_detail_cols &summary_group_by 1=1 :p_account_from :p_account_to :p_acct_balance :p_acct_balance_dsp :p_app_sql_statement :p_as_of_date :p_coa_id :p_custom_param_1 :p_custom_param_2 :p_custom_param_3 :p_definition_code :p_inc_sla_manuals_unposted :p_incl_write_off_dsp :p_incl_write_off_flag :p_include_sla_manuals_unposted :p_journal_source :p_journal_source_dsp :p_report :p_report_definition_dsp :p_report_mode_dsp :p_report_style :p_security_flag :p_security_id_char_1 :p_security_id_int_1 :p_show_trx_detail_dsp :p_show_trx_detail_flag :p_sql_statement :p_start_date :p_summary_sql_statement :p_third_party_id :p_third_party_name :p_valuation_method 1 -210 :p_report LOV Oracle XLA_SRS_TB_REPORT_MODE Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk where xlk.lookup_code<>'N' and xlk.lookup_type='XLA_REPORT_LEVEL' order by value,description D US Report Mode 2 &p_template_sql_statement select 'select null account, 0 gl_balance, 0 code_combination_id, null balancing_segment_value, null natural_account_segment_value, null cost_center_segment_value, null management_segment_value, null intercompany_segment_value, 0 ledger_id, null ledger_name, null ledger_short_name, null ledger_currency_code, null third_party_name, null third_party_number, null third_party_type_code, null third_party_type, null third_party_site_name, 0 source_trx_application_id, 0 source_entity_id, null source_trx_application_name, null source_trx_type, null source_trx_number, null source_trx_gl_date, null source_trx_curr, 0 src_entered_unrounded_orig_amt, 0 src_entered_unrounded_rem_amt, 0 src_entered_rounded_orig_amt, 0 src_entered_rounded_rem_amt, 0 src_acctd_unrounded_orig_amt, 0 src_acctd_unrounded_rem_amt, 0 src_acctd_rounded_orig_amt, 0 src_acctd_rounded_rem_amt, null user_trx_identifier_name_1, null user_trx_identifier_name_2, null user_trx_identifier_name_3, null user_trx_identifier_name_4, null user_trx_identifier_name_5, null user_trx_identifier_name_6, null user_trx_identifier_name_7, null user_trx_identifier_name_8, null user_trx_identifier_name_9, null user_trx_identifier_name_10, null user_trx_identifier_value_1, null user_trx_identifier_value_2, null user_trx_identifier_value_3, null user_trx_identifier_value_4, null user_trx_identifier_value_5, null user_trx_identifier_value_6, null user_trx_identifier_value_7, null user_trx_identifier_value_8, null user_trx_identifier_value_9, null user_trx_identifier_value_10, 0 non_ap_amount, 0 manual_sla_amount, null balancing_segment_desc, null natural_account_desc, null cost_center_desc, null management_segment_desc, null intercompany_segment_desc from dual' from dual where :run_id is null US Report Mode 3 -200 :p_account_from Char US Account From 4 -190 :p_account_to Char US Account To 5 -180 :p_custom_param_3 Char US Custom Parameter 3 6 -170 :p_incl_write_off_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 N US Include Write Offs 7 -160 :p_security_flag Char US Security 8 -150 :p_security_id_char_1 Char US Security Identifier (Character) 9 -140 :p_show_trx_detail_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 N US Show Transaction Detail 1 10 -130 :p_start_date Date to_date('01/01/1950','DD/MM/YYYY') US Start Date 11 -120 :p_valuation_method Char US Valuation Method 12 -60 :p_application 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 nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.RESP_APPL_ID) US XLA_SRS_SUBLEDGERS 13 -50 :p_journal_source LOV Oracle XLA_SRS_TB_JE_SOURCES Y select je_source_name id, user_je_source_name value, null description from gl_je_sources a where exists (select 1 from xla_tb_defn_je_sources djs ,xla_subledgers xls where djs.je_source_name=xls.je_source_name and djs.je_source_name=a.je_source_name and djs.definition_code=:$flex$.xla_srs_tb_definitions_all and xls.application_id= decode(nvl(fnd_profile.value('XLA_JE_SOURCE_ALLOW_OVERRIDE'),'N') ,'Y' ,xls.application_id ,:$flex$.xla_srs_subledgers ) ) order by user_je_source_name select xs.je_source_name from xla_tb_defn_je_sources xtdjs, xla_subledgers xs where xtdjs.definition_code=:$flex$.xla_srs_tb_definitions_all and xtdjs.je_source_name=xs.je_source_name and xs.application_id=nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.resp_appl_id) US Journal Source 14 -30 :p_coa_id Number select gl.chart_of_accounts_id from xla_tb_definitions_b xtdb, gl_ledgers gl where xtdb.definition_code=:$flex$.report_definition and xtdb.ledger_id=gl.ledger_id US Chart of Accounts 15 -20 :p_acct_balance LOV Oracle XLA_SRS_TB_ACCT_BALANCE Y select lookup_code id, meaning value, description description from xla_lookups where lookup_type='XLA_TB_ACCT_BALANCE' order by value,description YEAR_TO_DATE US Account Balance 16 -10 :p_custom_param_1 LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description N US Summarize Balances 17 10 :p_security_id_int_1 LOV Oracle FND_MO_OU Y select organization_id id, organization_name value, null description from mo_glob_org_access_tmp order by value,description US Operating Unit 18 20 :p_definition_code LOV Oracle XLA_SRS_TB_DEFINITIONS_ALL Y select definition_code id, name value, description description from xla_tb_definitions_vl where enabled_flag='Y' and ( definition_code in ( select xtd.definition_code from xla_tb_defn_je_sources xtd ,xla_subledgers xs where xtd.je_source_name=xs.je_source_name and xs.application_id=:$flex$.xla_srs_subledgers ) or decode(:$flex$.xla_srs_subledgers,101,'GL','OTHERS')='GL' ) 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 asa.ledger_id=xla_tb_definitions_vl.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 select xrrpv.value from xxen_report_parameters_v xrpv, (select xrr.report_id,max(xrr.run_id) run_id from xxen_report_runs xrr where xrr.created_by = fnd_global.user_id and xrr.responsibility_id = fnd_global.resp_id group by xrr.report_id) xrr, xxen_report_run_param_values xrrpv where xrpv.report_name = 'AP Negative Supplier Balance' and xrpv.parameter_name = 'Report Definition' and xrpv.report_id = xrr.report_id and xrr.run_id = xrrpv.run_id and xrpv.parameter_id = xrrpv.parameter_id Y US Report Definition 19 30 :p_as_of_date Date sysdate Y US As of Date 20 40 :p_third_party_id LOV Oracle XLA_SRS_TB_THIRD_PARTY Y select tp.pt_id || '#$' || tp.pt_cd id, tp.pt_nm value, lk.meaning description from ((select vendor_id pt_id,vendor_name pt_nm,'S' pt_cd from ap_suppliers) union all (select hca.cust_account_id pt_id,hp.party_name pt_nm,'C' pt_cd from hz_cust_accounts hca,hz_parties hp where hca.party_id=hp.party_id)) tp,xla_lookups lk where tp.pt_cd=lk.lookup_code and lk.lookup_type='XLA_PARTY_TYPE' order by tp.pt_nm US Third Party Name 21 70 :p_custom_param_2 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 Y Y US Show Transaction Detail 22 &sum_or_detail_cols ,sum(x.src_acctd_rounded_orig_amt) amount ,sum(x.src_acctd_rounded_rem_amt) remaining_amount N US Show Transaction Detail 23 &sum_or_detail_cols ,x.user_trx_identifier_value_3 invoice_number ,x.user_trx_identifier_value_10 invoice_description ,substr(x.user_trx_identifier_value_8,1,10) invoice_date ,x.ledger_currency_code currency ,x.src_acctd_rounded_orig_amt amount ,x.src_acctd_rounded_rem_amt remaining_amount Y US Show Transaction Detail 24 &summary_group_by group by x.account ,x.third_party_name order by 1,2 N US Show Transaction Detail 25 &summary_group_by order by 1,2,3,5 Y US Show Transaction Detail :$flex$.report_definition Report Definition Chart of Accounts :$flex$.xla_srs_subledgers XLA_SRS_SUBLEDGERS Journal Source :$flex$.xla_srs_subledgers XLA_SRS_SUBLEDGERS Report Definition :$flex$.xla_srs_tb_definitions_all Report Definition Journal Source