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


VIEW: APPS.AST_RS_GRP_VALID_V

Object Details
Object Name: AST_RS_GRP_VALID_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAST.AST_RS_GRP_VALID_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

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Yes
GROUP_NUMBER VARCHAR2 (30) Yes
EXCLUSIVE_FLAG VARCHAR2 (1)
GROUP_START_DATE_ACTIVE DATE

GROUP_END_DATE_ACTIVE DATE

GROUP_NAME VARCHAR2 (60) Yes
GROUP_DESCRIPTION VARCHAR2 (240)
ROLE_RELATE_ID NUMBER
Yes
ROLE_RESOURCE_TYPE VARCHAR2 (30) Yes
ROLE_RESOURCE_ID NUMBER
Yes
ROLE_ID NUMBER
Yes
ROLE_START_DATE_ACTIVE DATE
Yes
ROLE_END_DATE_ACTIVE DATE

ROLE_NAME VARCHAR2 (60) Yes
ROLE_MEMBER_FLAG VARCHAR2 (1)
ROLE_ADMIN_FLAG VARCHAR2 (1)
ROLE_LEAD_FLAG VARCHAR2 (1)
ROLE_MANAGER_FLAG VARCHAR2 (1)
ROLE_TYPE_CODE VARCHAR2 (240) Yes
ROLE_MEANING VARCHAR2 (80) Yes
Query Text

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


SELECT GROUP_ID
,      GROUP_NUMBER
,      EXCLUSIVE_FLAG
,      GROUP_START_DATE_ACTIVE
,      GROUP_END_DATE_ACTIVE
,      GROUP_NAME
,      GROUP_DESCRIPTION
,      ROLE_RELATE_ID
,      ROLE_RESOURCE_TYPE
,      ROLE_RESOURCE_ID
,      ROLE_ID
,      ROLE_START_DATE_ACTIVE
,      ROLE_END_DATE_ACTIVE
,      ROLE_NAME
,      ROLE_MEMBER_FLAG
,      ROLE_ADMIN_FLAG
,      ROLE_LEAD_FLAG
,      ROLE_MANAGER_FLAG
,      ROLE_TYPE_CODE
,      ROLE_MEANING
FROM APPS.AST_RS_GRP_VALID_V;

Dependencies

[top of page]

APPS.AST_RS_GRP_VALID_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewJTF_RS_GROUPS_VL
ViewJTF_RS_ROLE_RELATIONS_VL

APPS.AST_RS_GRP_VALID_V is not referenced by any database object