[Home] [Help] [Dependency Information]
Object Name: | XTR_A_ROLLOVER_TRANSACTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_A_ROLLOVER_TRANSACTIONS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAX_SETTLED_REFERENCE | NUMBER | |||
TRANSACTION_NUMBER | NUMBER | Yes | ||
TRANS_CLOSEOUT_NO | NUMBER | |||
UPDATED_BY | VARCHAR2 | (30) | ||
UPDATED_ON | DATE | |||
YEAR_BASIS | NUMBER | |||
YEAR_CALC_TYPE | VARCHAR2 | (15) | ||
PRINCIPAL_ADJUST | NUMBER | |||
DEAL_SUBTYPE | VARCHAR2 | (7) | ||
DEAL_TYPE | VARCHAR2 | (7) | Yes | |
DRAWER_CODE | VARCHAR2 | (7) | ||
DRAWER_NAME | VARCHAR2 | (20) | ||
BKGE_SETTLED_REFERENCE | NUMBER | |||
BROKERAGE_AMOUNT | NUMBER | |||
BROKERAGE_AMOUNT_HCE | NUMBER | |||
BROKERAGE_CODE | VARCHAR2 | (7) | ||
BROKERAGE_RATE | NUMBER | |||
CLIENT_ADVICE | VARCHAR2 | (1) | ||
CLIENT_CODE | VARCHAR2 | (7) | ||
ACCUM_INT_ACTION | VARCHAR2 | (7) | ||
ACCUM_INT_AMOUNT_TYPE | VARCHAR2 | (7) | ||
ACTION_STATUS | VARCHAR2 | (20) | ||
ADJUSTED_BALANCE | NUMBER | |||
ARCHIVE_BY | VARCHAR2 | (30) | ||
ARCHIVE_DATE | DATE | |||
ATTACHMENT_EXISTS | VARCHAR2 | (1) | ||
AUDIT_DATE_STORED | DATE | |||
AUDIT_INDICATOR | VARCHAR2 | (1) | ||
BALANCE_OUT | NUMBER | |||
BALANCE_OUT_BF | NUMBER | |||
BALANCE_OUT_BF_HCE | NUMBER | |||
BALANCE_OUT_HCE | NUMBER | |||
BAL_OS_ACCOUNT_NO | VARCHAR2 | (20) | ||
EXPECTED_BALANCE_BF | NUMBER | |||
EXPECTED_BALANCE_OUT | NUMBER | |||
EXTERNAL_COMMENTS | VARCHAR2 | (255) | ||
DATE_RECEIVED | DATE | |||
DEALER_CODE | VARCHAR2 | (10) | ||
DEAL_DATE | DATE | |||
DEAL_LINKING_CODE | VARCHAR2 | (8) | ||
DEAL_NUMBER | NUMBER | Yes | ||
DUAL_AUTHORISATION_BY | VARCHAR2 | (30) | ||
DUAL_AUTHORISATION_ON | DATE | |||
ENDORSER_CODE | VARCHAR2 | (7) | ||
ACCEPTOR_CODE | VARCHAR2 | (7) | ||
ACCEPTOR_NAME | VARCHAR2 | (20) | ||
ACCRUAL_FROM | DATE | |||
ACCRUAL_TO | DATE | |||
ACCUM_INTEREST | NUMBER | |||
ACCUM_INTEREST_BF | NUMBER | |||
ACCUM_INTEREST_BF_HCE | NUMBER | |||
ACCUM_INTEREST_HCE | NUMBER | |||
ACCUM_INT_ACCOUNT_NO | VARCHAR2 | (20) | ||
EXTERNAL_CPARTY_NO | VARCHAR2 | (15) | ||
FID_TAX | NUMBER | |||
FID_TAX_HCE | NUMBER | |||
INTEREST | NUMBER | |||
INTEREST_FREQ | VARCHAR2 | (1) | ||
INTEREST_HCE | NUMBER | |||
INTEREST_RATE | NUMBER | |||
INTEREST_SETTLED | NUMBER | |||
INTEREST_SETTLEMENT_TYPE | VARCHAR2 | (1) | ||
INTERNAL_TICKET_NO | VARCHAR2 | (15) | ||
ISSUER_ADVICE | VARCHAR2 | (1) | ||
LIMIT_CODE | VARCHAR2 | (7) | ||
MATURITY_DATE | DATE | |||
NI_PROFIT_LOSS | NUMBER | |||
NI_PROFIT_LOSS_HCE | NUMBER | |||
NI_RENEG_DATE | DATE | |||
NO_OF_DAYS | NUMBER | |||
OLD_PRODUCT_TYPE | VARCHAR2 | (10) | ||
PARCEL_SPLIT_NO | NUMBER | |||
PARENT_PARTY | VARCHAR2 | (7) | ||
PI_AMOUNT_DUE | NUMBER | |||
PI_AMOUNT_RECEIVED | NUMBER | |||
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
PRINCIPAL_ACCOUNT_NO | VARCHAR2 | (20) | ||
PRINCIPAL_ACTION | VARCHAR2 | (7) | ||
PRINCIPAL_ADJUST_HCE | NUMBER | |||
PRINCIPAL_AMOUNT_TYPE | VARCHAR2 | (12) | ||
PRINTED_CPARTY_ADVICE | VARCHAR2 | (1) | ||
PRINTED_REDEMPTION_YN | VARCHAR2 | (1) | ||
PRINTED_YN | VARCHAR2 | (1) | ||
PRODUCT_TYPE | VARCHAR2 | (10) | ||
QUICK_INPUT | VARCHAR2 | (1) | ||
RATE_EFFECTIVE_CREATED | DATE | |||
RENEG_ONLY_LETTER | VARCHAR2 | (1) | ||
REPAY_AMOUNT | NUMBER | |||
REPAY_AMOUNT_HCE | NUMBER | |||
SECURITY_TYPE | VARCHAR2 | (1) | ||
SETTLEMENT_TYPE | VARCHAR2 | (1) | ||
SETTLE_DATE | DATE | |||
SETTLE_TERM_INTEREST | VARCHAR2 | (1) | ||
START_DATE | DATE | |||
STATUS_CODE | VARCHAR2 | (10) | ||
TAX_AMOUNT | NUMBER | |||
TAX_AMOUNT_HCE | NUMBER | |||
TAX_CODE | VARCHAR2 | (7) | ||
TAX_RATE | NUMBER | |||
CROSS_REF_TO_TRANS | NUMBER | |||
CURRENCY | VARCHAR2 | (15) | ||
COMMENTS | VARCHAR2 | (255) | ||
COMPANY_CODE | VARCHAR2 | (7) | ||
CPARTY_ADVICE | VARCHAR2 | (1) | ||
CPARTY_CODE | VARCHAR2 | (7) | ||
CREATED_BY | VARCHAR2 | (30) | Yes | |
CREATED_ON | DATE | Yes | ||
ENDORSER_NAME | VARCHAR2 | (20) | ||
RATE_FIXING_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT TAX_SETTLED_REFERENCE
, TRANSACTION_NUMBER
, TRANS_CLOSEOUT_NO
, UPDATED_BY
, UPDATED_ON
, YEAR_BASIS
, YEAR_CALC_TYPE
, PRINCIPAL_ADJUST
, DEAL_SUBTYPE
, DEAL_TYPE
, DRAWER_CODE
, DRAWER_NAME
, BKGE_SETTLED_REFERENCE
, BROKERAGE_AMOUNT
, BROKERAGE_AMOUNT_HCE
, BROKERAGE_CODE
, BROKERAGE_RATE
, CLIENT_ADVICE
, CLIENT_CODE
, ACCUM_INT_ACTION
, ACCUM_INT_AMOUNT_TYPE
, ACTION_STATUS
, ADJUSTED_BALANCE
, ARCHIVE_BY
, ARCHIVE_DATE
, ATTACHMENT_EXISTS
, AUDIT_DATE_STORED
, AUDIT_INDICATOR
, BALANCE_OUT
, BALANCE_OUT_BF
, BALANCE_OUT_BF_HCE
, BALANCE_OUT_HCE
, BAL_OS_ACCOUNT_NO
, EXPECTED_BALANCE_BF
, EXPECTED_BALANCE_OUT
, EXTERNAL_COMMENTS
, DATE_RECEIVED
, DEALER_CODE
, DEAL_DATE
, DEAL_LINKING_CODE
, DEAL_NUMBER
, DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON
, ENDORSER_CODE
, ACCEPTOR_CODE
, ACCEPTOR_NAME
, ACCRUAL_FROM
, ACCRUAL_TO
, ACCUM_INTEREST
, ACCUM_INTEREST_BF
, ACCUM_INTEREST_BF_HCE
, ACCUM_INTEREST_HCE
, ACCUM_INT_ACCOUNT_NO
, EXTERNAL_CPARTY_NO
, FID_TAX
, FID_TAX_HCE
, INTEREST
, INTEREST_FREQ
, INTEREST_HCE
, INTEREST_RATE
, INTEREST_SETTLED
, INTEREST_SETTLEMENT_TYPE
, INTERNAL_TICKET_NO
, ISSUER_ADVICE
, LIMIT_CODE
, MATURITY_DATE
, NI_PROFIT_LOSS
, NI_PROFIT_LOSS_HCE
, NI_RENEG_DATE
, NO_OF_DAYS
, OLD_PRODUCT_TYPE
, PARCEL_SPLIT_NO
, PARENT_PARTY
, PI_AMOUNT_DUE
, PI_AMOUNT_RECEIVED
, PORTFOLIO_CODE
, PRINCIPAL_ACCOUNT_NO
, PRINCIPAL_ACTION
, PRINCIPAL_ADJUST_HCE
, PRINCIPAL_AMOUNT_TYPE
, PRINTED_CPARTY_ADVICE
, PRINTED_REDEMPTION_YN
, PRINTED_YN
, PRODUCT_TYPE
, QUICK_INPUT
, RATE_EFFECTIVE_CREATED
, RENEG_ONLY_LETTER
, REPAY_AMOUNT
, REPAY_AMOUNT_HCE
, SECURITY_TYPE
, SETTLEMENT_TYPE
, SETTLE_DATE
, SETTLE_TERM_INTEREST
, START_DATE
, STATUS_CODE
, TAX_AMOUNT
, TAX_AMOUNT_HCE
, TAX_CODE
, TAX_RATE
, CROSS_REF_TO_TRANS
, CURRENCY
, COMMENTS
, COMPANY_CODE
, CPARTY_ADVICE
, CPARTY_CODE
, CREATED_BY
, CREATED_ON
, ENDORSER_NAME
, RATE_FIXING_DATE
FROM APPS.XTR_A_ROLLOVER_TRANSACTIONS_V;
APPS.XTR_A_ROLLOVER_TRANSACTIONS_V is not referenced by any database object
|
|
|