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

VIEW: APPS.AMW_CURR_APP_HIERARCHY_ORG_V

Object Details
Object Name: AMW_CURR_APP_HIERARCHY_ORG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMW.AMW_CURR_APP_HIERARCHY_ORG_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 Mandatory Comments
PARENT_PROCESS_ID NUMBER

Parent Process Id
PARENT_REVISION_NUMBER NUMBER

Parent revision Number
PARENT_PROCESS_CODE VARCHAR2 (30)
Parent process code
PARENT_DISPLAY_NAME VARCHAR2 (80)
Parent process display name
PARENT_PROCESS_ORG_REV_ID NUMBER

Parent process Organization revision Id
CHILD_DISPLAY_NAME VARCHAR2 (80)
Child process display name
CHILD_DESCRIPTION VARCHAR2 (240)
Child Process description
CHILD_PROCESS_ID NUMBER

Child process id
CHILD_ORGANIZATION_ID NUMBER

Child Organization Id
CHILD_PROCESS_CODE VARCHAR2 (30)
Child Process Code
CHILD_REVISION_NUMBER NUMBER

Child Revision Number
CHILD_PROCESS_ORG_REV_ID NUMBER

Child organization process revision id
CHILD_APPROVAL_STATUS VARCHAR2 (30)
Child 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 NUMBER

Child process control count
CHILD_RISK_COUNT NUMBER

Child process 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 category
CHILD_PROCESS_OWNER_ID NUMBER

Child process owner id
CHILD_FINANCE_OWNER_ID NUMBER

Child process finance owner id
CHILD_APPLICATION_OWNER_ID NUMBER

Child Application Owner Id
CHILD_STANDARD_VARIATION NUMBER

Child process is the variation of the standard process
CHILD_PROCESS_TYPE VARCHAR2 (10)
Child Process Type
CHILD_CONTROL_ACTIVITY_TYPE VARCHAR2 (30)
Child Control Activity type
CHILD_ORDER_NUMBER NUMBER

Child process order number
Query Text

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
,      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
,      CHILD_RISK_COUNT
,      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_CURR_APP_HIERARCHY_ORG_V;

Dependencies

[top of page]

APPS.AMW_CURR_APP_HIERARCHY_ORG_V references the following:

SchemaAPPS
SynonymAMW_APPROVED_HIERARCHIES
ViewAMW_PROCESS_ORGANIZATION_VL
APPS.AMW_CURR_APP_HIERARCHY_ORG_V is referenced by following:

SchemaAPPS
Package BodyAMW_CREATE_LINES_PKG - show dependent code
Package BodyAMW_ORG_HIERARCHY_PKG - show dependent code
Package BodyAMW_PROCESS_CERT_SCOPE_PVT - show dependent code
Package BodyAMW_PROC_ORG_APPROVAL_PKG - show dependent code
Package BodyAMW_SCOPE_PVT - show dependent code