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


VIEW: AHL.AHL_APPROVAL_API#

Object Details
Object Name: AHL_APPROVAL_API#
Object Type: VIEW
Owner: AHL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPROVAL_API_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
APPROVAL_TYPE VARCHAR2 (30)
API_USED_BY VARCHAR2 (80)
APPROVAL_OBJECT_TYPE VARCHAR2 (30)
ACTIVITY_TYPE VARCHAR2 (80)
PACKAGE_NAME VARCHAR2 (80)
PROCEDURE_NAME VARCHAR2 (80)
SECURITY_GROUP_ID NUMBER

ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT APPROVAL_API_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      APPROVAL_TYPE
,      API_USED_BY
,      APPROVAL_OBJECT_TYPE
,      ACTIVITY_TYPE
,      PACKAGE_NAME
,      PROCEDURE_NAME
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM AHL.AHL_APPROVAL_API#;

Dependencies

[top of page]

AHL.AHL_APPROVAL_API# references the following:

SchemaAHL
TableAHL_APPROVAL_API
AHL.AHL_APPROVAL_API# is referenced by following:

SchemaAPPS
SynonymAHL_APPROVAL_API
TriggerAHL_APPROVAL_API+