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

VIEW: APPS.AMS_ACT_RESOURCES_V

Object Details
Object Name: AMS_ACT_RESOURCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_ACT_RESOURCES_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
ACTIVITY_RESOURCE_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9)
ACT_RESOURCE_USED_BY_ID NUMBER
Yes
ARC_ACT_RESOURCE_USED_BY VARCHAR2 (30) Yes
RESOURCE_ID NUMBER
Yes
RESOURCE_NAME VARCHAR2 (360) Yes
ROLE_RELATE_ID NUMBER

ROLE_CD VARCHAR2 (30)
ROLE_TYPE VARCHAR2 (80) Yes
USER_STATUS_ID NUMBER
Yes
USER_STATUS VARCHAR2 (120)
SYSTEM_STATUS_CODE VARCHAR2 (30)
START_DATE_TIME DATE

END_DATE_TIME DATE

DESCRIPTION VARCHAR2 (4000)
Query Text

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


SELECT ACTIVITY_RESOURCE_ID
,      OBJECT_VERSION_NUMBER
,      ACT_RESOURCE_USED_BY_ID
,      ARC_ACT_RESOURCE_USED_BY
,      RESOURCE_ID
,      RESOURCE_NAME
,      ROLE_RELATE_ID
,      ROLE_CD
,      ROLE_TYPE
,      USER_STATUS_ID
,      USER_STATUS
,      SYSTEM_STATUS_CODE
,      START_DATE_TIME
,      END_DATE_TIME
,      DESCRIPTION
FROM APPS.AMS_ACT_RESOURCES_V;

Dependencies

[top of page]

APPS.AMS_ACT_RESOURCES_V references the following:

SchemaAPPS
SynonymAMS_ACT_RESOURCES
ViewAMS_LOOKUPS
ViewAMS_USER_STATUSES_V
SynonymHZ_PARTIES

APPS.AMS_ACT_RESOURCES_V is not referenced by any database object