AP Payables Posted Invoice Register

➜ Back to Library
Description
Categories: BI Publisher, Financials, Procurement
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
P_CUSTOM_PARAMETER_4 
 
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_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
Account Flexfield To 
 
Account Flexfield From 
 
Include Zero Amount Lines 
 
 LOV Oracle
P_JE_SOURCE 
 
 LOV Oracle
Period To 
 
 LOV Oracle
Period From 
 
 LOV Oracle
Ledger/Ledger Set 
 
 LOV Oracle
Operating Unit 
 
 LOV Oracle
Download
Related Blitz Reports
JG Global Journal Ledger
CST Journal Entries Report - Cost Management
JG Global Journals and Third Party
JG Global Daily Journals
JE Italian Journal Ledger
JG Global GL and SLA Account by Journal Lines
JE French Accounting Entries Audit File
AR Sales Journal by GL Account
XLA Account Analysis
JG Global Subledger Detail Journal