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.FII_PA_REVENUE_F_FCV

Object Details

Object Name:	FII_PA_REVENUE_F_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FII_PA_REVENUE_F_FCV
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	Comments
SEQ_ID	VARCHAR2	(0)
VIEW_TYPE	CHAR	(3)
REVENUE_PK	VARCHAR2	(198)
REVENUE_G	VARCHAR2	(0)
REVENUE_B	NUMBER	(22)
INSTANCE_FK	VARCHAR2	(30)
SET_OF_BOOKS_FK	VARCHAR2	(71)
PROJECT_FK	VARCHAR2	(78)
PROJECT_ORG_FK	VARCHAR2	(0)
CUSTOMER_FK	VARCHAR2	(86)
CURRENCY_GL_FK	VARCHAR2	(15)
GL_DATE_FK	VARCHAR2	(76)
PA_DATE_FK	VARCHAR2	(76)
TRANSACTION_DATE_FK	VARCHAR2	(76)
GL_ACCT1_FK	VARCHAR2	(3775)
GL_ACCT2_FK	VARCHAR2	(3775)
GL_ACCT3_FK	VARCHAR2	(3775)
GL_ACCT4_FK	VARCHAR2	(3775)
GL_ACCT5_FK	VARCHAR2	(3775)
GL_ACCT6_FK	VARCHAR2	(3775)
GL_ACCT7_FK	VARCHAR2	(3775)
GL_ACCT8_FK	VARCHAR2	(3775)
GL_ACCT9_FK	VARCHAR2	(3775)
GL_ACCT10_FK	VARCHAR2	(3775)
SET_OF_BOOKS_ID	NUMBER	(15)
GLOBAL_CURRENCY_RATE	NUMBER
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
USER_MEASURE1	NUMBER
USER_MEASURE2	NUMBER
USER_MEASURE3	NUMBER
USER_MEASURE4	NUMBER
USER_MEASURE5	NUMBER
USER_ATTRIBUTE1	VARCHAR2	(0)
USER_ATTRIBUTE2	VARCHAR2	(0)
USER_ATTRIBUTE3	VARCHAR2	(0)
USER_ATTRIBUTE4	VARCHAR2	(0)
USER_ATTRIBUTE5	VARCHAR2	(0)
USER_ATTRIBUTE6	VARCHAR2	(0)
USER_ATTRIBUTE7	VARCHAR2	(0)
USER_ATTRIBUTE8	VARCHAR2	(0)
USER_ATTRIBUTE9	VARCHAR2	(0)
USER_ATTRIBUTE10	VARCHAR2	(0)
USER_FK1	CHAR	(6)
USER_FK2	CHAR	(6)
USER_FK3	CHAR	(6)
USER_FK4	CHAR	(6)
USER_FK5	CHAR	(6)

Query Text

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


SELECT SEQ_ID
,      VIEW_TYPE
,      REVENUE_PK
,      REVENUE_G
,      REVENUE_B
,      INSTANCE_FK
,      SET_OF_BOOKS_FK
,      PROJECT_FK
,      PROJECT_ORG_FK
,      CUSTOMER_FK
,      CURRENCY_GL_FK
,      GL_DATE_FK
,      PA_DATE_FK
,      TRANSACTION_DATE_FK
,      GL_ACCT1_FK
,      GL_ACCT2_FK
,      GL_ACCT3_FK
,      GL_ACCT4_FK
,      GL_ACCT5_FK
,      GL_ACCT6_FK
,      GL_ACCT7_FK
,      GL_ACCT8_FK
,      GL_ACCT9_FK
,      GL_ACCT10_FK
,      SET_OF_BOOKS_ID
,      GLOBAL_CURRENCY_RATE
,      LAST_UPDATE_DATE
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
FROM APPS.FII_PA_REVENUE_F_FCV;

Dependencies

[top of page]

APPS.FII_PA_REVENUE_F_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; FIIBV_PA_REVENUE_F_FCV; FII_FLEX_MAPPING - show dependent code

APPS.FII_PA_REVENUE_F_FCV is referenced by following:

APPS: FII_PA_REVENUE_F_C - show dependent code