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


VIEW: APPS.XTR_A_BANK_ACCOUNTS_V

Object Details
Object Name: XTR_A_BANK_ACCOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_A_BANK_ACCOUNTS_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
ACCOUNT_NUMBER VARCHAR2 (20) Yes
PARTY_CODE VARCHAR2 (7) Yes
CURRENCY VARCHAR2 (15) Yes
BANK_NAME VARCHAR2 (50)
BANK_SHORT_CODE VARCHAR2 (80) Yes
LOCATION VARCHAR2 (35) Yes
STREET VARCHAR2 (35) Yes
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
CODE_COMBINATION_ID NUMBER (15)
GL_COMPANY_CODE VARCHAR2 (7)
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

OPENING_BALANCE NUMBER

OPENING_BAL_HCE NUMBER

STATEMENT_DATE DATE

DEFAULT_ACCT VARCHAR2 (1)
PARTY_TYPE VARCHAR2 (2)
AUTHORISED VARCHAR2 (1)
SETOFF VARCHAR2 (5)
BANK_CODE VARCHAR2 (7)
PARTY_PRIN_CCID NUMBER (15)
PARTY_INT_CCID NUMBER (15)
INTERNAL_PTY VARCHAR2 (1)
SETOFF_COMPANY VARCHAR2 (7)
SETOFF_ACCOUNT_YN VARCHAR2 (1)
INTEREST_CALCULATION_BASIS VARCHAR2 (4)
PORTFOLIO_CODE VARCHAR2 (7)
PRIMARY_SETTLEMENT_METHOD VARCHAR2 (15)
DIRECT_DEBIT_AUTHORITY VARCHAR2 (1)
EFT_SCRIPT_NAME VARCHAR2 (50)
EFT_SCRIPT_OUTPUT_PATH VARCHAR2 (50)
SUB_ACCOUNT_AT VARCHAR2 (100)
SUB_ACCOUNT_NUMBER VARCHAR2 (20)
CASHFLOWS_TO_CURRENT_DATE NUMBER

CURRENT_CASHFLOW_DATE DATE

PROJECTED_BALANCE NUMBER

PROJECTED_BALANCE_DATE DATE

PROJECTED_BALANCE_UPDATED_ON DATE

INTEREST_RATE NUMBER

AUDIT_INDICATOR VARCHAR2 (1)
AUDIT_DATE_STORED DATE

DOMICILED_CURRENCY VARCHAR2 (15)
LIMIT_CODE VARCHAR2 (7)
YEAR_CALC_BASIS VARCHAR2 (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCOUNT_NUMBER
,      PARTY_CODE
,      CURRENCY
,      BANK_NAME
,      BANK_SHORT_CODE
,      LOCATION
,      STREET
,      CREATED_BY
,      CREATED_ON
,      CODE_COMBINATION_ID
,      GL_COMPANY_CODE
,      UPDATED_BY
,      UPDATED_ON
,      OPENING_BALANCE
,      OPENING_BAL_HCE
,      STATEMENT_DATE
,      DEFAULT_ACCT
,      PARTY_TYPE
,      AUTHORISED
,      SETOFF
,      BANK_CODE
,      PARTY_PRIN_CCID
,      PARTY_INT_CCID
,      INTERNAL_PTY
,      SETOFF_COMPANY
,      SETOFF_ACCOUNT_YN
,      INTEREST_CALCULATION_BASIS
,      PORTFOLIO_CODE
,      PRIMARY_SETTLEMENT_METHOD
,      DIRECT_DEBIT_AUTHORITY
,      EFT_SCRIPT_NAME
,      EFT_SCRIPT_OUTPUT_PATH
,      SUB_ACCOUNT_AT
,      SUB_ACCOUNT_NUMBER
,      CASHFLOWS_TO_CURRENT_DATE
,      CURRENT_CASHFLOW_DATE
,      PROJECTED_BALANCE
,      PROJECTED_BALANCE_DATE
,      PROJECTED_BALANCE_UPDATED_ON
,      INTEREST_RATE
,      AUDIT_INDICATOR
,      AUDIT_DATE_STORED
,      DOMICILED_CURRENCY
,      LIMIT_CODE
,      YEAR_CALC_BASIS
FROM APPS.XTR_A_BANK_ACCOUNTS_V;

Dependencies

[top of page]

APPS.XTR_A_BANK_ACCOUNTS_V references the following:

SchemaAPPS
SynonymXTR_A_BANK_ACCOUNTS

APPS.XTR_A_BANK_ACCOUNTS_V is not referenced by any database object