DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_RBS_VERSIONS_TL

Object Details
Object Name: PA_RBS_VERSIONS_TL
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_RBS_VERSIONS_TL
Subobject Name:
Status: VALID


This table provides multi-lingual support (MLS) for resource breakdown structure (RBS) version information (name and description) in Oracle Projects. The primary key is RBS_VERSION_ID and LANGUAGE. The non-translated information is in the table PA_RBS_VERSIONS_B.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_RBS_VERSIONS_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRBS_VERSION_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
RBS_VERSION_ID NUMBER (15) Yes Unique identifier of the RBS version.
NAME VARCHAR2 (240) Yes The name of the RBS version.
DESCRIPTION VARCHAR2 (2000)
The description of the RBS version.
LANGUAGE VARCHAR2 (4) Yes Language of display.
SOURCE_LANG VARCHAR2 (4) Yes Language of source.
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
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column.
Query Text

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


SELECT RBS_VERSION_ID
,      NAME
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_RBS_VERSIONS_TL;

Dependencies

[top of page]

PA.PA_RBS_VERSIONS_TL does not reference any database object

PA.PA_RBS_VERSIONS_TL is referenced by following:

SchemaPA
ViewPA_RBS_VERSIONS_TL#