eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMW_ALL_HIER_CHILDREN_V

Object Details

Object Name:	AMW_ALL_HIER_CHILDREN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMW.AMW_ALL_HIER_CHILDREN_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
PARENT_ID	NUMBER		Stores the Parent Process Identifier
PARENT_REV_NUM	NUMBER		Stores the parent process revision number
CHILD_PROCESS_CODE	VARCHAR2	(30)	Stores the child process code
CHILD_ID	NUMBER		Stores the Child process id
CHILD_REV_NUM	NUMBER		Stores the child process revision number
CHILD_NAME	VARCHAR2	(80)	Stores the child process name
CHILD_STANDARD_PROCESS_FLAG	VARCHAR2	(1)	Flag to indicate if the child process is a standard process or not
CHILD_STD_VAR_PROCESS_ID	NUMBER		The standard process id of which the child process is non standard variation
HIERARCHY_TYPE	CHAR	(1)	Stores the Hierarchy type

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARENT_ID
,      PARENT_REV_NUM
,      CHILD_PROCESS_CODE
,      CHILD_ID
,      CHILD_REV_NUM
,      CHILD_NAME
,      CHILD_STANDARD_PROCESS_FLAG
,      CHILD_STD_VAR_PROCESS_ID
,      HIERARCHY_TYPE
FROM APPS.AMW_ALL_HIER_CHILDREN_V;

Dependencies

[top of page]

APPS.AMW_ALL_HIER_CHILDREN_V references the following:

APPS: AMW_APPROVED_HIERARCHIES; AMW_LATEST_HIERARCHIES; AMW_PROCESS; AMW_PROCESS_VL

APPS.AMW_ALL_HIER_CHILDREN_V is not referenced by any database object