ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 1D36E658938807A7E06362FB0905790AY select x.legal_entity, x.operating_unit, x.party_name supplier, x.supplier_number, x.vendor_site_code supplier_site, x.invoice_num invoice_number, x.invoice_status, x.invoice_date, x.invoice_currency_code currency, x.approval_context, x.line_number, x.approval_status, x.action_date, x.action, x.approver_name approver, x.rejected_by, x.applicable_amount, x.amount_approved reviewed_amount, case when :p_sort_by='T' and 1=row_number() over (partition by x.invoice_id order by x.approval_history_id desc nulls last,x.action_date desc) then case when x.wfapproval_status in ('INITIATED','SENT','NEEDS WFREAPPROVAL') then x.invoice_amount else 0 end when :p_sort_by='A' then case when x.action_code in ('SENT') then x.amount_approved else 0 end end pending_amount, case when :p_sort_by='T' and 1=row_number() over (partition by x.invoice_id order by x.approval_history_id desc nulls last,x.action_date desc) then case when x.wfapproval_status in ('REJECTED','REJECT','STOPPED') then x.invoice_amount else 0 end when :p_sort_by='A' then case when x.action_code in ('REJECT','REJECTED','STOPPED') then x.amount_approved else 0 end end rejected_amount, case when :p_sort_by='T' and 1=row_number() over (partition by x.invoice_id order by x.approval_history_id desc nulls last,x.action_date desc) then case when x.wfapproval_status in ('WFAPPROVED','MANUALLY APPROVED') then x.invoice_amount else 0 end when :p_sort_by='A' then case when x.action_code in ('APPROVED','MANUALLY APPROVED') then x.amount_approved else 0 end end approved_amount, &il_reg_columns &il_columns_amt &il_columns_rate &il_columns_rec &il_columns_tp x.approval_history_id from ( select x.legal_entity, x.operating_unit, x.party_name supplier, x.supplier_number, x.vendor_site_code supplier_site, x.invoice_num invoice_number, x.invoice_status, x.invoice_date, x.invoice_currency_code currency, x.approval_context, x.line_number, x.approval_status, x.action_date, x.action, x.approver_name approver, x.rejected_by, x.applicable_amount, x.amount_approved reviewed_amount, x.party_name, x.vendor_id, x.vendor_site_id, x.vendor_site_code, x.wfapproval_status, x.invoice_currency_code, x.invoice_num, x.amount_approved, x.approver_name, x.invoice_id, x.invoice_amount, x.action_code, case when :p_sort_by='T' and 1=row_number() over (partition by x.invoice_id order by x.approval_history_id desc nulls last,x.action_date desc) then case when x.wfapproval_status in ('INITIATED','SENT','NEEDS WFREAPPROVAL') then x.invoice_amount else 0 end when :p_sort_by='A' then case when x.action_code in ('SENT') then x.amount_approved else 0 end end pending_amount, case when :p_sort_by='T' and 1=row_number() over (partition by x.invoice_id order by x.approval_history_id desc nulls last,x.action_date desc) then case when x.wfapproval_status in ('REJECTED','REJECT','STOPPED') then x.invoice_amount else 0 end when :p_sort_by='A' then case when x.action_code in ('REJECT','REJECTED','STOPPED') then x.amount_approved else 0 end end rejected_amount, case when :p_sort_by='T' and 1=row_number() over (partition by x.invoice_id order by x.approval_history_id desc nulls last,x.action_date desc) then case when x.wfapproval_status in ('WFAPPROVED','MANUALLY APPROVED') then x.invoice_amount else 0 end when :p_sort_by='A' then case when x.action_code in ('APPROVED','MANUALLY APPROVED') then x.amount_approved else 0 end end approved_amount, x.approval_history_id from ( ( select -- Q1 By Approver/By Trading Partner - Document Approval xep.name legal_entity, mo_global.get_ou_name(aia.org_id) operating_unit, aia.vendor_id, hp.party_name, aps.segment1 supplier_number, aia.vendor_site_id, assa.vendor_site_code, aia.wfapproval_status, aia.invoice_currency_code, fc.precision, aia.invoice_num, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) invoice_status, aiaha.amount_approved, aiaha.approver_name, case when aiaha.response in ('REJECT','REJECTED') then xxen_util.user_name(aiaha.created_by) end rejected_by, alc2.displayed_field action, aiaha.last_update_date action_date, aiaha.iteration, alc.displayed_field approval_status, aia.invoice_id, aia.invoice_date, aia.invoice_amount, aia.invoice_amount applicable_amount, nvl(alc3.displayed_field,'Document Approval') approval_context, aiaha.response action_code, to_number(null) line_number, aiaha.approval_history_id from ap_inv_aprvl_hist_all aiaha, ap_invoices_all aia, gl_ledgers gl, ap_suppliers aps, ap_supplier_sites_all assa, hz_parties hp, fnd_currencies fc, xle_entity_profiles xep, ap_lookup_codes alc, ap_lookup_codes alc2, ap_lookup_codes alc3 where :p_reporting_level=:p_reporting_level and nvl(:p_status,'?')=nvl(:p_status,'?') and 1=1 and 2=2 and aia.org_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') and aiaha.invoice_id=aia.invoice_id and aia.set_of_books_id=gl.ledger_id and aia.invoice_currency_code=fc.currency_code and hp.party_id=aia.party_id and aps.vendor_id(+)=aia.vendor_id and assa.vendor_site_id(+)=aia.vendor_site_id and xep.legal_entity_id(+)=aia.legal_entity_id and alc.lookup_code=aia.wfapproval_status and alc.lookup_type='AP_WFAPPROVAL_STATUS' and alc2.lookup_code(+)=aiaha.response and alc2.lookup_type(+)='AP_WFAPPROVAL_STATUS' and alc3.lookup_type(+)='AP_WFAPPROVAL_CONTEXT' and alc3.lookup_code(+)=aiaha.history_type and (aiaha.history_type is null or aiaha.history_type='DOCUMENTAPPROVAL' ) union select -- Q2 By Approver/By Trading Partner - Line Approval xep.name legal_entity, mo_global.get_ou_name(aia.org_id) operating_unit, aia.vendor_id, hp.party_name, aps.segment1 supplier_number, aia.vendor_site_id, assa.vendor_site_code, ail.wfapproval_status, aia.invoice_currency_code, fc.precision, aia.invoice_num, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) invoice_status, aiaha.amount_approved, aiaha.approver_name, case when aiaha.response in ('REJECT','REJECTED') then xxen_util.user_name(aiaha.created_by) end rejected_by, alc2.displayed_field action, aiaha.last_update_date action_date, aiaha.iteration, alc.displayed_field approval_status, aia.invoice_id, aia.invoice_date, decode(aia.wfapproval_status,'INITIATED',0,aia.invoice_amount) invoice_amount, ail.amount applicable_amount, alc3.displayed_field approval_context, aiaha.response action_code, aiaha.line_number, aiaha.approval_history_id from ap_inv_aprvl_hist_all aiaha, ap_invoice_lines_all ail, ap_invoices_all aia, gl_ledgers gl, ap_suppliers aps, ap_supplier_sites_all assa, hz_parties hp, fnd_currencies fc, xle_entity_profiles xep, ap_lookup_codes alc, ap_lookup_codes alc2, ap_lookup_codes alc3 where 1=1 and 2=2 and aia.org_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') and aia.invoice_id=ail.invoice_id and aiaha.invoice_id=ail.invoice_id and aiaha.line_number=ail.line_number and aiaha.history_type='LINESAPPROVAL' and aia.set_of_books_id=gl.ledger_id and aia.invoice_currency_code=fc.currency_code and hp.party_id=aia.party_id and alc.lookup_code=ail.wfapproval_status and alc.lookup_type='AP_WFAPPROVAL_STATUS' and aps.vendor_id(+)=aia.vendor_id and assa.vendor_site_id(+)=aia.vendor_site_id and xep.legal_entity_id(+)=aia.legal_entity_id and alc2.lookup_code(+)=aiaha.response and alc2.lookup_type(+)='AP_WFAPPROVAL_STATUS' and alc3.lookup_type(+)='AP_WFAPPROVAL_CONTEXT' and alc3.lookup_code(+)=aiaha.history_type union select --Q3 By Trading Partner xep.name legal_entity, mo_global.get_ou_name(aia.org_id) operating_unit, aia.vendor_id, hp.party_name, aps.segment1 supplier_number, aia.vendor_site_id, assa.vendor_site_code, aia.wfapproval_status, aia.invoice_currency_code, fc.precision, aia.invoice_num, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) invoice_status, 0 amount, 'N/A' approver, null rejected_by, 'Required' action, null action_date, null iteration, 'Required' approval_status, aia.invoice_id, aia.invoice_date, aia.invoice_amount, aia.invoice_amount applicable_amount, 'Invoice Approval' approval_context, 'N/A' action_code, to_number(null) line_number, 0 approval_history_id from ap_invoices_all aia, gl_ledgers gl, ap_suppliers aps, ap_supplier_sites_all assa, hz_parties hp, fnd_currencies fc, xle_entity_profiles xep, ap_lookup_codes alc where :p_sort_by='T' and 1=1 and 3=3 and aia.org_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') and aia.set_of_books_id=gl.ledger_id and aia.invoice_currency_code=fc.currency_code and hp.party_id=aia.party_id and aps.vendor_id(+)=aia.vendor_id and assa.vendor_site_id(+)=aia.vendor_site_id and xep.legal_entity_id(+)=aia.legal_entity_id and alc.lookup_code=aia.wfapproval_status and alc.lookup_type='AP_WFAPPROVAL_STATUS' ) union all select --Q4 Future Approvers xep.name legal_entity, mo_global.get_ou_name(aia.org_id) operating_unit, aia.vendor_id, hp.party_name, aps.segment1 supplier_number, aia.vendor_site_id, assa.vendor_site_code, aia.wfapproval_status, aia.invoice_currency_code, fc.precision, aia.invoice_num, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) invoice_status, awh.amount_approved, listagg(awh.approver_name,''||chr(10)) within group(order by decode(awh.iteration,0,9999,awh.iteration),decode(awh.line_number,null,9999,awh.line_number),awh.last_update_date,awh.approver_order_number) approver_name, null rejected_by, awh.response_dsp action, awh.last_update_date action_date, awh.iteration, xxen_util.meaning(aia.wfapproval_status,'AP_WFAPPROVAL_STATUS',200) approval_status, aia.invoice_id, aia.invoice_date, aia.invoice_amount, aia.invoice_amount applicable_amount, xxen_util.meaning(awh.approval_context,'AP_WFAPPROVAL_CONTEXT',200) approval_context, awh.response action_code, null line_number, null approval_history_id from ap_wfapproval_history_v awh, ap_invoices_all aia, gl_ledgers gl, ap_suppliers aps, ap_supplier_sites_all assa, hz_parties hp, fnd_currencies fc, xle_entity_profiles xep where 1=1 and 2=2 and awh.response='FUTURE' and aia.org_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') and awh.invoice_id=aia.invoice_id and aia.set_of_books_id=gl.ledger_id and aia.invoice_currency_code=fc.currency_code and hp.party_id=aia.party_id and aps.vendor_id(+)=aia.vendor_id and assa.vendor_site_id(+)=aia.vendor_site_id and xep.legal_entity_id(+)=aia.legal_entity_id group by xep.name, mo_global.get_ou_name(aia.org_id), aia.vendor_id, hp.party_name, aps.segment1, aia.vendor_site_id, assa.vendor_site_code, aia.wfapproval_status, aia.invoice_currency_code, fc.precision, aia.invoice_num, awh.amount_approved, awh.response_dsp, awh.last_update_date, awh.iteration, aia.invoice_id, aia.invoice_date, aia.invoice_amount, xxen_util.meaning(awh.approval_context,'AP_WFAPPROVAL_CONTEXT',200), awh.response, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) ) x ) x &il_from where :p_reporting_level=:p_reporting_level &il_where order by x.legal_entity, x.operating_unit, decode(:p_sort_by,'A',x.approver_name,null), decode(:p_sort_by,'A',x.invoice_currency_code,null), decode(:p_sort_by,'A',x.approval_context,null), decode(:p_sort_by,'A',x.action_date,null) desc, decode(:p_sort_by,'T',x.party_name,null), decode(:p_sort_by,'T',x.vendor_site_code,null), decode(:p_sort_by,'T',x.invoice_currency_code,null), x.approval_history_id desc nulls last, x.invoice_date, x.invoice_num, x.action_date desc Operating unit security reads the Blitz Report organization access alone, which already holds the operating unit of an 11i responsibility. XXEN_AP_INV_APRVL_STATUS_PKG AR AP موقف اعتماد الفاتورة Imported from Concurrent Program Application: المدفوعات Source: موقف اعتماد الفاتورة Short Name: APXAPRST D AP Rechnungsgenehmigungsstatus Imported from Concurrent Program Application: Kreditoren Source: Rechnungsgenehmigungsstatus Short Name: APXAPRST E AP Estado de Aprobación de Facturas Imported from Concurrent Program Application: Payables Source: Estado de Aprobación de Facturas Short Name: APXAPRST F AP Statut d'approbation des factures Imported from Concurrent Program Application: Payables Source: Statut d'approbation des factures Short Name: APXAPRST I AP Stato approvazione fattura Imported from Concurrent Program Application: Payables Source: Stato approvazione fattura Short Name: APXAPRST JA AP 請求書承認ステータス Imported from Concurrent Program Application: Payables Source: 請求書承認ステータス Short Name: APXAPRST KO AP 송장 승인 상태 Imported from Concurrent Program Application: Payables Source: 송장 승인 상태 Short Name: APXAPRST PTB AP Status de Aprovação da NFF Imported from Concurrent Program Application: Payables Source: Status de Aprovação da NFF Short Name: APXAPRST RU AP Статус утверждения счета-фактуры Imported from Concurrent Program Application: Кредиторы Source: Статус утверждения счета-фактуры Short Name: APXAPRST S AP Godkännandestatus för faktura Imported from Concurrent Program Application: Payables Source: Godkännandestatus för faktura Short Name: APXAPRST TR AP Fatura Onay Statüsü Imported from Concurrent Program Application: Borçlar Muhasebesi Source: Fatura Onay Statüsü Short Name: APXAPRST US AP Invoice Approval Status Imported from Concurrent Program Application: Payables Source: Invoice Approval Status Short Name: APXAPRST When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, CGST Rate, SGST Rate, IGST Rate, CESS Rate, CGST Recoverable, CGST Non-Recoverable, SGST Recoverable, SGST Non-Recoverable, IGST Recoverable, IGST Non-Recoverable, Reverse Charge Flag, Place of Supply, Ship From State. The Rejected By column shows the user who recorded a rejection: the user who rejected the invoice, or, for an invoice rejected automatically because the approval request timed out, the user that submits the Workflow Background Process (typically SYSADMIN). ZHS AP 发票审批状态 Imported from Concurrent Program Application: 应付帐款 Source: 发票审批状态 Short Name: APXAPRST Enginatics R12 only &il_columns_amt &il_columns_rate &il_columns_rec &il_columns_tp &il_from &il_reg_columns &il_where 1=1 2=2 3=3 :p_approver :p_invoice_date_from :p_invoice_date_to :p_party_id :p_reporting_entity :p_reporting_level :p_sessionid :p_sort_by :p_status :p_vendor_site_id 1 -20 1=1 :India_Localization=:India_Localization Char Y xxen_util.jai_installed US India Localization 2 &il_columns_amt il_tax.cgst_amount "CGST Amount", il_tax.sgst_amount "SGST Amount", il_tax.igst_amount "IGST Amount", il_tax.cess_amount "CESS Amount", il_tax.custom_amount "Custom Amount", il_tax.unclassified_amount "Unclassified Tax Amount", il_tax.taxable_value "Taxable Value", il_tax.hsn_sac_code "HSN SAC Code", Y US India Localization 3 &il_columns_rate il_tax.cgst_tax_rate "CGST Rate", il_tax.sgst_tax_rate "SGST Rate", il_tax.igst_tax_rate "IGST Rate", il_tax.cess_tax_rate "CESS Rate", Y US India Localization 4 &il_columns_rec il_tax.cgst_rec_amount "CGST Recoverable", il_tax.cgst_nrec_amount "CGST Non-Recoverable", il_tax.sgst_rec_amount "SGST Recoverable", il_tax.sgst_nrec_amount "SGST Non-Recoverable", il_tax.igst_rec_amount "IGST Recoverable", il_tax.igst_nrec_amount "IGST Non-Recoverable", Y US India Localization 5 &il_columns_tp xxen_util.meaning(il_tax.reverse_charge_flag,'YES_NO',0) "Reverse Charge Flag", (select max(jtdf.ship_to_state) from jai_tax_det_factors jtdf where jtdf.trx_id=x.invoice_id and jtdf.application_id=200) "Place of Supply", (select max(jtdf.ship_from_state) from jai_tax_det_factors jtdf where jtdf.trx_id=x.invoice_id and jtdf.application_id=200) "Ship From State", Y US India Localization 6 &il_from ,(select jpr.party_id, jpr.party_site_id, coalesce(max(case when jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.registration_type_code in ('GST','GSTIN') then nvl(jprl.registration_number,jprl.secondary_registration_number) end),max(case when regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),'^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') then nvl(jprl.registration_number,jprl.secondary_registration_number) end)) gstin, max(decode(jprl.registration_type_code,'PAN',jprl.registration_number)) pan_site, max(decode(jprl.registration_type_code,'TAN',jprl.registration_number)) tan_site, max(decode(jprl.sec_registration_type_code,'PAN',jprl.secondary_registration_number)) sec_pan_site, max(decode(jprl.sec_registration_type_code,'TAN',jprl.secondary_registration_number)) sec_tan_site from jai_party_regs_v jpr, jai_party_reg_lines_v jprl where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='THIRD_PARTY_SITE' and jpr.supplier_flag='Y' and jprl.effective_from<=sysdate and (jprl.effective_to is null or jprl.effective_to>=sysdate) group by jpr.party_id, jpr.party_site_id) il_reg_site ,(select jpr.party_id, coalesce(max(case when jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.registration_type_code in ('GST','GSTIN') then nvl(jprl.registration_number,jprl.secondary_registration_number) end),max(case when regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),'^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') then nvl(jprl.registration_number,jprl.secondary_registration_number) end)) gstin_hdr, max(decode(jprl.registration_type_code,'PAN',jprl.registration_number)) pan_hdr, max(decode(jprl.registration_type_code,'TAN',jprl.registration_number)) tan_hdr, max(decode(jprl.sec_registration_type_code,'PAN',jprl.secondary_registration_number)) sec_pan_hdr, max(decode(jprl.sec_registration_type_code,'TAN',jprl.secondary_registration_number)) sec_tan_hdr from jai_party_regs_v jpr, jai_party_reg_lines_v jprl where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='THIRD_PARTY' and jpr.supplier_flag='Y' and jprl.effective_from<=sysdate and (jprl.effective_to is null or jprl.effective_to>=sysdate) group by jpr.party_id) il_reg_hdr ,(select jtlv.trx_id, sum(decode(jrav.reporting_code,'CGST',jtlv.rounded_tax_amt_trx_curr)) cgst_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rounded_tax_amt_trx_curr)) sgst_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rounded_tax_amt_trx_curr)) igst_amount, sum(decode(jrav.reporting_code,'CESS',jtlv.rounded_tax_amt_trx_curr)) cess_amount, sum(decode(jrav.reporting_code,'CUSTOM',jtlv.rounded_tax_amt_trx_curr)) custom_amount, sum(decode(jrav.reporting_code,null,jtlv.rounded_tax_amt_trx_curr)) unclassified_amount, max(decode(jrav.reporting_code,'CGST',jtlv.tax_rate_code)) cgst_tax_rate, max(decode(jrav.reporting_code,'SGST',jtlv.tax_rate_code)) sgst_tax_rate, max(decode(jrav.reporting_code,'IGST',jtlv.tax_rate_code)) igst_tax_rate, max(decode(jrav.reporting_code,'CESS',jtlv.tax_rate_code)) cess_tax_rate, sum(decode(jrav.reporting_code,'CGST',jtlv.rec_tax_amt_trx_curr)) cgst_rec_amount, sum(decode(jrav.reporting_code,'CGST',jtlv.nrec_tax_amt_trx_curr)) cgst_nrec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rec_tax_amt_trx_curr)) sgst_rec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.nrec_tax_amt_trx_curr)) sgst_nrec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rec_tax_amt_trx_curr)) igst_rec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.nrec_tax_amt_trx_curr)) igst_nrec_amount, max(jtlv.self_assessed_flag) reverse_charge_flag, sum(decode(jrav.reporting_code,'CGST',jtlv.rounded_taxable_amt_trx_curr,'IGST',jtlv.rounded_taxable_amt_trx_curr)) taxable_value, max(jrc.reporting_code) hsn_sac_code from jai_tax_lines_v jtlv, jai_reporting_associations_v jrav, jai_tax_det_factors jtdf, jai_reporting_codes jrc where jrav.entity_id(+)=jtlv.tax_type_id and jrav.entity_code(+)='TAX_TYPE' and jrav.reporting_type_code(+)='TAX_TYPES_CLASSIFICATION' and jtlv.det_factor_id=jtdf.det_factor_id(+) and jtdf.application_id(+)=200 and nvl(jtdf.hsn_code_id,jtdf.sac_code_id)=jrc.reporting_code_id(+) and jtlv.application_id=200 group by jtlv.trx_id ) il_tax Y US India Localization 7 &il_reg_columns nvl(il_reg_site.gstin,il_reg_hdr.gstin_hdr) "GST Registration No", nvl(il_reg_site.pan_site,nvl(il_reg_site.sec_pan_site,nvl(il_reg_hdr.pan_hdr,il_reg_hdr.sec_pan_hdr))) "GST PAN No", nvl(il_reg_site.tan_site,nvl(il_reg_site.sec_tan_site,nvl(il_reg_hdr.tan_hdr,il_reg_hdr.sec_tan_hdr))) "GST TAN No", Y US India Localization 8 &il_where and x.vendor_site_id=il_reg_site.party_site_id(+) and x.vendor_id=il_reg_hdr.party_id(+) and x.invoice_id=il_tax.trx_id(+) Y US India Localization 9 10 :p_reporting_level LOV Oracle FND_MO_REPORTING_LEVEL select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FND_MO_REPORTING_LEVEL' and lookup_code in (1000,3000) order by value,description 1000 Y AR مستوى إعداد التقرير D Auswertungsebene E Nivel de Informe F Niveau de reporting I Livello dichiarazione JA レポート・レベル KO 보고 레벨 PTB Nível do Relatório RU Уровень отчетности S Rapporteringsnivå TR Raporlama Düzeyi US Reporting Level ZHS 申报级别 10 20 1=1 decode(:p_reporting_level,1000,gl.name,3000,mo_global.get_ou_name(aia.org_id),null)=:p_reporting_entity LOV custom select entity_name value, null description from fnd_mo_reporting_entities_v where reporting_level=:$flex$.fnd_mo_reporting_level and ( :$flex$.fnd_mo_reporting_level='1000' and ledger_category_code='PRIMARY' or :$flex$.fnd_mo_reporting_level='3000' ) order by value SELECT entity_name, entity_id FROM FND_MO_REPORTING_ENTITIES_V WHERE reporting_level = :$flex$.reporting_level and rownum=1 AR سياق إعداد التقرير D Auswertungskontext E Contexto del Informe F Contexte de reporting I Contesto dichiarazione JA レポート・コンテキスト KO 보고 컨텍스트 PTB Contexto do Relatório RU Контекст отчетности S Rapporteringssammanhang TR Raporlama İçeriği US Reporting Context ZHS 申报环境 11 30 :p_sort_by LOV custom select decode(ffvv.flex_value,'Approver','A','T') id, ffvv.flex_value value, ffvv.flex_value_meaning description from fnd_flex_value_sets ffvs, fnd_flex_values_vl ffvv where ffvs.flex_value_set_name = 'APXAPRST_SORT_BY' and ffvs.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag = 'Y' order by ffvv.flex_value SELECT ffvt.flex_value_meaning FROM fnd_flex_value_sets ffvs, fnd_flex_values ffv, fnd_flex_values_tl ffvt WHERE ffvs.flex_value_set_name= 'APXAPRST_SORT_BY' AND ffvs.flex_value_set_id = ffv.flex_value_set_id AND ffv.flex_value_id = ffvt.flex_value_id AND ffvt.language = userenv ('lang') AND ffv.flex_value = 'Trading Partner' Y AR فرز حسب D Sortieren nach E Ordenar por F Trier par I Ordina per JA ソート・キー KO 정렬 기준 PTB Classificar por RU Сортировка S Sortera efter TR Sıralama Esası US Sort By ZHS 排序依据 12 40 1=1 aia.party_id=:p_party_id LOV Oracle AP_SRS_PARTY_NAME select party_id id, party_name value, null description from hz_parties hp where exists (select 'Payee Party' from iby_external_payees_v ibp where ibp.payee_party_id=hp.party_id and payment_function in ('PAYABLES_DISB','EMPLOYEE_EXP','LOANS_PAYMENTS','AR_CUSTOMER_REFUNDS')) order by value,description AR الشريك التجاري D Geschäftspartner E Partner Comercial F Partenaire commercial I Partner commerciale JA 取引先 KO 거래처 PTB Parceiro Comercial RU Торговый партнер S Handelspartner TR Ticari Ortak US Trading Partner ZHS 贸易伙伴 13 50 1=1 aia.vendor_site_id=:p_vendor_site_id LOV Oracle AP_SRS_APXAPRST_SUPPLIER_SITE select pvs.vendor_site_id id, pvs.vendor_site_code value, null description from po_vendor_sites pvs,po_vendors pv where pvs.vendor_id=pv.vendor_id and pv.party_id=:$flex$.ap_srs_party_name order by vendor_site_code AR موقع المورد D Lieferantenadresse E Sitio del Proveedor F Site fournisseur I Sede fornitore JA 仕入先サイト KO 공급자 지점 PTB Local do Fornecedor RU Отделение поставщика S Leverantörsplats TR Tedarikçi İşletme Birimi US Supplier Site ZHS 供应商地点 14 60 1=1 exists (select aiaha.invoice_id from ap_inv_aprvl_hist_all aiaha where aiaha.invoice_id = aia.invoice_id and (aiaha.approver_id = :p_approver or (aiaha.approver_id is null and aiaha.approver_name in (select hecv.full_name from hr_employees_current_v hecv where hecv.employee_id = :p_approver) ) ) ) LOV HR Current Employee 2E4C8229B5C94AC69A58972558BC2F09 select hecv.employee_id id, hecv.full_name value, hecv.employee_num description from hr_employees_current_v hecv order by upper(hecv.full_name) AR المُعتمِد D Genehmigungsberechtigter E Aprobador F Approbateur I Approvatore JA 承認者 KO 승인자 PTB Aprovador RU Утверждающий S Godkännare TR Onaylayan US Approver ZHS 审批人 15 70 1=1 aia.invoice_date>=:p_invoice_date_from Date AR من تاريخ الفاتورة D Von Rechnungsdatum E De Fecha de Factura F Date de facture - Du I Data fattura - Da JA 請求書日付:自 KO 송장 일자:부터 PTB Data da NFF - De RU Дата счета-фактуры с S Från fakturadatum TR Fatura Başlangıç Tarihi US Invoice Date From ZHS 起始发票日期 16 80 1=1 aia.invoice_date<:p_invoice_date_to+1 Date last_day(:$flex$.invoice_date_from) Y AR إلى تاريخ الفاتورة D Bis Rechnungsdatum E A Fecha de Factura F Date de facture - Au I Data fattura - A JA 請求日:至 KO 송장 일자:까지 PTB Data da NFF - Até RU Дата счета-фактуры по S Till fakturadatum TR Fatura Bitiş Tarihi US Invoice Date To ZHS 终止发票日期 17 90 :p_status LOV AP Approval Status 462504C3A89E069EE0630100007F4F7A select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv, fnd_flex_value_sets ffvs where ffvs.flex_value_set_id=ffvv.flex_value_set_id and ffvs.flex_value_set_name='AP_APPROVAL_STATUS' union all select 'Unapproved' as id, 'Unapproved' as value, 'Unapproved: Needs Reapproval, Pending, Rejected' as description from dual order by 2 SELECT ffvt.flex_value_meaning FROM fnd_flex_value_sets ffvs, fnd_flex_values ffv, fnd_flex_values_tl ffvt WHERE ffvs.flex_value_set_name= 'AP_APPROVAL_STATUS' AND ffvs.flex_value_set_id = ffv.flex_value_set_id AND ffv.flex_value_id = ffvt.flex_value_id AND ffvt.language = userenv ('lang') AND ffv.flex_value = 'Pending or Rejected' Y AR الموقف D Status E Estado F Statut I Stato JA ステータス KO 상태 PTB Status RU Статус S Status TR Statü US Approval Status ZHS 状态 18 2=2 aia.wfapproval_status in ('WFAPPROVED','MANUALLY APPROVED','REJECTED','INITIATED','NEEDS WFREAPPROVAL') All US Approval Status 19 2=2 aia.wfapproval_status in ('WFAPPROVED','MANUALLY APPROVED') Approved US Approval Status 20 2=2 aia.wfapproval_status = 'NEEDS WFREAPPROVAL' Needs Reapproval US Approval Status 21 2=2 aia.wfapproval_status in ('REJECTED','INITIATED') Pending or Rejected US Approval Status 22 2=2 aia.wfapproval_status = 'REJECTED' Rejected US Approval Status 23 2=2 aia.wfapproval_status in ('REJECTED','INITIATED','NEEDS WFREAPPROVAL') Unapproved US Approval Status 24 3=3 aia.wfapproval_status in ('REQUIRED','REJECTED') All US Approval Status 25 3=3 aia.wfapproval_status = 'No Status' Approved US Approval Status 26 3=3 aia.wfapproval_status = 'No Status' Needs Reapproval US Approval Status 27 3=3 aia.wfapproval_status in ('REQUIRED','REJECTED') Pending or Rejected US Approval Status 28 3=3 aia.wfapproval_status = 'REJECTED' Rejected US Approval Status 29 3=3 aia.wfapproval_status in ('REQUIRED','REJECTED') Unapproved US Approval Status A5CCA7CCD0AFE68281D6AAA59314ACEE By Approver SYSADMIN 14 ACTION 13 ACTION_DATE -7 16 APPLICABLE_AMOUNT 9 APPROVAL_CONTEXT 5 12 APPROVAL_STATUS 19 APPROVED_AMOUNT 3 APPROVER 3 -18.0022 CESS Amount -18.0028 CESS Rate -18.0019 CGST Amount -18.003 CGST Non-Recoverable -18.0025 CGST Rate -18.0029 CGST Recoverable 4 CURRENCY 4 Y -18.0023 Custom Amount -18.0039 GST PAN No -18.0038 GST Registration No -18.004 GST TAN No -18.0042 HSN SAC Code -18.0021 IGST Amount -18.0034 IGST Non-Recoverable -18.0027 IGST Rate -18.0033 IGST Recoverable -6.0007 INVOICE_AMOUNT 5 INVOICE_DATE 6 INVOICE_NUMBER 11 INVOICE_STATUS 1 LEGAL_ENTITY 1 10 LINE_NUMBER 2 OPERATING_UNIT 2 17 PENDING_AMOUNT -18.0036 Place of Supply 18 REJECTED_AMOUNT 15 REJECTED_BY -18.0035 Reverse Charge Flag -18.002 SGST Amount -18.0032 SGST Non-Recoverable -18.0026 SGST Rate -18.0031 SGST Recoverable -11.0012 STATUS 7 SUPPLIER 8 SUPPLIER_SITE -18.0037 Ship From State -18.0041 Taxable Value -18.0024 Unclassified Tax Amount Sort By A S Site 82D96C35BE5669307655CEA1EBC200F9 By Trading Partner SYSADMIN 12 ACTION 11 ACTION_DATE -8 10 APPROVAL_STATUS 18 APPROVED_AMOUNT 13 APPROVER -17.0021 CESS Amount -17.0027 CESS Rate -17.0018 CGST Amount -17.0029 CGST Non-Recoverable -17.0024 CGST Rate -17.0028 CGST Recoverable 5 CURRENCY 5 Y -17.0022 Custom Amount -17.0038 GST PAN No -17.0037 GST Registration No -17.0039 GST TAN No -17.0041 HSN SAC Code -17.002 IGST Amount -17.0033 IGST Non-Recoverable -17.0026 IGST Rate -17.0032 IGST Recoverable -7.0008 INVOICE_AMOUNT 6 INVOICE_DATE 6 7 INVOICE_NUMBER 7 9 INVOICE_STATUS 1 LEGAL_ENTITY 1 8 LINE_NUMBER 2 OPERATING_UNIT 2 16 PENDING_AMOUNT -17.0035 Place of Supply 17 REJECTED_AMOUNT 14 REJECTED_BY 15 REVIEWED_AMOUNT -17.0034 Reverse Charge Flag -17.0019 SGST Amount -17.0031 SGST Non-Recoverable -17.0025 SGST Rate -17.003 SGST Recoverable -9.001 STATUS 3 SUPPLIER 3 4 SUPPLIER_SITE 4 -17.0036 Ship From State -17.004 Taxable Value -17.0023 Unclassified Tax Amount S Site PIYUSH.KHANDELWAL A5CCA7CCD0AFE68281D6AAA59314ACEE