Results for “xtr_auth_type_subtype_prod_v”
22 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view APPS.XTR_AUTH_TYPE_SUBTYPE_PROD_V is a Treasury (XTR) module database object that exposes authorization configuration data used by Oracle EBS Treasury for deal and product processing. It presents a flattened, security-relevant projection of the authorization attributes that determine which deal types, deal subtypes, and product types a given user is authorized to process, and — critically for audit and control workflows — whether that user is authorized to validate transactions of that category (the VALIDATION_AUTHORIZED column).
The view is registered in the APPS schema with a status of VALID across both the 12.1.1 and 12.2.2 releases, and carries no online documentation body beyond its column list and definition. Its primary role in an EBS environment is to support reporting, personalization, and integration lookups where the business needs to answer the question "who can validate what" without querying the authorization setup tables directly.
Underlying Base Objects
The view is defined over a single base object, exposed in the data dictionary as the synonym XTR_AUTH_TYPE_SUBTYPE_PROD (the underlying authorization setup entity in the Treasury module). The view text is a straightforward column projection:
SELECT USER_NAME, DEAL_TYPE, DEAL_SUBTYPE, PRODUCT_TYPE, AUTHORISED, VALIDATION_AUTHORIZED FROM XTR_AUTH_TYPE_SUBTYPE_PROD
Because the definition is a pure select with no joins, filters, or aggregation, the view is a thin, read-optimized window onto the authorization setup data. It introduces no additional business logic, so any change made to the base authorization setup is immediately reflected in the view. This makes it a reliable, low-overhead source for downstream queries and for integration points that must not introduce join or performance risk into the Treasury setup tables.
Key Columns
- USER_NAME — the application user (FND user) to whom the authorization record applies. This is the primary dimension for user-driven authorization lookups.
- DEAL_TYPE — the Treasury deal type for which the authorization is granted or withheld.
- DEAL_SUBTYPE — the finer-grained deal subtype classification under the deal type.
- PRODUCT_TYPE — the financial instrument or product type associated with the authorization record.
- AUTHORISED — flag indicating whether the user is authorized to process (enter, modify) deals of that type/subtype/product combination.
- VALIDATION_AUTHORIZED — flag indicating whether the user is authorized to validate (approve/confirm) deals of that combination. This column is the object of the "validation_authorized" search and is the control point most relevant to segregation-of-duties and approval-limit reviews.
Common Use Cases and Queries
Typical usage centers on authorization reporting, SoD analysis, and integration lookups. A representative query retrieves all validation authorizations for a user:
SELECT user_name, deal_type, deal_subtype, product_type FROM xtr_auth_type_subtype_prod_v WHERE validation_authorized = 'Y' AND user_name = :p_user;
Additional scenarios include:
- Segregation-of-duties review — identifying users holding both
AUTHORISEDandVALIDATION_AUTHORIZEDprivileges on the same deal/product combination. - Period-end control reporting — listing all validators by product type for audit sign-off.
- Integration feeds — supplying downstream systems or custom concurrent programs with an authoritative, join-free list of validation authorizations.
Because the view contains no joins, it performs well as a direct query source; consumers should still apply appropriate user and product filters to avoid returning the full authorization matrix.
-
APPS.XTR_AUTH_TYPE_SUBTYPE_PROD_V·↳ XTR_AUTH_TYPE_SUBTYPE_PROD·Explore XTR module →
-
APPS.XTR_AUTH_TYPE_SUBTYPE_PROD_V·↳ XTR_AUTH_TYPE_SUBTYPE_PROD·Explore XTR module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.1.1
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.2.2
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96