[Home] [Help]
[Dependency Information]
VIEW: APPS.CN_SRP_COMP_TEAMS_V
Object Details
Object Name: | CN_SRP_COMP_TEAMS_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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 |
SRP_COMP_TEAM_ID |
NUMBER |
|
Yes |
|
COMP_TEAM_ID |
NUMBER |
|
Yes |
|
TEAM_RESOURCE_ID |
NUMBER |
|
Yes |
|
SALESREP_ID |
NUMBER |
|
Yes |
|
START_DATE_ACTIVE |
DATE |
|
|
|
END_DATE_ACTIVE |
DATE |
|
|
|
ORG_ID |
NUMBER |
|
|
Orgianization Id |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT SRP_COMP_TEAM_ID
, COMP_TEAM_ID
, TEAM_RESOURCE_ID
, SALESREP_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ORG_ID
FROM APPS.CN_SRP_COMP_TEAMS_V;
Dependencies
[top of page]
APPS.CN_SRP_COMP_TEAMS_V references the following:
-
APPS
-
JTF_RS_ROLES_B
-
JTF_RS_ROLE_RELATIONS
-
JTF_RS_SALESREPS_MO_V
-
JTF_RS_TEAMS_B
-
JTF_RS_TEAM_MEMBERS
-
JTF_RS_TEAM_USAGES
APPS.CN_SRP_COMP_TEAMS_V is referenced by following:
-
APPS
-
CN_CALC_POPULATE_PVT
- show dependent code
-
CN_MARK_EVENTS_PKG
- show dependent code
-
JTF_RS_GROUP_RELATE_VUHK
- show dependent code
-
JTF_RS_GROUP_USAGE_VUHK
- show dependent code
-
JTF_RS_ROLES_VUHK
- show dependent code
-
JTF_RS_ROLE_RELATE_VUHK
- show dependent code
-
JTF_RS_TEAM_MEMBER_VUHK
- show dependent code