DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.XTR_A_ROLLOVER_TRANSACTIONS_V

Object Details
Object Name: XTR_A_ROLLOVER_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_A_ROLLOVER_TRANSACTIONS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.XTR_A_ROLLOVER_TRANSACTIONS_V references the following:

SchemaAPPS
SynonymXTR_A_ROLLOVER_TRANSACTIONS

APPS.XTR_A_ROLLOVER_TRANSACTIONS_V is not referenced by any database object