AP Payables Posted Payment Register

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Payables Posted Payment Register
Short Name: APXPOPMT
DB package: XLA_JELINES_RPT_PKG
        SELECT
                &p_main_col_start
                &p_uti_col
              , 'GL_BATCH_NAME' GL_BATCH_NAME_MODE
        FROM
              (&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
               &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
               &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
          AND  :L_RUN_DETAILED_MODE_2 = 'Y'
               &p_trx_id_filter
               &p_le_join
               &p_other_join
     order by  ACCOUNTING_CODE_COMBINATION
             , GL_BATCH_NAME
             , USER_TRX_IDENTIFIER_VALUE_3
             , ENTERED_CURRENCY
             , USER_TRX_IDENTIFIER_VALUE_5
             , TRANSACTION_NUMBER
Parameter Name SQL text Validation
P_CUSTOM_PARAMETER_4
 
BANK ACCOUNT FILTER
 
P_ORDER_BY
 
AP_SRS_YES_NO_OPT
 
LOV Oracle
P_POST_ACCT_PROGRAM_ROWID
 
P_TRANSACTION_VIEW
 
P_INCLUDE_LEGAL_ENTITY_INFO
 
P_INCLUDE_LE_INFO_FLAG
 
LOV Oracle
P_INCLUDE_TAX_DETAILS
 
P_INCLUDE_TAX_DETAILS_FLAG
 
LOV Oracle
P_INCLUDE_USER_TRX_IDENTIFIERS
 
Include User Transaction Identifiers
 
LOV Oracle
P_SIDE
 
P_INCLUDE_ZERO_AMOUNT_LINES
 
Balance Type
 
LOV Oracle
P_EVENT_CLASS
 
XLA_SRS_NO_VALIDATION
 
P_PROCESS_CATEGORY
 
Process Category
 
Journal Source
 
P_JE_SOURCE
 
LOV Oracle
P_POSTING_STATUS
 
Posted
 
LOV Oracle
P_JE_STATUS
 
Journal Entry Status
 
LOV Oracle
P_GL_DATE_TO
 
Date
P_GL_DATE_FROM
 
Date
XLA_SRS_CHART_OF_ACCOUNTS
 
LOV Oracle
P_LEDGER
 
XLA_SRS_SUBLEDGERS
 
LOV Oracle
Include Manual entries from GL
 
LOV Oracle
Summarize Report
 
LOV Oracle
Order By
 
LOV Oracle
GL Batch Name
 
LOV Oracle
Bank Account
 
LOV Oracle
Account Flexfield To
 
Account Flexfield From
 
Include Zero Amount Lines
 
LOV Oracle
Period To
 
LOV Oracle
Period From
 
LOV Oracle
Ledger/Ledger Set
 
LOV Oracle
Operating Unit
 
LOV Oracle