Results for “third_party_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XLA_THIRD_PARTIES_V is a Subledger Accounting (XLA) view owned by the APPS schema and registered as VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated list of third-party entities — suppliers and customers — together with a derived third-party identifier, a single-character third-party type indicator, and a source-system reference number. The view exists primarily to satisfy the "third party" attributes required by the Subledger Accounting architecture, which tags accounting entries, journal line definitions, and supporting references with the party that originated or received a transaction.
Its role in reporting and integration is to unify two otherwise unrelated master-data sources into a single queryable set. Rather than requiring downstream developers to write bespoke UNION logic against payables and receivables tables, the view supplies a consistent three-column projection: THIRD_PARTY_ID, THIRD_PARTY_TYPE, and THIRD_PARTY_NUMBER. The user's search term "third_party_number" maps directly to the third column, which carries the human-recognizable reference — SEGMENT1 for a supplier and ACCOUNT_NUMBER for a customer — while THIRD_PARTY_ID holds the internal primary key of the respective entity.
Underlying Base Objects
The view text is a UNION ALL of two SELECT statements defined over referenced base objects documented as AP_SUPPLIERS (SYNONYM) and HZ_CUST_ACCOUNTS (SYNONYM). The supplier branch reads VENDOR_ID, a literal 'S', and SEGMENT1 from AP_SUPPLIERS. The customer branch reads CUST_ACCOUNT_ID, a literal 'C', and ACCOUNT_NUMBER from HZ_CUST_ACCOUNTS.
Because UNION ALL is used rather than UNION, no deduplication occurs; every supplier row and every customer row is returned, preserving row counts and avoiding a sort/distinct operation that would degrade performance on large trading-partner populations. The APPS synonyms resolve to the underlying applications tables at runtime, so the view inherits standard EBS security, grants, and any row-level controls applied to the base tables. The view itself is a simple projection and contains no joins, no aggregation, and no filtering predicates.
Key Columns
- THIRD_PARTY_ID — The internal unique identifier for the party. It holds VENDOR_ID for suppliers and CUST_ACCOUNT_ID for customers. Values are not globally unique across the two branches; uniqueness is only guaranteed when combined with THIRD_PARTY_TYPE.
- THIRD_PARTY_TYPE — A single-character discriminator. 'S' designates a supplier entry originating from AP_SUPPLIERS; 'C' designates a customer entry originating from HZ_CUST_ACCOUNTS. This column must always be used with THIRD_PARTY_ID when resolving the source record.
- THIRD_PARTY_NUMBER — The user-facing reference number. For type 'S' it is the supplier number (AP_SUPPLIERS.SEGMENT1); for type 'C' it is the customer account number (HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER). This is the column most frequently searched and displayed.
Common Use Cases and Queries
The view is typically used to resolve a third-party number from an identifier stored on Subledger Accounting records, or to validate that a party exists before insert into a custom table. A straightforward lookup of a supplier or customer number by internal ID follows this pattern:
- SELECT third_party_type, third_party_number FROM xla_third_parties_v WHERE third_party_id = :id AND third_party_type = 'S';
- Reverse lookup: SELECT third_party_id FROM xla_third_parties_v WHERE third_party_number = :number AND third_party_type = 'C';
- Population listing: SELECT third_party_type, third_party_id, third_party_number FROM xla_third_parties_v ORDER BY third_party_type, third_party_number;
- Ambiguity check when the type is unknown: SELECT party.* FROM xla_third_parties_v party WHERE party.third_party_number = :number;
Practical applications include building Subledger Accounting reconciliation reports that display trading-partner numbers alongside journal lines, mapping legacy party references during data conversion, and powering LOV or lookup queries in custom concurrent programs. Because the view performs no filtering, callers should always supply a WHERE clause on THIRD_PARTY_ID, THIRD_PARTY_TYPE, or THIRD_PARTY_NUMBER to avoid full scans against both supplier and customer populations.
-
View: XLA_THIRD_PARTIES_V 12.1.1
Third party id, third party type and third party number information
APPS.XLA_THIRD_PARTIES_V·↳ AP_SUPPLIERS·↳ HZ_CUST_ACCOUNTS·Explore XLA module →
-
third party site information
APPS.XLA_THIRD_PARTY_SITES_V·↳ AP_SUPPLIERS·↳ AP_SUPPLIER_SITES_ALL·↳ HZ_CUST_ACCOUNTS·Explore XLA module →
-
View: XLA_THIRD_PARTIES_V 12.2.2
Third party id, third party type and third party number information
APPS.XLA_THIRD_PARTIES_V·↳ AP_SUPPLIERS·↳ HZ_CUST_ACCOUNTS·Explore XLA module →
-
third party site information
APPS.XLA_THIRD_PARTY_SITES_V·↳ AP_SUPPLIERS·↳ AP_SUPPLIER_SITES_ALL·↳ HZ_CUST_ACCOUNTS·Explore XLA module →
-
Returns details of all transactions in Payables and Receivables that are available for inclusion into a Dialog Unit.
APPS.IGI_EXP_AVAILABLE_TRX_V·↳ AP_HOLDS·↳ AP_INVOICES_PKG·↳ AP_INVOICES_UTILITY_PKG·Explore IGI module →
-
Returns details of all transactions in Payables and Receivables that are available for inclusion into a Dialog Unit.
APPS.IGI_EXP_AVAILABLE_TRX_V·↳ AP_HOLDS·↳ AP_INVOICES_PKG·↳ AP_INVOICES_UTILITY_PKG·Explore IGI module →
-
Subledger accounting balance information for control accounts
-
Subledger accounting balance information for control accounts
-
Table that stores historical data of Third Party Content Provider activity on Suppliers' catalogs.
-
Table that stores historical data of Third Party Content Provider activity on Suppliers' catalogs.
-
View: IGI_EXP_DIAL_UNIT_DEF 12.2.2
Multi org view which displays all information pertaining to dialog unit setup.
APPS.IGI_EXP_DIAL_UNIT_DEF·↳ IGI_EXP_DIAL_UNIT_DEF_ALL·Explore IGI module →
-
Stores information about exchange protocol transmission units
-
Table: AR_CM_FROM_GT 12.2.2
-
Cross reference for all third parties assigned to a delinquency.
-
View: IGI_EXP_DU_LINES_V 12.1.1
Returns details of all Payables and Receivables transactions that are included in Dialog Units.
APPS.IGI_EXP_DU_LINES_V·↳ AP_INVOICES_PKG·↳ AP_INVOICES_UTILITY_PKG·↳ AP_INVOICES_V·Explore IGI module →
-
View: IGI_EXP_TRAN_UNIT_DEF 12.2.2
Displays information about Echange Protocol transmission units.
APPS.IGI_EXP_TRAN_UNIT_DEF·↳ IGI_EXP_TRAN_UNIT_DEF_ALL·Explore IGI module →
-
The table 'JA_CN_ACCOUNT_BALANCES_GT' is a global temporary table used by posting journal to balance.
-
The table 'JA_CN_ACCOUNT_BALANCES' stores beginning balance, period net DR amount, period net CR amount and ending balance for nature account and subsidiary segments by period and currency.
-
View: IGI_EXP_TRAN_UNIT_DEF 12.1.1
Displays information about Echange Protocol transmission units.
APPS.IGI_EXP_TRAN_UNIT_DEF·↳ IGI_EXP_TRAN_UNIT_DEF_ALL·Explore IGI module →
-
View: IGI_EXP_DIAL_UNIT_DEF 12.1.1
Multi org view which displays all information pertaining to dialog unit setup.
APPS.IGI_EXP_DIAL_UNIT_DEF·↳ IGI_EXP_DIAL_UNIT_DEF_ALL·Explore IGI module →
-
APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore FND 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 →
-
Stores information about exchange protocol transmission units
-
Stores all information pertaining to dialog unit setup
-
View: IGI_EXP_DU_LINES_V 12.2.2
Returns details of all Payables and Receivables transactions that are included in Dialog Units.
APPS.IGI_EXP_DU_LINES_V·↳ AP_INVOICES_PKG·↳ AP_INVOICES_UTILITY_PKG·↳ AP_INVOICES_V·Explore IGI module →
-
View: PN_AEL_BILL_GL_V 12.2.2
APPS.PN_AEL_BILL_GL_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ GL_DAILY_CONVERSION_TYPES·Explore PN module →
-
View: AP_ENC_GL_INV_V 12.2.2
APPS.AP_ENC_GL_INV_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_LOOKUP_CODES·Explore FND module →
-
View: XLA_AR_ADJ_AEL_GL_V 12.1.1
APPS.XLA_AR_ADJ_AEL_GL_V·↳ AR_AEL_GL_ADJ_V·Explore XLA 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
-
Stores all information pertaining to dialog unit setup
-
Accounting records for receipts in multiple reporting currencies
APPS.AR_DISTRIBUTIONS_ALL_MRC_V·↳ AR_MC_DISTRIBUTIONS_ALL·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: OKL_AEL_GL_CTR_V 12.2.2
This view contains all the contract related transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under Booking, Rebook, Renewal, Rel
APPS.OKL_AEL_GL_CTR_V·↳ ARP_ADDR_LABEL_PKG·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore OKL module →
-
APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore FND module →
-
View: JAI_PLA_ENTRY_AEL_V 12.2.2
Base view of PLA entry
APPS.JAI_PLA_ENTRY_AEL_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
Accounting records for receipts in multiple reporting currencies
APPS.AR_DISTRIBUTIONS_ALL_MRC_V·↳ AR_MC_DISTRIBUTIONS_ALL·Explore AR module →
-
Accounting entry lines table
-
View: XLA_AR_REC_AEL_GL_V 12.2.2
APPS.XLA_AR_REC_AEL_GL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_REC_ALL_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
View: PN_AEL_BILL_GL_V 12.1.1
APPS.PN_AEL_BILL_GL_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ GL_DAILY_CONVERSION_TYPES·Explore PN module →
-
This table stores Accounting lines for a account header
-
View: XLA_AR_REC_AEL_GL_V 12.1.1
APPS.XLA_AR_REC_AEL_GL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_REC_ALL_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
View: PN_AEL_PAY_GL_V 12.1.1
APPS.PN_AEL_PAY_GL_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ GL_DAILY_CONVERSION_TYPES·Explore PN module →
-
View: PN_AEL_PAY_GL_V 12.2.2
APPS.PN_AEL_PAY_GL_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ GL_DAILY_CONVERSION_TYPES·Explore PN module →
-
View: GL_JE_LINES_V 12.1.1
APPS.GL_JE_LINES_V·↳ GL_CODE_COMBINATIONS·↳ GL_JE_LINES·↳ GL_JE_LINES_RECON·Explore GL module →
-
View: AP_ENC_GL_INV_V 12.2.2
APPS.AP_ENC_GL_INV_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_LOOKUP_CODES·Explore AP module →