AP Payables Posted Payment Register

Description
Categories: Enginatics
Repository: Github
Application: Payables
Description: Payables Posted Payment Register

This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report.

Templates
- Pivot: Summary by Account
Equivalent to standard report in Summarize Report = Yes Mode
- Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document
Equi ... 
Application: Payables
Description: Payables Posted Payment Register

This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report.

Templates
- Pivot: Summary by Account
Equivalent to standard report in Summarize Report = Yes Mode
- Pivot: Summary by Account, Bank Account, Batch, Payment Currency, Payment Document
Equivalent to standard report in Summarize=No Order By=Bank Account
- Pivot: Summary by Account, Batch, Bank Account, Payment Currency, Payment Document
Equivalent to standard report in Summarize=No Order By=Journal Entry Batch
- Detail
Provides detail listing of the posted payments

Additional data fields are available. Run the report without a template to see full list available fields


Source: Payables Posted Payment Register
Short Name: APXPOPMT
DB package: XLA_JELINES_RPT_PKG
   more
Run AP Payables Posted Payment Register and other Oracle EBS reports with Blitz Report™ on our demo environment
select
 x.application_name
,x.ledger_short_name
,x.ledger_description
,x.ledger_name
,x.ledger_currency
-- posting account data
,x.accounting_code_combination  account
,x.code_combination_description account_description
,x.control_account_flag
-- gl data
,x.period_name
,x.gl_date
,x.gl_batch_name
,x.je_source_name     gl_journal_source
,x.je_category_name   gl_journal_category
,x.gl_je_name         gl_journal_name
,x.gl_line_number     gl_journal_line_num
,x.header_description
,x.line_description
-- amounts
,x.entered_currency payment_currency
,x.entered_dr
,x.entered_cr
,x.unrounded_accounted_dr
,x.unrounded_accounted_cr
,x.accounted_dr
,x.accounted_cr
,x.statistical_amount
-- source transaction data
,x.user_trx_identifier_value_10 supplier_name
,x.transaction_number           payment_number
,x.transaction_date             payment_date
,to_number(x.user_trx_identifier_value_9)  payment_amount
,nvl(x.bank_account_num,x.user_trx_identifier_value_3)
                                bank_account_num
,x.bank_account_name
,x.user_trx_identifier_value_5  payment_document
-- other gl specific data
,x.gl_default_effective_date
,x.gl_batch_status
,x.posted_date        gl_posted_date
,x.external_reference gl_external_reference
,x.reference_1        gl_reference_1
,x.reference_4        gl_reference_4
,x.gl_doc_sequence_name
,x.gl_doc_sequence_value
-- other date, status, type data
,x.gl_transfer_date
,x.reference_date
,x.completed_date
,x.journal_entry_status
,x.transfer_to_gl_status
,x.balance_type_code
,x.balance_type
,x.budget_name
,x.encumbrance_type
,x.fund_status
-- sla specific data
,x.event_date                        sla_event_date
,x.event_number                      sla_event_number
,x.event_class_code                  sla_event_class_code
,x.event_class_name                  sla_event_class_name
,x.event_type_code                   sla_event_type_code
,x.event_type_name                   sla_event_type_name
,nvl2(x.event_id,x.line_number,null) sla_line_number
,x.accounting_class_code             sla_accounting_class_code
,x.accounting_class_name             sla_accounting_class_name
,x.accounting_sequence_name          sla_accounting_seq_name
,x.accounting_sequence_version       sla_accounting_seq_version
,x.accounting_sequence_number        sla_accounting_seq_number
,x.reporting_sequence_name           sla_reporting_seq_name
,x.reporting_sequence_version        sla_reporting_seq_version
,x.reporting_sequence_number         sla_reporting_seq_number
,x.document_category                 sla_document_category
,x.document_sequence_name            sla_document_seq_name
,x.document_sequence_number          sla_document_seq_number
-- period data points
,x.period_year
,x.period_number
,x.period_start_date
,x.period_end_date
,x.period_year_start_date
,x.period_year_end_date
-- exchange type/rate data
,x.conversion_rate
,x.conversion_rate_date
,x.conversion_rate_type_code
,x.conversion_rate_type
,x.reconciliation_reference
,x.party_type_code
,x.party_type
-- sla or gl line attributes
,x.attribute_category
,x.attribute1
,x.attribute2
,x.attribute3
,x.attribute4
,x.attribute5
,x.attribute6
,x.attribute7
,x.attribute8
,x.attribute9
,x.attribute10
-- sla trx identifiers
,x.user_trx_identifier_name_1
,x.user_trx_identifier_value_1
,x.user_trx_identifier_name_2
,x.user_trx_identifier_value_2
,x.user_trx_identifier_name_3
,x.user_trx_identifier_value_3
,x.user_trx_identifier_name_4
,x.user_trx_identifier_value_4
,x.user_trx_identifier_name_5
,x.user_trx_identifier_value_5
,x.user_trx_identifier_name_6
,x.user_trx_identifier_value_6
,x.user_trx_identifier_name_7
,x.user_trx_identifier_value_7
,x.user_trx_identifier_name_8
,x.user_trx_identifier_value_8
,x.user_trx_identifier_name_9
,x.user_trx_identifier_value_9
,x.user_trx_identifier_name_10
,x.user_trx_identifier_value_10
-- sla or gl audit colummns
,x.created_by
,x.creation_date
,x.last_update_date
--
,x.accounting_code_combination || ' (' || x.code_combination_description || ')' account_pivot_label
,nvl(x.bank_account_num,x.user_trx_identifier_value_3) || ' (' || x.bank_account_name || ')' bank_account_pivot_label
from
(select
   &p_main_col_start
   &p_uti_col
   &lp_template_columns
 from
   (&lp_template_table
    &p_sla_col_1
    &p_gl_columns
    &p_sla_col_2
    &p_party_details
    &p_sla_qualifier_segment
    &p_sla_col_3
    &p_trx_identifiers_1
    &p_trx_identifiers_2
    &p_trx_identifiers_3
    &p_trx_identifiers_4
    &p_trx_identifiers_5
    &lp_sla_userids2
    &p_sla_legal_ent_col
    &p_sla_from
    &p_sla_seg_desc_from
    &p_gl_view
    &p_sla_legal_ent_from
    &p_party_from
    &p_sla_join
    &p_sla_seg_desc_join
    &p_other_param_filter
    &p_gl_join
    &p_sla_legal_ent_join
    &p_party_join
    &p_union_all
    &p_gl_col_1
    &p_gl_party_details
    &p_gl_qualifier_segment
    &p_gl_col_2
    &lp_gl_userids2
    &p_gl_legal_ent_col
    &p_gl_from
    &p_gl_seg_desc_from
    &p_gl_legal_ent_from
    &p_gl_where
    &p_gl_seg_desc_join
    &p_gl_legal_ent_join
    &p_other_union
   ) table1
   &p_le_from
   &p_other_from
 where
   1=1
   &p_le_join
   &p_other_join
) x
Parameter Name SQL text Validation
Operating Unit
 
LOV Oracle
Ledger/Ledger Set
 
LOV Oracle
Period From
 
LOV Oracle
Period To
 
LOV Oracle
Journal Source
 
LOV Oracle
Include Zero Amount Lines
 
LOV Oracle
Account Flexfield From
 
LOV
Account Flexfield To
 
LOV
Bank Account
 
LOV Oracle
GL Batch Name
 
LOV
Include Manual Entries from GL
 
LOV Oracle