Results for “dda_deal_subtype”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_DISC_CASHFLOWS_V is a Treasury (XTR) reporting view owned by the APPS schema and defined over the core deal, counterparty, bank, amount-type, and authority tables of Oracle E-Business Suite Treasury. Its declared purpose is to present internal Treasury deal cash flows together with external cash flows, while enforcing user access to company information. The view is a UNION ALL construct: the first branch reads deal date amounts for authorized companies, and the second branch reads external cash flows. Because access control is embedded in the view definition through XTR_COMPANY_AUTHORITIES and FND_GLOBAL.USER_ID, the view returns only those companies for which the queried user holds an authorized dealer code with input authority. This makes it suitable for Treasury dashboards, cash-flow listings, reconciliation extracts, and integration feeds where row-level security must be preserved without relying on the calling application to apply the predicate.

Underlying Base Objects

The documented base objects are XTR_DEAL_DATE_AMOUNTS, XTR_DEAL_TYPES, XTR_DEAL_SUBTYPES, XTR_AMOUNT_TYPES, XTR_BANK_ACCOUNTS, XTR_COMPANY_AUTHORITIES, XTR_DEALER_CODES, XTR_PARTY_INFO (joined twice, aliased A and B), XTR_EXTERNAL_CASHFLOWS, and the FND_GLOBAL package. XTR_DEAL_DATE_AMOUNTS supplies the primary deal cash-flow rows; XTR_DEAL_TYPES and XTR_DEAL_SUBTYPES provide the user-facing type and subtype descriptions; XTR_AMOUNT_TYPES supplies the amount-type name; XTR_BANK_ACCOUNTS supplies bank code and bank name; and XTR_PARTY_INFO provides company and counterparty full names. XTR_COMPANY_AUTHORITIES and XTR_DEALER_CODES drive the security predicate, and FND_GLOBAL.USER_ID supplies the current session user for dealer-code matching. The external branch reads XTR_EXTERNAL_CASHFLOWS with sign logic to distinguish receipt and payment transaction types. The joins to XTR_AMOUNT_TYPES, XTR_BANK_ACCOUNTS, and XTR_PARTY_INFO (counterparty) are outer joins, so deals without those attributes still appear.

Key Columns

• DEAL_NUMBER, DEAL_TYPE, DEAL_SUBTYPE — deal identifiers; DEAL_SUBTYPE is the code that resolves to the user-facing value in DEAL_SUBTYPE_NAME.
• DEAL_TYPE_NAME, DEAL_SUBTYPE_NAME — descriptive values from XTR_DEAL_TYPES.NAME and XTR_DEAL_SUBTYPES.NAME. The user search for "deal_subtype_name" maps directly to this column.
• CASHFLOW_AMOUNT, AMOUNT_DATE, CURRENCY, TRANSACTION_RATE, AMOUNT_TYPE — monetary and timing attributes of each cash flow; AMOUNT_TYPE_NAME provides the descriptive label from XTR_AMOUNT_TYPES.
• COMPANY_CODE, COMPANY_FULL_NAME, CPARTY_CODE, CPARTY_FULL_NAME — internal company and counterparty identifiers and names.
• ACCOUNT_NO, BANK_CODE, BANK_NAME — settlement bank account attributes.
• STATUS_CODE, PRODUCT_TYPE, PORTFOLIO_CODE, DEALER_CODE, SETTLE, MULTIPLE_SETTLEMENTS, TRANSACTION_NUMBER — status and control attributes of the underlying deal.
• USER_DEAL_TYPE, USER_DEAL_SUBTYPE, USER_AMOUNT_TYPE, FX_MM_EXP_FLAG — classification flags and user-defined type indicators.

Common Use Cases and Queries

The view is typically queried for Treasury cash-flow reports, settlement calendars, and counterparty exposure extracts. Filters exclude cancelled deals, zero amounts, deal type 'CA', and multiple-settlement deals in the internal branch, so consumers should not expect those rows.

• Listing cash flows by subtype name: SELECT deal_number, deal_type_name, deal_subtype_name, cashflow_amount, amount_date, currency FROM xtr_disc_cashflows_v WHERE deal_subtype_name = :subtype;
• Company-scoped cash flow by counterparty: SELECT company_full_name, cparty_full_name, cashflow_amount FROM xtr_disc_cashflows_v WHERE company_code = :company;
• Settlement listing with bank details: SELECT deal_number, bank_name, account_no, amount_date, cashflow_amount FROM xtr_disc_cashflows_v WHERE settle = 'Y';
• External versus internal identification: the external branch returns DEAL_TYPE 'EXT' with DEAL_SUBTYPE 'INDIC' and a constant transaction rate of 1, allowing separation of external cash flows from internal deal flows in a single result set.