[Home] [Help]
[Dependency Information]
VIEW: APPS.JTF_RS_GROUPS_VL
Object Details
Object Name: | JTF_RS_GROUPS_VL |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_RS_GROUPS_VL
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A public view which may be useful for custom reporting or other data
requirements.
MLS View forJTF_RS_GROUPS_B and JTF_RS_GROUPS_TL.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
ROW_ID |
ROWID |
(10) |
|
Unique row identifier. |
ATTRIBUTE1 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE2 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE3 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE4 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE5 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE6 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE7 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE8 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE9 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE10 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE11 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE12 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE13 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE14 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE15 |
VARCHAR2 |
(150) |
|
Descriptive flexfield segment |
ATTRIBUTE_CATEGORY |
VARCHAR2 |
(30) |
|
Descriptive flexfield column. |
GROUP_ID |
NUMBER |
|
Yes |
Group Identifier. |
GROUP_NUMBER |
VARCHAR2 |
(30) |
Yes |
Group number. |
EMAIL_ADDRESS |
VARCHAR2 |
(240) |
|
Email address for the group. |
CREATED_BY |
NUMBER |
|
Yes |
Standard WHO column. |
CREATION_DATE |
DATE |
|
Yes |
Standard WHO column. |
LAST_UPDATED_BY |
NUMBER |
|
Yes |
Standard WHO column. |
LAST_UPDATE_DATE |
DATE |
|
Yes |
Standard WHO column. |
LAST_UPDATE_LOGIN |
NUMBER |
|
|
Standard WHO column. |
EXCLUSIVE_FLAG |
VARCHAR2 |
(1) |
|
Exclusive flag. |
START_DATE_ACTIVE |
DATE |
|
|
Effective start date of the group. |
END_DATE_ACTIVE |
DATE |
|
|
Effective end date of the group. |
ACCOUNTING_CODE |
VARCHAR2 |
(80) |
|
Accounting code. |
OBJECT_VERSION_NUMBER |
NUMBER |
|
Yes |
Object Version Number. |
GROUP_NAME |
VARCHAR2 |
(60) |
Yes |
Group Name. |
GROUP_DESC |
VARCHAR2 |
(240) |
|
Group Description. |
TIME_ZONE |
NUMBER |
|
|
TimeZone to which this group is associated. |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, GROUP_ID
, GROUP_NUMBER
, EMAIL_ADDRESS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, EXCLUSIVE_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ACCOUNTING_CODE
, OBJECT_VERSION_NUMBER
, GROUP_NAME
, GROUP_DESC
, TIME_ZONE
FROM APPS.JTF_RS_GROUPS_VL;
Dependencies
[top of page]
APPS.JTF_RS_GROUPS_VL references the following:
-
APPS
-
JTF_RS_GROUPS_B
-
JTF_RS_GROUPS_TL
APPS.JTF_RS_GROUPS_VL is referenced by following:
-
APPS
-
AMS_CAMPAIGN_TEAM_V
-
AMS_DS_ACCESSES_ALL_V
-
AMS_DS_GROUP_ACCESSES_ALL_V
-
AMV_CHANNEL_PVT
- show dependent code
-
AMV_ITEM_PUB
- show dependent code
-
AMV_USER_PVT
- show dependent code
-
AMV_UTILITY_PVT
- show dependent code
-
AR_REVENUE_ADJUSTMENTS_RA_V
-
ASO_SALES_CREDITS_V
-
AST_GRP_CAMPAIGNS_V
-
AST_GRP_CAMPAIGN_SCHEDS_V
-
AST_RS_GRP_VALID_V
-
AST_SALESREP_LOV_V
-
CCT_GROUPS_VL
-
CCT_JTFRESOURCEROUTING_PUB
- show dependent code
-
CN_COMP_GROUPS
-
CN_QM_COMP_GROUPS
-
CN_QM_MGR_GROUPS
-
CN_QM_MGR_SRP_GROUPS
-
CN_QM_SRP_GROUPS
-
CN_SFP_GROUP_UTIL_PVT
- show dependent code
-
CN_SRP_HIER_PROC_PVT
- show dependent code
-
CN_TOP_GROUPS_NAV
-
CN_TSR_PVT
- show dependent code
-
CSC_TASK_OWNERS_V
-
CSD_TASK_RESOURCES_V
-
CSF_GROUP_MEMBER_ROLES_V
-
CSF_PLAN_TERRS_V
-
CSF_RESOURCE_PUB
- show dependent code
-
CSI_CONTACTS_V
-
CSI_INSTALLED_BASE_V
-
CSI_INSTANCE_PARTIES_VLD_PVT
- show dependent code
-
CSI_INST_PARTY_DETAILS_V
-
CSI_IPH_DETAILS_V
-
CSI_ML_UTIL_PVT
- show dependent code
-
CSI_PARTY_CONTACT_DETAILS_V
-
CSI_PARTY_RELATIONSHIPS_PUB
- show dependent code
-
CSI_PARTY_RELATIONSHIPS_PVT
- show dependent code
-
CSI_T_PARTY_CONTACTS_V
-
CSI_T_PARTY_DETAILS_V
-
CS_AUDIT_REPORT_VW
-
CS_KB_WF_PKG
- show dependent code
-
CS_SERVICEREQUEST_UTIL
- show dependent code
-
CS_SR_OWNERS_V
-
CS_SR_SEARCH_NO_CONT_V
-
CS_SR_SEARCH_V
-
IBC_AUDIT_LOG_GRP
- show dependent code
-
IBC_UTILITIES_PVT
- show dependent code
-
IBC_VALIDATE_PVT
- show dependent code
-
IBU_DYN_USER_GROUPS_PKG
- show dependent code
-
IEU_DIAG_AUDIT_TRACK_PVT
- show dependent code
-
IEU_WP_TASK_OWNR_LOV_V
-
IEX_PROCESS_ACCOUNT_WINNERS
- show dependent code
-
IEX_UWQ_POP_SUM_TBL_PVT
- show dependent code
-
JTF_RS_ALL_RESOURCES_VL
-
JTF_RS_CONC_WF_PUB
- show dependent code
-
JTF_RS_DEFRESGROUPS_VL
-
JTF_RS_GROUPS_AUD_PVT
- show dependent code
-
JTF_RS_GROUPS_PKG
- show dependent code
-
JTF_RS_GROUPS_PUB
- show dependent code
-
JTF_RS_GROUPS_PUB
- show dependent code
-
JTF_RS_GROUPS_PVT
- show dependent code
-
JTF_RS_GROUPS_PVT
- show dependent code
-
JTF_RS_GROUP_DENORM_PVT
- show dependent code
-
JTF_RS_GROUP_DENORM_PVT
- show dependent code
-
JTF_RS_GROUP_MEMBERS_PUB
- show dependent code
-
JTF_RS_GROUP_MEMBERS_PUB
- show dependent code
-
JTF_RS_GROUP_ORGS_PVT
- show dependent code
-
JTF_RS_GROUP_RELATE_CUHK
- show dependent code
-
JTF_RS_GROUP_RELATE_IUHK
- show dependent code
-
JTF_RS_GROUP_RELATE_IUHK
- show dependent code
-
JTF_RS_GROUP_RELATE_PUB
- show dependent code
-
JTF_RS_GROUP_RELATE_PUB
- show dependent code
-
JTF_RS_GROUP_RELATE_PVT
- show dependent code
-
JTF_RS_GROUP_RELATE_PVT
- show dependent code
-
JTF_RS_GROUP_RELATE_VUHK
- show dependent code
-
JTF_RS_GROUP_RELATE_VUHK
- show dependent code
-
JTF_RS_GROUP_REPORT_PUB
- show dependent code
-
JTF_RS_GROUP_USAGES_PUB
- show dependent code
-
JTF_RS_GROUP_USAGES_PUB
- show dependent code
-
JTF_RS_GROUP_USAGES_PVT
- show dependent code
-
JTF_RS_GRP_HIER_V
-
JTF_RS_GRP_MEMBERSHIP_PUB
- show dependent code
-
JTF_RS_GRP_RELATIONS_VL
-
JTF_RS_GRP_SUM_PUB
- show dependent code
-
JTF_RS_IMPORT_USER_PUB
- show dependent code
-
JTF_RS_JSP_LOV_RECS_PUB
- show dependent code
-
JTF_RS_RESOURCES_VL
-
JTF_RS_RESOURCE_GROUP_CUHK
- show dependent code
-
JTF_RS_RESOURCE_GROUP_IUHK
- show dependent code
-
JTF_RS_RESOURCE_GROUP_IUHK
- show dependent code
-
JTF_RS_RESOURCE_GROUP_VUHK
- show dependent code
-
JTF_RS_SKILLS_REPORT_PUB
- show dependent code
-
JTF_RS_WF_INTEGRATION_PUB
- show dependent code
-
JTF_TASK_RESOURCES_VL
-
JTF_TERRITORY_RESOURCE_PVT
- show dependent code
-
JTF_TERR_QLFY_RSC_DST_V
-
JTF_TERR_QLFY_RSC_V
-
JTF_TR_ALL_RESOURCES_V
-
JTF_TTY_ALIGN_WEBADI_INT_PKG
- show dependent code
-
JTF_TTY_ALL_RESOURCES_V
-
JTF_TTY_EXCEL_NAORG_PVT
- show dependent code
-
JTF_TTY_GEO_TERR_OWNER_LOV_V
-
JTF_TTY_MAINTAIN_NA_PVT
- show dependent code
-
JTF_TTY_MY_DIRECTS_V
-
JTF_TTY_MY_RESOURCES_V
-
JTF_TTY_WEBADI_NADOC_PKG
- show dependent code
-
JTF_TTY_WEBADI_SALSTEAM_UPDATE
- show dependent code
-
JTY_WEBADI_OTH_TERR_DWNL_PKG
- show dependent code
-
OE_ID_TO_VALUE
- show dependent code
-
OKC_RESOURCE_GROUPS_V
-
OKS_AUTH_SHOWALL_PROD_V
-
OKS_PRODUCT_DETAILS_V
-
OKS_RESOURCE_GROUPS_V
-
PV_PRTNR_SALES_TEAM_V
-
PV_TAP_BES_PKG
- show dependent code
-
QPR_SR_SG_HIER_V