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

VIEW: APPS.ASO_APPROVER_DETAILS_V

Object Details
Object Name: ASO_APPROVER_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewASO.ASO_APPROVER_DETAILS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view shows details about an approval instance such as the names of the approvers, their comments and responses.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_APPROVAL_ID NUMBER
Yes From aso_apr_obj_approvals table
APPROVAL_DET_ID NUMBER
Yes From aso_apr_approval_details table
APPROVER_NAME VARCHAR2 (360)
From FND or HR table
APPROVER_PERSON_ID NUMBER

From aso_apr_approval_details table
APPROVER_USER_ID NUMBER

From aso_apr_approval_details table
APPROVER_SEQUENCE NUMBER
Yes From Workflow table
APPROVER_STATUS VARCHAR2 (80) Yes From aso_apr_approval_details table
APPROVER_COMMENTS VARCHAR2 (4000)
From aso_apr_approval_details table
DATE_SENT DATE

From aso_apr_approval_details table
DATE_RECEIVED DATE

From aso_apr_approval_details table
APPROVAL_DET_WF_ITEM_KEY VARCHAR2 (43)
From aso_apr_approval_details table
Query Text

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


SELECT CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_APPROVAL_ID
,      APPROVAL_DET_ID
,      APPROVER_NAME
,      APPROVER_PERSON_ID
,      APPROVER_USER_ID
,      APPROVER_SEQUENCE
,      APPROVER_STATUS
,      APPROVER_COMMENTS
,      DATE_SENT
,      DATE_RECEIVED
,      APPROVAL_DET_WF_ITEM_KEY
FROM APPS.ASO_APPROVER_DETAILS_V;

Dependencies

[top of page]

APPS.ASO_APPROVER_DETAILS_V references the following:

SchemaAPPS
SynonymASO_APR_APPROVAL_DETAILS
ViewASO_LOOKUPS
SynonymJTF_RS_RESOURCE_EXTNS
SynonymPER_ALL_PEOPLE_F

APPS.ASO_APPROVER_DETAILS_V is not referenced by any database object