[Home] [Help] [Dependency Information]
Object Name: | PA_ORG_HIERARCHY_DENORM |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_ORG_HIERARCHY_DENORM |
Subobject Name: | |
Status: | VALID |
This table stores deflated structure of organization hierarchy for all Expenditure, Project and Reporting start organizations in pa_implementations_all table.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_ORG_HIERARCHY_DENORM_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
PARENT_ORGANIZATION_ID
CHILD_ORGANIZATION_ID ORG_HIERARCHY_VERSION_ID PA_ORG_USE_TYPE ORG_ID |
PA_ORG_HIERARCHY_DENORM_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
CHILD_ORGANIZATION_ID
PARENT_ORGANIZATION_ID PA_ORG_USE_TYPE ORG_ID |
PA_ORG_HIERARCHY_DENORM_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED |
PA_ORG_USE_TYPE
ORG_HIERARCHY_VERSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_ORGANIZATION_ID | NUMBER | Yes | Identifier of the parent organization | |
CHILD_ORGANIZATION_ID | NUMBER | Yes | Identifier of the child organization | |
ORG_HIERARCHY_VERSION_ID | NUMBER | Yes | Identifier of the organization hierarchy version | |
PA_ORG_USE_TYPE | VARCHAR2 | (30) | Yes | The purpose for which the organization is used in PA |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who column | |
PARENT_LEVEL | NUMBER | (15) | Stores the level of the parent organization | |
CHILD_LEVEL | NUMBER | (15) | Stores the level of the child organization | |
ORG_ID | NUMBER | (15) | stores the OU of the reporting hierarchy |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_ORGANIZATION_ID
, CHILD_ORGANIZATION_ID
, ORG_HIERARCHY_VERSION_ID
, PA_ORG_USE_TYPE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PARENT_LEVEL
, CHILD_LEVEL
, ORG_ID
FROM PA.PA_ORG_HIERARCHY_DENORM;
PA.PA_ORG_HIERARCHY_DENORM does not reference any database object
PA.PA_ORG_HIERARCHY_DENORM is referenced by following:
|
|
|