AP Payables Posted Invoice Register
Description
Categories: BI Publisher
Application: Payables
Source: Payables Posted Invoice Register
Short Name: APXPOINV
DB package: XLA_JELINES_RPT_PKG
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 | |||
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 |