EOS ARAP

Description

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
gl.name ledger,
--xal.ledger_id,
hou.name operating_unit,
aps.vendor_name,
aia.invoice_num,
xxen_util.user_name(aia.created_by) created_by,
aia.invoice_currency_code,
aia.invoice_amount,
aia.total_tax_amount,
aila.line_number,
aida.distribution_line_number,
decode(aila.deferred_acctg_flag,'Y',xxen_util.meaning(aila.deferred_acctg_flag,'YES_NO',0)) deferred_option,
aila.def_acctg_start_date deferred_start_date,
aila.def_acctg_end_date deferred_end_date,
aila.deferred_months,
aida.amount inv_distr_amount,
xah.period_name,
gp.period_year||'-'||gp.period_num||' '||xah.period_name period_name_label,
xal.ae_line_num,
gp.period_year,
gp.period_num,
xal.accounting_class_code,
gcck.concatenated_segments,
aida.posted_flag,
xal.entered_dr,
xal.entered_cr,
xal.accounted_dr,
xal.accounted_cr
from
gl_ledgers gl,
hr_operating_units hou,
ap_suppliers aps,
ap_invoices_all aia,
(select months_between(trunc(aila.def_acctg_end_date,'month'),trunc(aila.def_acctg_start_date,'month'))+1 deferred_months, aila.* from ap_invoice_lines_all aila) aila,
ap_invoice_distributions_all aida,
xla_distribution_links xdl,
xla_ae_lines xal,
xla_ae_headers xah,
gl_code_combinations_kfv gcck,
gl_periods gp
where
--aia.invoice_num='MPA_TEST2' and
1=1 and
gl.ledger_id=xal.ledger_id and
aila.deferred_acctg_flag='Y' and
hou.organization_id=aia.org_id and
aps.vendor_id=aia.vendor_id and
aia.invoice_id=aila.invoice_id(+) and
aila.invoice_id=aida.invoice_id(+) and
aila.line_number=aida.invoice_line_number(+) and
aida.invoice_distribution_id=xdl.source_distribution_id_num_1 and
xdl.application_id=200 and
xdl.source_distribution_type='AP_INV_DIST' and
xdl.application_id=xal.application_id and
xdl.ae_header_id=xal.ae_header_id and
xdl.ae_line_num=xal.ae_line_num and
xal.accounting_class_code='PREPAID_EXPENSE' and
xal.application_id=xah.application_id and
xal.ae_header_id=xah.ae_header_id and
xal.code_combination_id=gcck.code_combination_id and
xah.period_name=gp.period_name and
gl.period_set_name=gp.period_set_name
order by
aia.invoice_id,
aila.line_number,
aida.distribution_line_number,
gp.period_year,
gp.period_num,
xal.ae_line_num
Parameter Name SQL text Validation
Ledger
gl.ledger_id in (select nvl(glsnav.ledger_id,gl0.ledger_id) from gl_ledgers gl0, gl_ledger_set_norm_assign_v glsnav where gl0.name=:ledger and gl0.ledger_id=glsnav.ledger_set_id(+))
LOV