[Home] [Help] [Dependency Information]
Object Name: | AMW_PROCESS_HIERARCHY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMW.AMW_PROCESS_HIERARCHY_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view returns information about Process Hierarchy
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_PROCESS_ID | NUMBER | Yes | Parent Process Identifier | |
CHILD_PROCESS_ID | NUMBER | Yes | Child Process Identifier | |
PARENT_PROCESS_NAME | VARCHAR2 | (80) | Yes | Parent Process Name |
PROCESS_NAME | VARCHAR2 | (80) | Yes | Child Process Name |
ORGANIZATION | VARCHAR2 | (0) | Organization Name | |
PROCESSOWNER | VARCHAR2 | (0) | Process Owner Name | |
CERTIFICATION_STATUS | VARCHAR2 | (0) | Certification Status | |
APPROVAL_STATUS | VARCHAR2 | (0) | Approval Status | |
LAST_AUDIT_STATUS | VARCHAR2 | (0) | Last Audit Status | |
LAST_AUDIT_DATE | VARCHAR2 | (0) | Last Audit Time | |
NEXT_AUDIT_DATE | VARCHAR2 | (0) | Next Audit Date | |
PROCESS_ACTIVITY_TYPE | VARCHAR2 | (8) | Yes | Process Activity Type |
PROCESS | CHAR | (7) | Process | |
PARENT_NONDISP_NAME | VARCHAR2 | (30) | Yes | Name of parent proces as recorded in AMW_Process |
CHILD_NONDISP_NAME | VARCHAR2 | (30) | Yes | Name of child proces as recorded in AMW_Process |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_PROCESS_ID
, CHILD_PROCESS_ID
, PARENT_PROCESS_NAME
, PROCESS_NAME
, ORGANIZATION
, PROCESSOWNER
, CERTIFICATION_STATUS
, APPROVAL_STATUS
, LAST_AUDIT_STATUS
, LAST_AUDIT_DATE
, NEXT_AUDIT_DATE
, PROCESS_ACTIVITY_TYPE
, PROCESS
, PARENT_NONDISP_NAME
, CHILD_NONDISP_NAME
FROM APPS.AMW_PROCESS_HIERARCHY_V;
|
|
|