[Home] [Help]
[Dependency Information]
Object Name: | AMW_LATEST_HIERARCHY_ORG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View for organizations process latest hierarchy
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_PROCESS_ID | NUMBER | Parent process id | ||
PARENT_REVISION_NUMBER | NUMBER | Parent process revision number | ||
PARENT_PROCESS_CODE | VARCHAR2 | (30) | Parent process code | |
PARENT_DISPLAY_NAME | VARCHAR2 | (80) | Parent display name | |
PARENT_PROCESS_ORG_REV_ID | NUMBER | Parent process organization revision identifier | ||
PARENT_APPROVAL_STATUS | VARCHAR2 | (30) | Parent process approval status | |
CHILD_DISPLAY_NAME | VARCHAR2 | (80) | Child process display name | |
CHILD_DESCRIPTION | VARCHAR2 | (240) | Child process descritption | |
CHILD_PROCESS_ID | NUMBER | Child process identifier | ||
CHILD_ORGANIZATION_ID | NUMBER | Child process organization id | ||
CHILD_PROCESS_CODE | VARCHAR2 | (30) | Child process code | |
CHILD_REVISION_NUMBER | NUMBER | Child process revision number | ||
CHILD_PROCESS_ORG_REV_ID | NUMBER | Child organization process revision id | ||
CHILD_APPROVAL_STATUS | VARCHAR2 | (30) | Child process approval status | |
CHILD_START_DATE | DATE | Child process start date | ||
CHILD_APPROVAL_DATE | DATE | Child process approval date | ||
CHILD_APPROVAL_END_DATE | DATE | Child process approval end date | ||
CHILD_END_DATE | DATE | Child process end date | ||
CHILD_CONTROL_COUNT_LATEST | NUMBER | Child process latest control count | ||
CHILD_RISK_COUNT_LATEST | NUMBER | Child process latest risk count | ||
CHILD_SIGNIFICANT_PROCESS_FLAG | VARCHAR2 | (1) | Child process significant process flag | |
CHILD_STANDARD_PROCESS_FLAG | VARCHAR2 | (1) | Child process standard process flag | |
CHILD_CERTIFICATION_STATUS | VARCHAR2 | (30) | Child process certification status | |
CHILD_PROCESS_CATEGORY | VARCHAR2 | (30) | Child process categroy | |
CHILD_PROCESS_OWNER_ID | NUMBER | Child process owner id | ||
CHILD_FINANCE_OWNER_ID | NUMBER | Child process owner id | ||
CHILD_APPLICATION_OWNER_ID | NUMBER | Child application owner id | ||
CHILD_STANDARD_VARIATION | NUMBER | Standard process id | ||
CHILD_PROCESS_TYPE | VARCHAR2 | (10) | Child process process type | |
CHILD_CONTROL_ACTIVITY_TYPE | VARCHAR2 | (30) | Child process control activity type | |
CHILD_ORDER_NUMBER | NUMBER | Child process order number |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_PROCESS_ID
, PARENT_REVISION_NUMBER
, PARENT_PROCESS_CODE
, PARENT_DISPLAY_NAME
, PARENT_PROCESS_ORG_REV_ID
, PARENT_APPROVAL_STATUS
, CHILD_DISPLAY_NAME
, CHILD_DESCRIPTION
, CHILD_PROCESS_ID
, CHILD_ORGANIZATION_ID
, CHILD_PROCESS_CODE
, CHILD_REVISION_NUMBER
, CHILD_PROCESS_ORG_REV_ID
, CHILD_APPROVAL_STATUS
, CHILD_START_DATE
, CHILD_APPROVAL_DATE
, CHILD_APPROVAL_END_DATE
, CHILD_END_DATE
, CHILD_CONTROL_COUNT_LATEST
, CHILD_RISK_COUNT_LATEST
, CHILD_SIGNIFICANT_PROCESS_FLAG
, CHILD_STANDARD_PROCESS_FLAG
, CHILD_CERTIFICATION_STATUS
, CHILD_PROCESS_CATEGORY
, CHILD_PROCESS_OWNER_ID
, CHILD_FINANCE_OWNER_ID
, CHILD_APPLICATION_OWNER_ID
, CHILD_STANDARD_VARIATION
, CHILD_PROCESS_TYPE
, CHILD_CONTROL_ACTIVITY_TYPE
, CHILD_ORDER_NUMBER
FROM APPS.AMW_LATEST_HIERARCHY_ORG_V;
|
|
|