AP Payables Posted Invoice Register

Description

Categories: BI Publisher, Financials, Procurement

Application: Payables
Source: Payables Posted Invoice Register
Short Name: APXPOINV
DB package: XLA_JELINES_RPT_PKG

Copy

        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

CST Journal Entries Report - Cost Management JG Global Journals and Third Party 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 XLA Account Analysis XLA Journal Entries