eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CE_FC_AMTS_BANK_V

Object Details

Object Name:	CE_FC_AMTS_BANK_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_FC_AMTS_BANK_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
BANK_ACCOUNT_NAME	VARCHAR2	(100)
BANK_ACCOUNT_NUM	VARCHAR2	(30)
BANK_CURRENCY_CODE	VARCHAR2	(15)
BANK_ACCOUNT	VARCHAR2	(149)
OTHERS_FLAG	NUMBER
BANK_ACCOUNT_ID	NUMBER
OPENING_BALANCE	NUMBER
BALANCE_DATE	DATE
PRIOR_DAY_CFLOW	NUMBER
NET_CASHFLOW	NUMBER
CLOSING_BALANCE	NUMBER
FORECAST_ID	NUMBER	(15)	Yes
FCAMT0	NUMBER
FCAMT1	NUMBER
FCAMT2	NUMBER
FCAMT3	NUMBER
FCAMT4	NUMBER
FCAMT5	NUMBER
FCAMT6	NUMBER
FCAMT7	NUMBER
FCAMT8	NUMBER
FCAMT9	NUMBER
FCAMT10	NUMBER
FCAMT11	NUMBER
FCAMT12	NUMBER
FCAMT13	NUMBER
FCAMT14	NUMBER
FCAMT15	NUMBER
FCAMT16	NUMBER
FCAMT17	NUMBER
FCAMT18	NUMBER
FCAMT19	NUMBER
FCAMT20	NUMBER
FCAMT21	NUMBER
FCAMT22	NUMBER
FCAMT23	NUMBER
FCAMT24	NUMBER
FCAMT25	NUMBER
FCAMT26	NUMBER
FCAMT27	NUMBER
FCAMT28	NUMBER
FCAMT29	NUMBER
FCAMT30	NUMBER
FCAMT31	NUMBER
FCAMT32	NUMBER
FCAMT33	NUMBER
FCAMT34	NUMBER
FCAMT35	NUMBER
FCAMT36	NUMBER
FCAMT37	NUMBER
FCAMT38	NUMBER
FCAMT39	NUMBER
FCAMT40	NUMBER
FCAMT41	NUMBER
FCAMT42	NUMBER
FCAMT43	NUMBER
FCAMT44	NUMBER
FCAMT45	NUMBER
FCAMT46	NUMBER
FCAMT47	NUMBER
FCAMT48	NUMBER
FCAMT49	NUMBER
FCAMT50	NUMBER
FCAMT51	NUMBER
FCAMT52	NUMBER
FCAMT53	NUMBER
FCAMT54	NUMBER
FCAMT55	NUMBER
FCAMT56	NUMBER
FCAMT57	NUMBER
FCAMT58	NUMBER
FCAMT59	NUMBER
FCAMT60	NUMBER
FCAMT61	NUMBER
FCAMT62	NUMBER
FCAMT63	NUMBER
FCAMT64	NUMBER
FCAMT65	NUMBER
FCAMT66	NUMBER
FCAMT67	NUMBER
FCAMT68	NUMBER
FCAMT69	NUMBER
FCAMT70	NUMBER
FCAMT71	NUMBER
FCAMT72	NUMBER
FCAMT73	NUMBER
FCAMT74	NUMBER
FCAMT75	NUMBER
FCAMT76	NUMBER
FCAMT77	NUMBER
FCAMT78	NUMBER
FCAMT79	NUMBER
FCAMT80	NUMBER
XTR_USER	VARCHAR2	(1)

Query Text

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


SELECT BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BANK_CURRENCY_CODE
,      BANK_ACCOUNT
,      OTHERS_FLAG
,      BANK_ACCOUNT_ID
,      OPENING_BALANCE
,      BALANCE_DATE
,      PRIOR_DAY_CFLOW
,      NET_CASHFLOW
,      CLOSING_BALANCE
,      FORECAST_ID
,      FCAMT0
,      FCAMT1
,      FCAMT2
,      FCAMT3
,      FCAMT4
,      FCAMT5
,      FCAMT6
,      FCAMT7
,      FCAMT8
,      FCAMT9
,      FCAMT10
,      FCAMT11
,      FCAMT12
,      FCAMT13
,      FCAMT14
,      FCAMT15
,      FCAMT16
,      FCAMT17
,      FCAMT18
,      FCAMT19
,      FCAMT20
,      FCAMT21
,      FCAMT22
,      FCAMT23
,      FCAMT24
,      FCAMT25
,      FCAMT26
,      FCAMT27
,      FCAMT28
,      FCAMT29
,      FCAMT30
,      FCAMT31
,      FCAMT32
,      FCAMT33
,      FCAMT34
,      FCAMT35
,      FCAMT36
,      FCAMT37
,      FCAMT38
,      FCAMT39
,      FCAMT40
,      FCAMT41
,      FCAMT42
,      FCAMT43
,      FCAMT44
,      FCAMT45
,      FCAMT46
,      FCAMT47
,      FCAMT48
,      FCAMT49
,      FCAMT50
,      FCAMT51
,      FCAMT52
,      FCAMT53
,      FCAMT54
,      FCAMT55
,      FCAMT56
,      FCAMT57
,      FCAMT58
,      FCAMT59
,      FCAMT60
,      FCAMT61
,      FCAMT62
,      FCAMT63
,      FCAMT64
,      FCAMT65
,      FCAMT66
,      FCAMT67
,      FCAMT68
,      FCAMT69
,      FCAMT70
,      FCAMT71
,      FCAMT72
,      FCAMT73
,      FCAMT74
,      FCAMT75
,      FCAMT76
,      FCAMT77
,      FCAMT78
,      FCAMT79
,      FCAMT80
,      XTR_USER
FROM APPS.CE_FC_AMTS_BANK_V;

Dependencies

[top of page]

APPS.CE_FC_AMTS_BANK_V references the following:

APPS: CE_BANK_ACCOUNTS; CE_FC_BANK_NETFLOW_V; CE_FORECASTS; CE_FORECAST_OPENING_BAL; CE_LOOKUPS; FND_ACCESS_CONTROL_UTIL - show dependent code; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; MO_GLOBAL - show dependent code; XTR_USER_ACCESS - show dependent code

APPS.CE_FC_AMTS_BANK_V is not referenced by any database object