Results for “xtr_standing_instructions_v”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The Oracle EBS view APPS.XTR_STANDING_INSTRUCTIONS_V is a Treasury (XTR) module reporting object that exposes the standing settlement and payment instructions maintained for counterparties, banks, and internal treasury parties. Standing instructions in Oracle Treasury define the default routing, account, and banking details that the application uses when processing deals, payments, and cash movements for a given party and currency combination. The view presents these instructions in a stable, queryable form suitable for reporting, integration extracts, and downstream validation logic.
In both Oracle EBS 12.1.1 and 12.2.2, the object carries a status of VALID and is owned by the APPS schema, consistent with the standard EBS convention in which transactional and reporting objects are exposed through APPS synonyms and views to support multi-org and responsibility-based access. The view is a thin projection over the underlying standing instructions table, meaning it inherits the same columns and row-level content while providing a named interface for reports and custom SQL.
Underlying Base Objects
The view is defined exclusively over the base object XTR_STANDING_INSTRUCTIONS, referenced through an APPS synonym. The view text is a simple projection:
SELECT UNIQUE_REF_NUM, PARTY_CODE, CURRENCY, BANK_CODE, ACCOUNT_NO, CPARTY_REF, DEAL_TYPE, DEAL_SUBTYPE, PRODUCT_TYPE, AMOUNT_TYPE, UPDATED_BY, UPDATED_ON, AUDIT_INDICATOR, CREATED_BY, CREATED_ON FROM XTR_STANDING_INSTRUCTIONS
No joins, filters, or calculated expressions are applied, so the view returns one row per standing instruction record present in the base table. Because the definition is an unfiltered column projection, the view functions as a read-only convenience layer and any operational DML must be directed at the base table. The UNIQUE_REF_NUM column acts as the logical primary reference for each instruction record.
Key Columns
UNIQUE_REF_NUM— Unique identifier for the standing instruction record.PARTY_CODE— The treasury party (counterparty or internal entity) to which the instruction applies.CURRENCY— Currency in which the instruction is valid.BANK_CODE— Bank identifier used for routing settlement.ACCOUNT_NO— Bank account number associated with the instruction.CPARTY_REF— The counterparty reference. This is the column most frequently targeted in searches such as "cparty_ref", as it links a standing instruction to the corresponding counterparty record.DEAL_TYPE,DEAL_SUBTYPE— Classify the deal category to which the instruction applies.PRODUCT_TYPE— Treasury product line associated with the instruction.AMOUNT_TYPE— Indicates the amount basis (for example, fixed or percentage) governing the instruction.AUDIT_INDICATOR— Flag indicating whether the record is subject to audit tracking.CREATED_BY,CREATED_ON,UPDATED_BY,UPDATED_ON— Standard EBS audit columns recording the user and timestamp of record creation and last update.
Common Use Cases and Queries
Typical uses include reconciling standing instructions against counterparty master data, validating that a bank account is defined before payment processing, and extracting instructions for reconciliation or interface feeds.
Retrieve all instructions for a specific counterparty reference:
SELECT unique_ref_num, party_code, currency, bank_code, account_no FROM xtr_standing_instructions_v WHERE cparty_ref = :p_cparty_ref;
List instructions by currency and deal type:
SELECT party_code, bank_code, account_no FROM xtr_standing_instructions_v WHERE currency = 'USD' AND deal_type = :p_deal_type;
Audit recent changes:
SELECT unique_ref_num, cparty_ref, updated_by, updated_on FROM xtr_standing_instructions_v WHERE updated_on >= :p_from_date ORDER BY updated_on DESC;
Because the view is unfiltered, standard EBS security operates at the responsibility and MOAC layer; no additional predicates are added by the view itself.
-
APPS.XTR_STANDING_INSTRUCTIONS_V·↳ XTR_STANDING_INSTRUCTIONS·Explore XTR module →
-
APPS.XTR_STANDING_INSTRUCTIONS_V·↳ XTR_STANDING_INSTRUCTIONS·Explore XTR module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design 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