[Home] [Help] [Dependency Information]
Object Name: | XTR_REVIEW_ALL_CONTRACTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_REVIEW_ALL_CONTRACTS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_NO | NUMBER | |||
ROLLOVER_TRANSACTION_NO | NUMBER | |||
COMPANY | VARCHAR2 | (7) | ||
COUNTERPARTY | VARCHAR2 | (7) | ||
CLIENT | VARCHAR2 | (7) | ||
ACCEPTOR | VARCHAR2 | (20) | ||
ENDORSER | VARCHAR2 | (20) | ||
DRAWER | VARCHAR2 | (20) | ||
CONTRACT_TYPE | VARCHAR2 | (7) | ||
USER_DEAL_TYPE | VARCHAR2 | (7) | ||
CONTRACT_SUBTYPE | VARCHAR2 | (7) | ||
USER_DEAL_SUBTYPE | VARCHAR2 | (7) | ||
PRODUCT | VARCHAR2 | (10) | ||
PORTFOLIO | VARCHAR2 | (10) | ||
CURRENCY | VARCHAR2 | (15) | ||
CURRENCY_SELL | VARCHAR2 | (15) | ||
CONTRACT_DEALT_ON | DATE | |||
AUTHORISED_ON | DATE | |||
COMMENCE_DATE | DATE | |||
MATURITY_DATE | DATE | |||
SETTLEMENT_DATE | DATE | |||
PREMIUM_DATE | DATE | |||
OPTION_EXPIRY | DATE | |||
AMOUNT | NUMBER | |||
SELL_AMOUNT | NUMBER | |||
CONSIDERATION_AMOUNT | NUMBER | |||
SETTLEMENT_AMOUNT | NUMBER | |||
PREMIUM_AMOUNT | NUMBER | |||
BROKER_AMOUNT | NUMBER | |||
TAX_AMOUNT | NUMBER | |||
CONTRACT_RATE | NUMBER | |||
COUPON_RATE | NUMBER | |||
BROKER_RATE | NUMBER | |||
TAX_RATE | NUMBER | |||
SETTLEMENT_RATE | NUMBER | |||
ENTERED_INTO_SYSTEM_ON | DATE | |||
ENTERED_INTO_SYSTEM_BY | VARCHAR2 | (30) | ||
COMPANY_DEALER | VARCHAR2 | (10) | ||
AUTHORISED_BY | VARCHAR2 | (30) | ||
COMPANY_SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
COUNTERPARTY_ACCT_REF | VARCHAR2 | (80) | ||
PREMIUM_ACCT | VARCHAR2 | (20) | ||
FX_BUY_SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
FX_SELL_SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
CONTRACT_STATUS | VARCHAR2 | (10) | ||
USER_STATUS_CODE | VARCHAR2 | (10) | ||
LIMIT_CODE | VARCHAR2 | (7) | ||
FIXED_FLOAT_BASIS | VARCHAR2 | (5) | ||
CONTRACT_LINK_CODE | VARCHAR2 | (8) | ||
LETTER_PRINTED_YN | VARCHAR2 | (1) | ||
BROKER_CODE | VARCHAR2 | (7) | ||
TAX_CODE | VARCHAR2 | (7) | ||
PAY_REC_SETTLEMENT | VARCHAR2 | (7) | ||
PAY_REC_PREMIUM | VARCHAR2 | (7) | ||
ROLLED_FROM_FX_CONTRACT | NUMBER | |||
PREDELIVERED_FROM_FX_CONTRACT | NUMBER | |||
COMMENTS | VARCHAR2 | (255) | ||
ACTION_STATUS | VARCHAR2 | (20) | ||
CONTRACT_TYPE_NAME | VARCHAR2 | (80) | ||
ISSUE_CODE | VARCHAR2 | (30) | ||
PRICE | NUMBER | |||
QUANTITY | NUMBER | |||
INCOME_TAX_CODE | VARCHAR2 | (7) | ||
INCOME_TAX_RATE | NUMBER | |||
INCOME_TAX_AMOUNT | NUMBER | |||
INTEREST_DUE_ON | DATE | |||
MATURE_SETTLEMENT_BASIS | VARCHAR2 | (2) | ||
PAYMENT_SETTLEMENT_BASIS | VARCHAR2 | (2) | ||
CPARTY_ACCOUNT_NO | VARCHAR2 | (20) | ||
ACTION | VARCHAR2 | (7) |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_NO
, ROLLOVER_TRANSACTION_NO
, COMPANY
, COUNTERPARTY
, CLIENT
, ACCEPTOR
, ENDORSER
, DRAWER
, CONTRACT_TYPE
, USER_DEAL_TYPE
, CONTRACT_SUBTYPE
, USER_DEAL_SUBTYPE
, PRODUCT
, PORTFOLIO
, CURRENCY
, CURRENCY_SELL
, CONTRACT_DEALT_ON
, AUTHORISED_ON
, COMMENCE_DATE
, MATURITY_DATE
, SETTLEMENT_DATE
, PREMIUM_DATE
, OPTION_EXPIRY
, AMOUNT
, SELL_AMOUNT
, CONSIDERATION_AMOUNT
, SETTLEMENT_AMOUNT
, PREMIUM_AMOUNT
, BROKER_AMOUNT
, TAX_AMOUNT
, CONTRACT_RATE
, COUPON_RATE
, BROKER_RATE
, TAX_RATE
, SETTLEMENT_RATE
, ENTERED_INTO_SYSTEM_ON
, ENTERED_INTO_SYSTEM_BY
, COMPANY_DEALER
, AUTHORISED_BY
, COMPANY_SETTLEMENT_ACCT
, COUNTERPARTY_ACCT_REF
, PREMIUM_ACCT
, FX_BUY_SETTLEMENT_ACCT
, FX_SELL_SETTLEMENT_ACCT
, SETTLEMENT_ACCT
, CONTRACT_STATUS
, USER_STATUS_CODE
, LIMIT_CODE
, FIXED_FLOAT_BASIS
, CONTRACT_LINK_CODE
, LETTER_PRINTED_YN
, BROKER_CODE
, TAX_CODE
, PAY_REC_SETTLEMENT
, PAY_REC_PREMIUM
, ROLLED_FROM_FX_CONTRACT
, PREDELIVERED_FROM_FX_CONTRACT
, COMMENTS
, ACTION_STATUS
, CONTRACT_TYPE_NAME
, ISSUE_CODE
, PRICE
, QUANTITY
, INCOME_TAX_CODE
, INCOME_TAX_RATE
, INCOME_TAX_AMOUNT
, INTEREST_DUE_ON
, MATURE_SETTLEMENT_BASIS
, PAYMENT_SETTLEMENT_BASIS
, CPARTY_ACCOUNT_NO
, ACTION
FROM APPS.XTR_REVIEW_ALL_CONTRACTS_V;
|
|
|