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_RBS_PRJ_ASSIGNMENTS

Object Details

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

This table stores information about resource breakdown structures (RBS) and the projects with which they are associated. It stores the usages, such as workplan, financial plan, reporting, for an RBS on a project.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_RBS_PRJ_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_SEED	RBS_PRJ_ASSIGNMENT_ID
PA_RBS_PRJ_ASSIGNMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	RBS_VERSION_ID
PA_RBS_PRJ_ASSIGNMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RBS_PRJ_ASSIGNMENT_ID	NUMBER	(15)	Yes	Unique identifier of the RBS association.
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the Project to which the RBS is associated.
RBS_VERSION_ID	NUMBER	(15)	Yes	Identifier of the RBS version to which the project is associated.
RBS_HEADER_ID	NUMBER	(15)	Yes	Identifier of the RBS to which the project is associated.
REPORTING_USAGE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the RBS is used for reporting always Y.
WP_USAGE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the RBS is used for Financial Planning.
FP_USAGE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the RBS is used for work plan.
PROG_REP_USAGE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the RBS is used for program reporting.
PRIMARY_REPORTING_RBS_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the RBS is the default RBS to be displayed on reporting pages.
ASSIGNMENT_STATUS	VARCHAR2	(30)	Yes	Indicates the status of the RBS association ACTIVE or OBSOLETE..
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.
RECORD_VERSION_NUMBER	NUMBER	(15)	Yes	Apps Standard for locking from HTML..

Query Text

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


SELECT RBS_PRJ_ASSIGNMENT_ID
,      PROJECT_ID
,      RBS_VERSION_ID
,      RBS_HEADER_ID
,      REPORTING_USAGE_FLAG
,      WP_USAGE_FLAG
,      FP_USAGE_FLAG
,      PROG_REP_USAGE_FLAG
,      PRIMARY_REPORTING_RBS_FLAG
,      ASSIGNMENT_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
FROM PA.PA_RBS_PRJ_ASSIGNMENTS;

Dependencies

[top of page]

PA.PA_RBS_PRJ_ASSIGNMENTS does not reference any database object

PA.PA_RBS_PRJ_ASSIGNMENTS is referenced by following:

PA: PA_RBS_PRJ_ASSIGNMENTS#