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

VIEW: APPS.AMW_CURR_APP_HIERARCHY_RL_V

Object Details
Object Name: AMW_CURR_APP_HIERARCHY_RL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMW.AMW_CURR_APP_HIERARCHY_RL_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 process revision number
PARTENT_PROCESS_CODE VARCHAR2 (30)
Parent process code
PARENT_DISPLAY_NAME VARCHAR2 (80)
Parent Display Name
PARENT_PROCESS_REV_ID NUMBER

Parent Process revision id
CHILD_PROCESS_ID NUMBER

child process id
CHILD_REVISION_NUMBER NUMBER

Chils process revision number
CHILD_PROCESS_CODE VARCHAR2 (30)
Child process code
CHILD_DISPLAY_NAME VARCHAR2 (80)
Child process display name
CHILD_ITEM_TYPE VARCHAR2 (8)
Child process item type
CHILD_NAME VARCHAR2 (30)
Child process name
CHILD_PROCESS_REV_ID NUMBER

child 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 NUMBER

Child process control count
CHILD_RISK_COUNT NUMBER

Child process risk count
CHILD_ORG_COUNT NUMBER

Child process organization 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 Finance Owner Id
CHILD_APPLICATION_OWNER_ID NUMBER

Child Application owner id
CHILD_STANDARD_VARIATION NUMBER

The standard process for which this proceses is a non standard
CHILD_ORDER_NUMBER NUMBER

Child order number
Query Text

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


SELECT PARENT_PROCESS_ID
,      PARENT_REVISION_NUMBER
,      PARTENT_PROCESS_CODE
,      PARENT_DISPLAY_NAME
,      PARENT_PROCESS_REV_ID
,      CHILD_PROCESS_ID
,      CHILD_REVISION_NUMBER
,      CHILD_PROCESS_CODE
,      CHILD_DISPLAY_NAME
,      CHILD_ITEM_TYPE
,      CHILD_NAME
,      CHILD_PROCESS_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_ORG_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_ORDER_NUMBER
FROM APPS.AMW_CURR_APP_HIERARCHY_RL_V;

Dependencies

[top of page]

APPS.AMW_CURR_APP_HIERARCHY_RL_V references the following:

SchemaAPPS
SynonymAMW_APPROVED_HIERARCHIES
ViewAMW_PROCESS_VL
APPS.AMW_CURR_APP_HIERARCHY_RL_V is referenced by following:

SchemaAPPS
Package BodyAMW_CREATE_LINES_PKG - show dependent code
Package BodyAMW_PROC_APPROVAL_PKG - show dependent code
Package BodyAMW_RL_HIERARCHY_PKG - show dependent code