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 Name SQL text Validation
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 
 
 Char
Account Flexfield To 
 
 Char
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™

Blitz Report™ provides multiple benefits: