Results for “source_table”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AR_CORRECT_GL_LINES_V is a read-only view owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) product family and exposes general ledger correction lines associated with the Subledger Accounting (SLA) CCID correction process. The view is the primary extraction point for the ar_ccid_corrections search context and is designed to present the corrections captured in AR_CCID_CORRECTIONS alongside the descriptive attributes of the underlying Receivables transactions, adjustments, salesreps, customers, and payment instruments.
Its role is diagnostic and reporting-oriented: it allows functional and technical users to review which Receivables distributions had their accounting flexfield (Code Combination ID) corrected, when the correction is effective (GL_DATE), and which parent transaction or adjustment the correction belongs to. Because it resolves lookup codes into user-facing meanings, it is also a convenient source for concurrent programs, BI Publisher reports, and reconciliation extracts.
Underlying Base Objects
Documented metadata for 12.2.2 lists the following referenced objects: ARPT_SQL_FUNC_UTIL (package), AR_ADJUSTMENTS, AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, AR_CCID_CORRECTIONS, AR_MISC_CASH_DISTRIBUTIONS, AR_RECEIVABLE_APPLICATIONS, AR_TRANSACTION_HISTORY, FND_GLOBAL (package), HZ_CUST_ACCOUNTS, HZ_PARTIES, IBY_FNDCPT_TRXN_PUB (package), IBY_TRXN_EXTENSIONS_V (view), RA_BATCH_SOURCES, RA_CUSTOMER_TRX, RA_CUST_TRX_LINE_GL_DIST, RA_CUST_TRX_LINE_SALESREPS, RA_CUST_TRX_TYPES, and RA_SALESREPS (view).
The view text is a UNION ALL of two branches. The first branch joins AR_CCID_CORRECTIONS to RA_CUSTOMER_TRX, RA_CUST_TRX_LINE_GL_DIST, RA_CUST_TRX_TYPES, RA_BATCH_SOURCES, IBY_TRXN_EXTENSIONS_V, RA_CUST_TRX_LINE_SALESREPS, RA_SALESREPS, HZ_PARTIES, and HZ_CUST_ACCOUNTS, restricted to SOURCE_TABLE = 'GLD'. The second branch handles adjustment sources (SOURCE_TABLE = 'ADJ') joining AR_ADJUSTMENTS, RA_CUSTOMER_TRX, HZ_PARTIES, and HZ_CUST_ACCOUNTS. The lookup decoding is performed by the ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING function, which converts lookup codes such as distribution type and category type into readable meanings.
Key Columns
- DISTRIBUTION_TYPE / DISTRIBUTION_TYPE_MEANING — the SLA distribution source type (for example REC vs. non-receivable) and its decoded meaning.
- CATEGORY_TYPE / CATEGORY_TYPE_MEANING — category of the underlying distribution, decoded against the
INV/CM/ADJorARRGTA_CATEGORIESlookup. - DISTRIBUTION_ID — identifier of the corrected distribution (GLD row or adjustment row).
- PARENT_ID — the parent transaction or adjustment identifier used to join back to the source.
- SOURCE_TABLE — the origin of the correction,
GLDorADJ. - CODE_COMBINATION_ID — the corrected accounting flexfield combination.
- TRX_NUMBER / ADJUSTMENT_NUMBER — the Receivables transaction number or adjustment number.
- GL_DATE — the accounting date on which the corrected distribution is recognized.
- NAME, SALESREP, PARTY_NAME — transaction type, batch source, salesrep, and customer party descriptors derived from the joined master data.
Common Use Cases and Queries
The view is typically queried to reconcile CCID corrections against receivable activity, to verify that corrected distributions carry the expected GL date and category, and to feed downstream reconciliation or audit reports. The following sample restricts output to a single transaction number:
SELECT DISTRIBUTION_TYPE_MEANING, CATEGORY_TYPE_MEANING, DISTRIBUTION_ID, PARENT_ID, SOURCE_TABLE, CODE_COMBINATION_ID, TRX_NUMBER, GL_DATE, PARTY_NAME FROM APPS.AR_CORRECT_GL_LINES_V WHERE TRX_NUMBER = :p_trx_number;
Because the view already resolves lookup meanings and joins the major descriptive entities, it removes the need for callers to replicate the multi-table join logic themselves. It should be treated as a reporting surface rather than a transactional one, and users should be aware that the CATEGORY_TYPE decoding differs between the GLD and ADJ branches, which is reflected in the reported meaning values.
-
View: AR_CORRECT_GL_LINES_V 12.2.2
APPS.AR_CORRECT_GL_LINES_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_ADJUSTMENTS·↳ AR_CASH_RECEIPTS·Explore AR module →
-
Individual GL distribution lines that contain invalid code combinations (GL accounts)
-
Table: HZ_TRANS_ATTRIBUTES_B 12.2.2
Stores information about the transformations on attributes.
-
View: HZ_TRANS_ATTRIBUTES_VL 12.1.1
APPS.HZ_TRANS_ATTRIBUTES_VL·↳ HZ_TRANS_ATTRIBUTES_B·↳ HZ_TRANS_ATTRIBUTES_TL·Explore AR module →
-
View: HZ_TRANS_ATTRIBUTES_VL 12.2.2
APPS.HZ_TRANS_ATTRIBUTES_VL·↳ HZ_TRANS_ATTRIBUTES_B·↳ HZ_TRANS_ATTRIBUTES_TL·Explore AR module →
-
View: HZ_ATTRIBUTE_TRANS_V 12.1.1
APPS.HZ_ATTRIBUTE_TRANS_V·↳ FND_LOOKUP_VALUES_VL·↳ HZ_TRANS_ATTRIBUTES_VL·Explore AR module →
-
View: HZ_ATTRIBUTE_TRANS_V 12.2.2
APPS.HZ_ATTRIBUTE_TRANS_V·↳ FND_LOOKUP_VALUES_VL·↳ HZ_TRANS_ATTRIBUTES_VL·Explore AR module →
-
APPS.AR_DOCUMENT_TRANSFERS_V·↳ AR_DOCUMENT_TRANSFERS·↳ ECX_TP_DETAILS_V·↳ ECX_TP_HEADERS·Explore AR module →
-
APPS.AR_DOCUMENT_TRANSFERS_V·↳ AR_DOCUMENT_TRANSFERS·↳ ECX_TP_DETAILS_V·↳ ECX_TP_HEADERS·Explore AR module →
-
APPS.HZ_TRANSFORMATION_ATTRIBUTES_V·↳ FND_GLOBAL·↳ FND_LOOKUP_VALUES·↳ HZ_TRANS_ATTRIBUTES_B·Explore AR module →
-
APPS.HZ_TRANSFORMATION_ATTRIBUTES_V·↳ FND_GLOBAL·↳ FND_LOOKUP_VALUES·↳ HZ_TRANS_ATTRIBUTES_B·Explore AR module →
-
Receivable Activities Details
-
Stores information about the transformations on attributes.
-
Accounting records for receipts
-
Individual GL distribution lines that contain invalid code combinations (GL accounts)
-
This table stores information about document transfer to your trading partners.
-
This table stores information about document transfer to your trading partners.
-
View: AR_CORRECT_GL_LINES_V 12.1.1
APPS.AR_CORRECT_GL_LINES_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_ADJUSTMENTS·↳ AR_CASH_RECEIPTS·Explore AR module →
-
Table: AR_BASE_DIST_AMTS_GT 12.2.2
-
Table: AR_BASE_DIST_AMTS_GT 12.1.1
-
Receivable Activities Details
-
Currency-related information about distributions generated by the different steps in the life cycle of a cash receipt
-
View: AR_DISTRIBUTIONS_MRC_V 12.1.1
Accounting records for receipts in multiple reporting currencies
APPS.AR_DISTRIBUTIONS_MRC_V·↳ AR_MC_DISTRIBUTIONS_ALL·Explore AR module →
-
View: AR_XLA_ARD_MCD_LINES_V 12.2.2
help reports to read the CCID from XLA
APPS.AR_XLA_ARD_MCD_LINES_V·↳ AR_DISTRIBUTIONS_ALL·↳ AR_MISC_CASH_DISTRIBUTIONS_ALL·↳ XLA_AE_HEADERS·Explore AR module →
-
Accounting records for receipts in multiple reporting currencies
APPS.AR_DISTRIBUTIONS_ALL_MRC_V·↳ AR_MC_DISTRIBUTIONS_ALL·Explore AR module →
-
View: AR_ADJ_DIST_UPG_V 12.2.2
AR XLA Extract
APPS.AR_ADJ_DIST_UPG_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_NUM_RAN_PKG·Explore AR module →
-
View: AR_ADJ_DIST_UPG_V 12.1.1
AR XLA Extract
APPS.AR_ADJ_DIST_UPG_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_NUM_RAN_PKG·Explore AR module →
-
View: AR_AEL_GL_REC_ALL_V 12.2.2
APPS.AR_AEL_GL_REC_ALL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_CB_REC_V·↳ AR_AEL_GL_REC_V·Explore AR module →
-
View: AR_AEL_GL_REC_ALL_V 12.1.1
APPS.AR_AEL_GL_REC_ALL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_CB_REC_V·↳ AR_AEL_GL_REC_V·Explore AR module →
-
Currency-related information about distributions generated by the different steps in the life cycle of a cash receipt
-
View: AR_DISTRIBUTIONS_MRC_V 12.2.2
Accounting records for receipts in multiple reporting currencies
APPS.AR_DISTRIBUTIONS_MRC_V·↳ AR_MC_DISTRIBUTIONS_ALL·Explore AR module →
-
View: AR_AEL_SL_REC_V 12.1.1
APPS.AR_AEL_SL_REC_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_CASH_RECEIPTS_ALL·↳ AR_CASH_RECEIPT_HISTORY_ALL·Explore AR module →
-
Accounting records for receipts
-
View: AR_APP_DIST_UPG_V 12.2.2
AR XLA extract
APPS.AR_APP_DIST_UPG_V·↳ AR_CASH_BASIS_DISTS_ALL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_NUM_RAN_PKG·Explore AR module →
-
View: AR_AEL_SL_INV_V 12.1.1
APPS.AR_AEL_SL_INV_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_AEL_SL_INV_V 12.2.2
APPS.AR_AEL_SL_INV_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_AEL_SL_INV_MRC_V 12.1.1
APPS.AR_AEL_SL_INV_MRC_V·↳ AR_DISTRIBUTIONS_ALL_MRC_V·↳ AR_LOOKUPS·↳ AR_RECEIVABLE_APPS_ALL_MRC_V·Explore AR module →
-
Table: AR_LINE_APP_DETAIL_GT 12.2.2
-
View: AR_XLA_ARD_ADJ_LINES_V 12.2.2
help reports to read the CCID from XLA
APPS.AR_XLA_ARD_ADJ_LINES_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_DISTRIBUTIONS_ALL·↳ XLA_AE_HEADERS·Explore AR module →
-
View: AR_XLA_ARD_TRH_LINES_V 12.2.2
help reports to read the CCID from XLA
APPS.AR_XLA_ARD_TRH_LINES_V·↳ AR_DISTRIBUTIONS_ALL·↳ AR_TRANSACTION_HISTORY_ALL·↳ RA_CUSTOMER_TRX_ALL·Explore AR module →
-
Temporary table used to store QuickCash payment applications - line level details
-
Accounting records for receipts in multiple reporting currencies
APPS.AR_DISTRIBUTIONS_ALL_MRC_V·↳ AR_MC_DISTRIBUTIONS_ALL·Explore AR module →
-
View: AR_AEL_SL_ADJ_MRC_V 12.2.2
APPS.AR_AEL_SL_ADJ_MRC_V·↳ AR_ADJUSTMENTS_ALL_MRC_V·↳ AR_DISTRIBUTIONS_ALL_MRC_V·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_AEL_SL_ADJ_V 12.1.1
APPS.AR_AEL_SL_ADJ_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_AEL_SL_ADJ_V 12.2.2
APPS.AR_AEL_SL_ADJ_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_AEL_GL_ADJ_V 12.1.1
APPS.AR_AEL_GL_ADJ_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_DISTRIBUTIONS_ALL·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_AEL_SL_ADJ_MRC_V 12.1.1
APPS.AR_AEL_SL_ADJ_MRC_V·↳ AR_ADJUSTMENTS_ALL_MRC_V·↳ AR_DISTRIBUTIONS_ALL_MRC_V·↳ AR_LOOKUPS·Explore AR module →