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]

TABLE: PA.PA_FP_UPGRADE_AUDIT

Object Details

Object Name:	PA_FP_UPGRADE_AUDIT
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_FP_UPGRADE_AUDIT
Subobject Name:
Status:	VALID

This table stores information about upgraded budget types for a project.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FP_UPGRADE_AUDIT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID UPGRADED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)		Unique identifier of the project
BUDGET_TYPE_CODE	VARCHAR2	(30)		identifier of the budget type
PROJ_FP_OPTIONS_ID	NUMBER	(15)		Identifier of financial planning option created
FIN_PLAN_OPTION_LEVEL_CODE	VARCHAR2	(30)		Planning level for the financial plan option
BASIS_COST_VERSION_ID	NUMBER	(15)		identifier of the budget version using which the cost elements are created
BASIS_REV_VERSION_ID	NUMBER	(15)		identifier of the budget version using which the revenue elements are created
BASIS_COST_BEM	VARCHAR2	(30)		Unique identifier of budget entry method using which the cost options are set
BASIS_REV_BEM	VARCHAR2	(30)		Unique identifier of budget entry method using which the revenue options are set
REQUEST_ID	NUMBER	(15)		Concurrent request id of the upgrade process
UPGRADED_FLAG	VARCHAR2	(1)		Indicates if the upgrade was successful or not. Y or N
FAILURE_REASON_CODE	VARCHAR2	(30)		Indicates the failure reason code for upgrade.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
PROJ_FP_OPTIONS_ID_RUP	NUMBER	(15)		Unique Identifier of financial planning option record that is rolled up using Optional Upgrade

Query Text

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


SELECT PROJECT_ID
,      BUDGET_TYPE_CODE
,      PROJ_FP_OPTIONS_ID
,      FIN_PLAN_OPTION_LEVEL_CODE
,      BASIS_COST_VERSION_ID
,      BASIS_REV_VERSION_ID
,      BASIS_COST_BEM
,      BASIS_REV_BEM
,      REQUEST_ID
,      UPGRADED_FLAG
,      FAILURE_REASON_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROJ_FP_OPTIONS_ID_RUP
FROM PA.PA_FP_UPGRADE_AUDIT;

Dependencies

[top of page]

PA.PA_FP_UPGRADE_AUDIT does not reference any database object

PA.PA_FP_UPGRADE_AUDIT is referenced by following:

APPS: PA_FP_UPGRADE_AUDIT