[Home] [Help] [Dependency Information]
Object Name: | PA_PROJ_TYPE_DISTRIBUTIONS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_PROJ_TYPE_DISTRIBUTIONS_ALL |
Subobject Name: | |
Status: | VALID |
PA_PROJ_TYPE_DISTRIBUTIONS_ALL stores the distribution
rules that you associate with each project type during
implementation. When a project is defined with a
given project type, the only valid distribution rules
that can be assigned to the project are the ones
listed in this table for that project type.
.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_PROJECT_TYPE_DISTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROJECT_TYPE
DISTRIBUTION_RULE ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_TYPE | VARCHAR2 | (20) | Yes | The project type that is assigned the distribution rule |
DISTRIBUTION_RULE | VARCHAR2 | (20) | Yes | The distribution rule that is assigned to the project type |
DEFAULT_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates the default distribution rule for this project type. Each project type can have one default distribution rule |
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 |
ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_TYPE
, DISTRIBUTION_RULE
, DEFAULT_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORG_ID
FROM PA.PA_PROJ_TYPE_DISTRIBUTIONS_ALL;
PA.PA_PROJ_TYPE_DISTRIBUTIONS_ALL does not reference any database object
PA.PA_PROJ_TYPE_DISTRIBUTIONS_ALL is referenced by following:
|
|
|