[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMW_LATEST_HIERARCHY_ORG_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  AMW.AMW_LATEST_HIERARCHY_ORG_V
|
| 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;
APPS
AMW_LATEST_HIERARCHIES
AMW_PROCESS_ORGANIZATION_VL
APPS
AMW_CREATE_LINES_PKG
- show dependent code
AMW_ORG_HIERARCHY_PKG
- show dependent code
AMW_PROC_ORG_APPROVAL_PKG
- show dependent code
|
|
|
|