Results for “xtr_trans_validations_v”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_TRANS_VALIDATIONS_V is a Treasury (XTR) module view owned by the APPS schema and classified as VALID. It is the primary data source behind the Transaction Validation form, which confirmation and operations staff use to review, authorize, and validate treasury transactions such as confirmations and rollovers before they are settled. The view presents a filtered, security-scoped result set rather than a raw table image: only non-cancelled confirmation records, only transactions the requesting user is authorized to act upon, and only those instrument type/sub-type/product combinations flagged as validation-authorized in Treasury setup.
Because the view embeds FND_GLOBAL.USER_ID and dealer-code lookups in its WHERE clause, its output is inherently user-dependent. Two users querying the same underlying data can legitimately receive different row sets. This design makes the view unsuitable as a bulk extraction source, but ideal for form-driven inquiry and for personalized reporting where row-level access control must mirror the application's own authority model.
Underlying Base Objects
The view's defining query selects from XTR_CONFIRMATION_DETAILS, aliased XD. The remaining objects appear in correlated sub-queries and joins that constrain the result set:
- XTR_REVIEW_ALL_CONTRACTS_V — used in a NOT EXISTS clause to exclude deals whose linked contract is cancelled. This is the segment where ROLLOVER_TRANSACTION_NO is evaluated against TRANSACTION_NO, with NULL-tolerant matching.
- XTR_ROLLOVER_TRANSACTIONS_V and XTR_ROLLOVER_TRANSACTIONS — used in EXISTS clauses to admit rollover deals and, for ONC deal types, to resolve the rollover transaction number.
- XTR_COMPANY_AUTHORITIES and XTR_DEALER_CODES — enforce company-level authorization for input, joined on the session user id via FND_GLOBAL.USER_ID.
- XTR_AUTH_TYPE_SUBTYPE_PROD — restricts rows to type/sub-type/product combinations with VALIDATION_AUTHORIZED = 'Y'.
- XTR_DEALS, XTR_EXPOSURE_TRANSACTIONS, XTR_INTERACCT_TRANSFERS, and the XTR_USER_ACCESS package — supporting deal and access-control objects referenced by the view family.
- FND_GLOBAL — supplies the runtime user id used throughout the authorization predicates.
All base tables are accessed through APPS synonyms, consistent with standard EBS view construction.
Key Columns
The projection exposes the following columns, drawn principally from XTR_CONFIRMATION_DETAILS:
- DEAL_NO, TRANSACTION_NO, DEAL_TYPE, DEAL_SUBTYPE — the deal and transaction identity, which drive the rollover and authorization filtering logic.
- STATUS_CODE — confirmation status; CANCELLED rows are excluded by the view text.
- CPARTY_CODE, NVL(CONFO_PARTY_CODE, CPARTY_CODE), CLIENT_CODE — counterparty identification, with a fallback to the confirmation party where present.
- CURRENCY, AMOUNT, AMOUNT_TYPE, SETTLE_DATE — financial attributes of the confirmed transaction.
- ACTION_TYPE, DATE_ACTION_INITIATED — the validation action and its timestamp.
- CONFIRMATION_VALIDATED_BY, CONFIRMATION_VALIDATED_ON, CONFO_VALIDATION_BOTH — validation audit fields.
- FILE_NAME, INITIALLY_PRINTED_ON, REPRINT_REQUESTED_BY, REPRINTED_ON — confirmation document and reprint tracking.
- PARTY_CONFO_CHECKED, PARTY_CONFO_FILE_NAME, PARTY_CONFO_CHECKED_ON, PARTY_CONFO_CHECKED_BY — counterparty confirmation check details.
- COMPANY_CODE, DEAL_UPDATED_YN — owning company and deal-modification indicator.
Common Use Cases and Queries
The view supports transaction validation inquiries, pending-confirmation worklists, and rollover confirmation review. A typical query lists validations awaiting action for the current user:
- Filter by STATUS_CODE to isolate open versus validated confirmations.
- Filter by DEAL_TYPE = 'ONC' to examine rollover transactions specifically, since the view branches its authorization logic for that type.
- Join back to XTR_CONFIRMATION_DETAILS on TRANSACTION_NO and DEAL_NO for columns not projected.
Sample SQL:
SELECT deal_no, transaction_no, deal_type, status_code, currency, amount,
confirmation_validated_on
FROM apps.xtr_trans_validations_v
WHERE status_code != 'CANCELLED'
AND deal_type = 'ONC';
Because authorization predicates depend on FND_GLOBAL.USER_ID, ad hoc queries executed outside the EBS session (for example via a generic reporting login) may return no rows or an unexpected set. For scheduled reports, run the query under a session that initializes the correct user context.
-
This view is used in the Transaction Validation form.
APPS.XTR_TRANS_VALIDATIONS_V·↳ FND_GLOBAL·↳ XTR_AUTH_TYPE_SUBTYPE_PROD·↳ XTR_COMPANY_AUTHORITIES·Explore XTR module →
-
This view is used in the Transaction Validation form.
APPS.XTR_TRANS_VALIDATIONS_V·↳ FND_GLOBAL·↳ XTR_AUTH_TYPE_SUBTYPE_PROD·↳ XTR_COMPANY_AUTHORITIES·Explore XTR module →
-
SYNONYM: APPS.XTR_DEALS 12.1.1
-
SYNONYM: APPS.XTR_DEALS 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96