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_COST_F_FCV

Object Details

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

View Type

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

FIIBV_PA_COST_F_FCV is the EDW Project Cost fact base view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQ_ID	VARCHAR2	(0)		This column is for internal use only
COST_PK	VARCHAR2	(112)		Unique identifier
RAW_COST_G	VARCHAR2	(0)		Raw cost (global currency)
RAW_COST_B	NUMBER			Raw cost (functional currency)
RAW_COST_T	NUMBER			Raw cost (transaction currency)
BURDENED_COST_G	VARCHAR2	(0)		Burdened cost (global currency)
BURDENED_COST_B	NUMBER			Burdened cost (functional currency)
BURDENED_COST_T	NUMBER			Burdened cost (transaction currency)
QUANTITY	NUMBER	(22)	Yes	Quantity (in transaction unit of measure)
BILLABLE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether this transaction is billable
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	(71)		Foreign key for the Project dimension
PROJECT_ORG_FK	VARCHAR2	(0)		Foreign key for the Organization dimension (task owning organization)
EXPENDITURE_ORG_FK	VARCHAR2	(71)		Foreign key for the Organization dimension (expenditure organization)
EXPENDITURE_TYPE_FK	VARCHAR2	(61)		Foreign key for the Expenditure Type dimension
CURRENCY_GL_FK	VARCHAR2	(15)		Foreign key for the Currency dimension (functional currency)
CURRENCY_TRX_FK	VARCHAR2	(15)		Foreign key for the Currency dimension (transaction currency)
EMPLOYEE_FK	VARCHAR2	(85)		Foreign key for the Person dimension
UNIT_OF_MEASURE_FK	VARCHAR2	(4000)		Foreign key for the Unit Of Measure dimension
TRANSACTION_DATE_FK	VARCHAR2	(76)		Foreign key for the Time dimension (transaction date)
PA_DATE_FK	VARCHAR2	(76)		Foreign key for the Time dimension (PA date)
GL_DATE_FK	VARCHAR2	(76)		Foreign key for the Time dimension (GL 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)	Yes	Set of books identifier
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	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:EXI:_EDW	CHAR	(40)		This column is for internal use only
_DF:EXP:_EDW	CHAR	(35)		This column is for internal use only
_DF:EXT:_EDW	CHAR	(40)		This column is for internal use only
_DF:TSK:_EDW	CHAR	(27)		This column is for internal use only
_DF:SOB:_EDW	CHAR	(30)		This column is for internal use only
_KF:GL_ACCT_NUM:CDL:_EDW	CHAR	(17)		This column is for internal use only
FROM_CURRENCY	VARCHAR2	(15)		Currency used by edw_currency.get_rate api to calculate GLOBAL_CURRENCY_RATE.
TRANSACTION_DATE	DATE		Yes	Date used by edw_currency.get_rate api to calculate GLOBAL_CURRENCY_RATE.

Query Text

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


SELECT SEQ_ID
,      COST_PK
,      RAW_COST_G
,      RAW_COST_B
,      RAW_COST_T
,      BURDENED_COST_G
,      BURDENED_COST_B
,      BURDENED_COST_T
,      QUANTITY
,      BILLABLE_FLAG
,      INSTANCE_FK
,      SET_OF_BOOKS_FK
,      PROJECT_FK
,      PROJECT_ORG_FK
,      EXPENDITURE_ORG_FK
,      EXPENDITURE_TYPE_FK
,      CURRENCY_GL_FK
,      CURRENCY_TRX_FK
,      EMPLOYEE_FK
,      UNIT_OF_MEASURE_FK
,      TRANSACTION_DATE_FK
,      PA_DATE_FK
,      GL_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:EXI:_EDW
,      _DF:EXP:_EDW
,      _DF:EXT:_EDW
,      _DF:TSK:_EDW
,      _DF:SOB:_EDW
,      _KF:GL_ACCT_NUM:CDL:_EDW
,      FROM_CURRENCY
,      TRANSACTION_DATE
FROM APPS.FIIBV_PA_COST_F_FCV;

Dependencies

[top of page]

APPS.FIIBV_PA_COST_F_FCV references the following:

APPS: EDW_CURRENCY - show dependent code; EDW_LOCAL_INSTANCE; EDW_UTIL - show dependent code; FII_PA_COST_PK; GL_CODE_COMBINATIONS; GL_SETS_OF_BOOKS; PA_COST_DISTRIBUTION_LINES_ALL; PA_EXPENDITURES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_EXPENDITURE_TYPES; PA_IMPLEMENTATIONS_ALL; PA_TASKS

APPS.FIIBV_PA_COST_F_FCV is referenced by following:

APPS: FII_PA_COST_F_FCV