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

VIEW: APPS.AMW_CUSTOM_HIER_V

Object Details
Object Name: AMW_CUSTOM_HIER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMW.AMW_CUSTOM_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
OBJECT_TYPE VARCHAR2 (80)
Object Type
PARENT_PROCESS_ID NUMBER

Parent process id
PARENT_REVISION_NUMBER VARCHAR2 (0)
Parent process revision number
PARENT_PROCESS_CODE VARCHAR2 (0)
Parent process code
PARENT_DISPLAY_NAME VARCHAR2 (0)
Parent process display name
PARENT_PROCESS_ORG_REV_ID VARCHAR2 (0)
Parent organization process revision id
PARENT_ORGANIZATION_ID NUMBER

Parent organization Id
CHILD_DISPLAY_NAME VARCHAR2 (240)
Child process display name
CHILD_DESCRIPTION VARCHAR2 (0)
Child Process description
CHILD_PROCESS_ID NUMBER

Child process id
CHILD_ORGANIZATION_ID NUMBER (15)
Child organization id
CHILD_PROCESS_CODE VARCHAR2 (0)
Child process code
CHILD_REVISION_NUMBER VARCHAR2 (0)
Child revision number
CHILD_PROCESS_ORG_REV_ID VARCHAR2 (0)
Child process organization revision id
CHILD_APPROVAL_STATUS VARCHAR2 (0)
Child process approval status
CHILD_START_DATE VARCHAR2 (0)
Child process start date
CHILD_APPROVAL_DATE VARCHAR2 (0)
Child process approval date
CHILD_APPROVAL_END_DATE VARCHAR2 (0)
Child process approval end date
CHILD_END_DATE VARCHAR2 (0)
Child process end date
CHILD_CONTROL_COUNT VARCHAR2 (0)
Child control count
CHILD_RISK_COUNT VARCHAR2 (0)
Child process risk count
CHILD_SIGNIFICANT_PROCESS_FLAG VARCHAR2 (0)
Child process significant process flag
CHILD_STANDARD_PROCESS_FLAG VARCHAR2 (0)
Child Standard process flag
CHILD_CERTIFICATION_STATUS VARCHAR2 (0)
Child Process Certification Status
CHILD_PROCESS_CATEGORY VARCHAR2 (0)
Child process category
CHILD_PROCESS_OWNER_ID VARCHAR2 (0)
Child process owner id
CHILD_FINANCE_OWNER_ID VARCHAR2 (0)
Child process finance owner id
CHILD_APPLICATION_OWNER_ID VARCHAR2 (0)
Child process application owner id
CHILD_STANDARD_VARIATION VARCHAR2 (0)
The standard Process id for which the child process is non standard
CHILD_PROCESS_TYPE VARCHAR2 (0)
Child Process Type
CHILD_CONTROL_ACTIVITY_TYPE VARCHAR2 (0)
Child Process Control activity type
CHILD_ORDER_NUMBER VARCHAR2 (0)
Child Order Number
ACTIVE_AUDIT_PROJECT_COUNT NUMBER

Active audit project count
Query Text

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


SELECT OBJECT_TYPE
,      PARENT_PROCESS_ID
,      PARENT_REVISION_NUMBER
,      PARENT_PROCESS_CODE
,      PARENT_DISPLAY_NAME
,      PARENT_PROCESS_ORG_REV_ID
,      PARENT_ORGANIZATION_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
,      ACTIVE_AUDIT_PROJECT_COUNT
FROM APPS.AMW_CUSTOM_HIER_V;

Dependencies

[top of page]

APPS.AMW_CUSTOM_HIER_V references the following:

SchemaAPPS
ViewAMW_AUDIT_UNITS_V
PL/SQL PackageAMW_UTILITY_PVT - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_API - show dependent code
SynonymPER_ORGANIZATION_STRUCTURES
SynonymPER_ORG_STRUCTURE_ELEMENTS
SynonymPER_ORG_STRUCTURE_VERSIONS

APPS.AMW_CUSTOM_HIER_V is not referenced by any database object