AP Payables Posted Invoice Register

➜ Back to Library
Description
Categories: BI Publisher
Application: Payables
Source: Payables Posted Invoice Register
Short Name: APXPOINV
DB package: XLA_JELINES_RPT_PKG
        SELECT
                &p_main_col_start
                &p_uti_col
              , 'ENTERED_CURRENCY' ENTERED_CURRENCY_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
             , ENTERED_CURRENCY
             , GL_BATCH_NAME
             , USER_TRX_IDENTIFIER_VALUE_1
             , TRANSACTION_NUMBER
Parameter NameSQL textValidation
Operating Unit
 
LOV Oracle
Ledger/Ledger Set
 
LOV Oracle
Period From
 
LOV Oracle
Period To
 
LOV Oracle
P_JE_SOURCE
 
LOV Oracle
Include Zero Amount Lines
 
LOV Oracle
Account Flexfield From
 
Account Flexfield To
 
GL Batch Name
 
LOV Oracle
Order By
 
LOV Oracle
Summarize Report
 
LOV Oracle
Include Manual Entries from GL
 
LOV Oracle
XLA_SRS_SUBLEDGERS
 
LOV Oracle
P_LEDGER
 
XLA_SRS_CHART_OF_ACCOUNTS
 
LOV Oracle
P_GL_DATE_FROM
 
Date
P_GL_DATE_TO
 
Date
Journal Entry Status
 
LOV Oracle
P_JE_STATUS
 
Posted
 
LOV Oracle
P_POSTING_STATUS
 
Journal Source
 
Process Category
 
P_PROCESS_CATEGORY
 
XLA_SRS_NO_VALIDATION
 
P_EVENT_CLASS
 
Balance Type
 
LOV Oracle
P_INCLUDE_ZERO_AMOUNT_LINES
 
P_SIDE
 
Include User Transaction Identifiers
 
LOV Oracle
P_INCLUDE_USER_TRX_IDENTIFIERS
 
P_INCLUDE_TAX_DETAILS_FLAG
 
LOV Oracle
P_INCLUDE_TAX_DETAILS
 
P_INCLUDE_LE_INFO_FLAG
 
LOV Oracle
P_INCLUDE_LEGAL_ENTITY_INFO
 
P_TRANSACTION_VIEW
 
P_POST_ACCT_PROGRAM_ROWID
 
AP_SRS_YES_NO_OPT
 
LOV Oracle
P_ORDER_BY
 
P_CUSTOM_PARAMETER_4
 
Download
Related Blitz Reports
XLA Account Analysis JG Global Journal Ledger JG Global Daily Journals JG Global GL and SLA Account by Journal Lines JG Global GL and SLA Account Analysis AP Payables Posted Payment Register CST Journal Entries Report - Cost Management AR Sales Journal by GL Account XLA Journal Entries
Blitz Report In Action
Blitz Report™