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

Object Details

Object Name:	FIIBV_PA_REVENUE_F_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FIIBV_PA_REVENUE_F_FCV
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

FIIBV_PA_REVENUE_F_FCV is the EDW Project Revenue fact base view

[View Source]

Columns

Name	Datatype	Length	Comments
SEQ_ID	VARCHAR2	(0)	This column is for internal use only
VIEW_TYPE	CHAR	(3)	This column is for internal use only
REVENUE_PK	VARCHAR2	(198)	Unique identifier
REVENUE_G	VARCHAR2	(0)	Revenue (global currency)
REVENUE_B	NUMBER	(22)	Revenue (functional currency)
INSTANCE_FK	VARCHAR2	(30)	Foreign key for the Instance dimension
SET_OF_BOOKS_FK	VARCHAR2	(71)	Foreign key for the Set Of Books dimension
PROJECT_FK	VARCHAR2	(78)	Foreign key for the Project dimension
PROJECT_ORG_FK	VARCHAR2	(0)	Foreign key for the Organization dimension (task owning organization)
CUSTOMER_FK	VARCHAR2	(86)	Foreign key for the Trading Partner dimension
CURRENCY_GL_FK	VARCHAR2	(15)	Foreign key for the Currency dimension (functional currency)
GL_DATE_FK	VARCHAR2	(76)	Foreign key for the Time dimension (GL date)
PA_DATE_FK	VARCHAR2	(76)	Foreign key for the Time dimension (PA date)
TRANSACTION_DATE_FK	VARCHAR2	(76)	Foreign key for the Time dimension (transaction date)
GL_ACCT1_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
GL_ACCT2_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
GL_ACCT3_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
GL_ACCT4_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
GL_ACCT5_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
GL_ACCT6_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
GL_ACCT7_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
GL_ACCT8_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
GL_ACCT9_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
GL_ACCT10_FK	CHAR	(6)	Foreign key for the Accounting Flexfield dimension
SET_OF_BOOKS_ID	NUMBER	(15)	Set of books identifier
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Chart of accounts identifier
CODE_COMBINATION_ID	NUMBER	(15)	Accounting flexfield code combination identifier
GLOBAL_CURRENCY_RATE	NUMBER		Exchange rate between functional currency and global currency
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
_DF:AGR:_EDW	CHAR	(33)	This column is for internal use only
_DF:TSK:_EDW	CHAR	(27)	This column is for internal use only
_DF:EVN:_EDW	VARCHAR2	(36)	This column is for internal use only
_DF:EXI:_EDW	VARCHAR2	(47)	This column is for internal use only
_DF:SOB:_EDW	CHAR	(30)	This column is for internal use only
_KF:GL_ACCT_NUM:RDL:_EDW	CHAR	(17)	This column is for internal use only

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
,      CHART_OF_ACCOUNTS_ID
,      CODE_COMBINATION_ID
,      GLOBAL_CURRENCY_RATE
,      LAST_UPDATE_DATE
,      _DF:AGR:_EDW
,      _DF:TSK:_EDW
,      _DF:EVN:_EDW
,      _DF:EXI:_EDW
,      _DF:SOB:_EDW
,      _KF:GL_ACCT_NUM:RDL:_EDW
FROM APPS.FIIBV_PA_REVENUE_F_FCV;

Dependencies

[top of page]

APPS.FIIBV_PA_REVENUE_F_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; EDW_LOCAL_INSTANCE; FII_PA_REVENUE_EVT_PK; FII_PA_REVENUE_EXP_PK; GL_CODE_COMBINATIONS; GL_SETS_OF_BOOKS; PA_AGREEMENTS_ALL; PA_CUST_EVENT_RDL_ALL; PA_CUST_REV_DIST_LINES_ALL; PA_DRAFT_REVENUES_ALL; PA_EVENTS; PA_EXPENDITURE_ITEMS_ALL; PA_IMPLEMENTATIONS_ALL; PA_PROJECTS_ALL; PA_TASKS

APPS.FIIBV_PA_REVENUE_F_FCV is referenced by following:

APPS: FII_PA_REVENUE_F_FCV