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


VIEW: APPS.AMW_MANAG_HIER_V

Object Details
Object Name: AMW_MANAG_HIER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMW.AMW_MANAG_HIER_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
FLEX_VALUE_SET_ID NUMBER

PARENT_VALUE VARCHAR2 (150)
PARENT_ID NUMBER

PARENT_DISPLAY_NAME VARCHAR2 (240)
CHILD_VALUE VARCHAR2 (150)
CHILD_ID NUMBER (15)
CHILD_DISPLAY_NAME VARCHAR2 (240)
LINE_TYPE VARCHAR2 (80)
CHILD_DESCRIPTION VARCHAR2 (0)
CHILD_PROCESS_ID VARCHAR2 (0)
CHILD_ORGANIZATION_ID VARCHAR2 (0)
CHILD_PROCESS_CODE VARCHAR2 (0)
CHILD_REVISION_NUMBER VARCHAR2 (0)
CHILD_APPROVAL_STATUS VARCHAR2 (0)
CHILD_APPROVAL_DATE VARCHAR2 (0)
CHILD_CONTROL_COUNT VARCHAR2 (0)
CHILD_RISK_COUNT VARCHAR2 (0)
CHILD_SIGNIFICANT_PROCESS_FLAG VARCHAR2 (0)
CHILD_STANDARD_PROCESS_FLAG VARCHAR2 (0)
CHILD_CERTIFICATION_STATUS VARCHAR2 (0)
CHILD_PROCESS_CATEGORY VARCHAR2 (0)
CHILD_PROCESS_TYPE VARCHAR2 (0)
CHILD_CONTROL_ACTIVITY_TYPE VARCHAR2 (0)
CHILD_ORDER_NUMBER VARCHAR2 (0)
ACTIVE_AUDIT_PROJECT_COUNT NUMBER

Query Text

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


SELECT FLEX_VALUE_SET_ID
,      PARENT_VALUE
,      PARENT_ID
,      PARENT_DISPLAY_NAME
,      CHILD_VALUE
,      CHILD_ID
,      CHILD_DISPLAY_NAME
,      LINE_TYPE
,      CHILD_DESCRIPTION
,      CHILD_PROCESS_ID
,      CHILD_ORGANIZATION_ID
,      CHILD_PROCESS_CODE
,      CHILD_REVISION_NUMBER
,      CHILD_APPROVAL_STATUS
,      CHILD_APPROVAL_DATE
,      CHILD_CONTROL_COUNT
,      CHILD_RISK_COUNT
,      CHILD_SIGNIFICANT_PROCESS_FLAG
,      CHILD_STANDARD_PROCESS_FLAG
,      CHILD_CERTIFICATION_STATUS
,      CHILD_PROCESS_CATEGORY
,      CHILD_PROCESS_TYPE
,      CHILD_CONTROL_ACTIVITY_TYPE
,      CHILD_ORDER_NUMBER
,      ACTIVE_AUDIT_PROJECT_COUNT
FROM APPS.AMW_MANAG_HIER_V;

Dependencies

[top of page]

APPS.AMW_MANAG_HIER_V references the following:

SchemaAPPS
ViewAMW_AUDIT_UNITS_V
PL/SQL PackageAMW_UTILITY_PVT - show dependent code
ViewFND_FLEX_VALUES_VL
ViewFND_FLEX_VALUE_CHILDREN_V
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_NUMBER - show dependent code
PL/SQL PackageHR_API - show dependent code

APPS.AMW_MANAG_HIER_V is not referenced by any database object