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

TABLE: PA.PA_RESOURCE_FORMAT_RANKS

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


PA_RESOURCE_FORMAT_RANKS stores the predefined ranks for each resource
format and transaction class code (system
linkage function and event type classification) combination,
which are used to map transactions to resources in the Update Project
Summary Amounts processes. All data in this table is predefined by
Oracle Projects.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_RESOURCE_FORMAT_RANKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_FORMAT_ID
ColumnTXN_CLASS_CODE
Columns
Name Datatype Length Mandatory Comments
RESOURCE_FORMAT_ID NUMBER (15) Yes The identifier of resource format
TXN_CLASS_CODE VARCHAR2 (30) Yes Class of Txn. i.e. System linkage function or event types for events
RANK NUMBER (15) Yes Resource format rank. The lower the rank, the higher is the priority
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Column
Query Text

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


SELECT RESOURCE_FORMAT_ID
,      TXN_CLASS_CODE
,      RANK
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_RESOURCE_FORMAT_RANKS;

Dependencies

[top of page]

PA.PA_RESOURCE_FORMAT_RANKS does not reference any database object

PA.PA_RESOURCE_FORMAT_RANKS is referenced by following:

SchemaAPPS
SynonymPA_RESOURCE_FORMAT_RANKS