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

VIEW: APPS.CN_QM_MGR_GROUPS

Object Details
Object Name: CN_QM_MGR_GROUPS
Object Type: VIEW
Owner: APPS
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
QM_MGR_GROUP_ID NUMBER
Yes refer to base table
SRP_ROLE_ID NUMBER
Yes refer to base table
COMP_GROUP_ID NUMBER
Yes refer to base table
GROUP_NAME VARCHAR2 (60) Yes refer to base table
RESOURCE_ID NUMBER
Yes refer to base table
MANAGER_SRP_ID NUMBER
Yes refer to base table
ROLE_ID NUMBER
Yes refer to base table
ROLE_NAME VARCHAR2 (60) Yes refer to base table
ROLE_DESC VARCHAR2 (120)
refer to base table
MEMBER_FLAG VARCHAR2 (1)
refer to base table
ADMIN_FLAG VARCHAR2 (1)
refer to base table
MANAGER_FLAG VARCHAR2 (1)
refer to base table
LEAD_FLAG VARCHAR2 (1)
refer to base table
START_DATE_ACTIVE DATE
Yes refer to base table
END_DATE_ACTIVE DATE

refer to base table
Query Text

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


SELECT QM_MGR_GROUP_ID
,      SRP_ROLE_ID
,      COMP_GROUP_ID
,      GROUP_NAME
,      RESOURCE_ID
,      MANAGER_SRP_ID
,      ROLE_ID
,      ROLE_NAME
,      ROLE_DESC
,      MEMBER_FLAG
,      ADMIN_FLAG
,      MANAGER_FLAG
,      LEAD_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM APPS.CN_QM_MGR_GROUPS;

Dependencies

[top of page]

APPS.CN_QM_MGR_GROUPS references the following:

SchemaAPPS
SynonymCN_SRP_ROLE_DTLS
ViewJTF_RS_GROUPS_VL
ViewJTF_RS_GROUP_MBR_ROLE_VL
SynonymJTF_RS_GROUP_USAGES
SynonymJTF_RS_ROLES_B
SynonymJTF_RS_ROLE_RELATIONS
SynonymJTF_RS_SALESREPS
APPS.CN_QM_MGR_GROUPS is referenced by following:

SchemaAPPS
Package BodyCN_SRP_HIER_PROC_PVT - show dependent code