[Home] [Help] [Dependency Information]
Object Name: | PA_ROLE_STATUS_MENU_MAP |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_ROLE_STATUS_MENU_MAP |
Subobject Name: | |
Status: | VALID |
This table is used to support status-based security for a role by allowing a user to limit actions that can be performed by a role depending on a project's status
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_ROLE_STATUS_MENU_MAP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ROLE_STATUS_MENU_ID |
PA_ROLE_STATUS_MENU_MAP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ROLE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROLE_STATUS_MENU_ID | NUMBER | (15) | Yes | Primary key column from a sequence |
ROLE_ID | NUMBER | (15) | Yes | Role for which there is mapping at the status level |
STATUS_TYPE | VARCHAR2 | (30) | Yes | Status Type (from PA_PROJECT_STATUSES) for which there is mapping to menus. The only value currently supported is status type of PROJECT |
STATUS_CODE | VARCHAR2 | (30) | Yes | Status code (from PA_PROJECT_STATUSES) to which the menu is associated. |
MENU_ID | NUMBER | (15) | Yes | Identifier of the menu. |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | APPS Standard - used for locking. |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROLE_STATUS_MENU_ID
, ROLE_ID
, STATUS_TYPE
, STATUS_CODE
, MENU_ID
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM PA.PA_ROLE_STATUS_MENU_MAP;
PA.PA_ROLE_STATUS_MENU_MAP does not reference any database object
PA.PA_ROLE_STATUS_MENU_MAP is referenced by following:
|
|
|