[Home] [Help] [Dependency Information]
Object Name: | PA_PROJECT_COPY_OVERRIDES |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_PROJECT_COPY_OVERRIDES |
Subobject Name: | |
Status: | VALID |
PA_PROJECT_COPY_OVERRIDES stores the Quick Entry options for project
templates, which are used when copying a project/template.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_PROJECT_COPY_OVERRIDES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROJECT_ID
SORT_ORDER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | The identifier of the project template for which the options are created |
FIELD_NAME | VARCHAR2 | (30) | Yes | The Quick Entry option code. |
DISPLAY_NAME | VARCHAR2 | (80) | Yes | The name which gets displayed to the user while entering the Quick Entry options. |
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 |
LIMITING_VALUE | VARCHAR2 | (30) | Holds the restricting value that limits the number of times the optioncan be entered through the Quick Entry screen. This is applicable only forcertain options such as Customer Name and Key Member classification. | |
SORT_ORDER | NUMBER | Holds the ordering sequence of the option that gets displayed | ||
MANDATORY_FLAG | VARCHAR2 | (1) | Indicates whether a value for that option is required to be entered while copying projects | |
RECORD_VERSION_NUMBER | NUMBER | Sequence number for lock strategy in self-service applications. |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, FIELD_NAME
, DISPLAY_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LIMITING_VALUE
, SORT_ORDER
, MANDATORY_FLAG
, RECORD_VERSION_NUMBER
FROM PA.PA_PROJECT_COPY_OVERRIDES;
PA.PA_PROJECT_COPY_OVERRIDES does not reference any database object
PA.PA_PROJECT_COPY_OVERRIDES is referenced by following:
|
|
|