DBA Data[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: ViewJTF.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:

SchemaAPPS
SynonymJTF_RS_GROUPS_B
SynonymJTF_RS_GROUPS_TL
APPS.JTF_RS_GROUPS_VL is referenced by following:

SchemaAPPS
ViewAMS_CAMPAIGN_TEAM_V
ViewAMS_DS_ACCESSES_ALL_V
ViewAMS_DS_GROUP_ACCESSES_ALL_V
Package BodyAMV_CHANNEL_PVT - show dependent code
Package BodyAMV_ITEM_PUB - show dependent code
Package BodyAMV_USER_PVT - show dependent code
Package BodyAMV_UTILITY_PVT - show dependent code
ViewAR_REVENUE_ADJUSTMENTS_RA_V
ViewASO_SALES_CREDITS_V
ViewAST_GRP_CAMPAIGNS_V
ViewAST_GRP_CAMPAIGN_SCHEDS_V
ViewAST_RS_GRP_VALID_V
ViewAST_SALESREP_LOV_V
ViewCCT_GROUPS_VL
Package BodyCCT_JTFRESOURCEROUTING_PUB - show dependent code
ViewCN_COMP_GROUPS
ViewCN_QM_COMP_GROUPS
ViewCN_QM_MGR_GROUPS
ViewCN_QM_MGR_SRP_GROUPS
ViewCN_QM_SRP_GROUPS
Package BodyCN_SFP_GROUP_UTIL_PVT - show dependent code
Package BodyCN_SRP_HIER_PROC_PVT - show dependent code
ViewCN_TOP_GROUPS_NAV
Package BodyCN_TSR_PVT - show dependent code
ViewCSC_TASK_OWNERS_V
ViewCSD_TASK_RESOURCES_V
ViewCSF_GROUP_MEMBER_ROLES_V
ViewCSF_PLAN_TERRS_V
Package BodyCSF_RESOURCE_PUB - show dependent code
ViewCSI_CONTACTS_V
ViewCSI_INSTALLED_BASE_V
Package BodyCSI_INSTANCE_PARTIES_VLD_PVT - show dependent code
ViewCSI_INST_PARTY_DETAILS_V
ViewCSI_IPH_DETAILS_V
Package BodyCSI_ML_UTIL_PVT - show dependent code
ViewCSI_PARTY_CONTACT_DETAILS_V
Package BodyCSI_PARTY_RELATIONSHIPS_PUB - show dependent code
Package BodyCSI_PARTY_RELATIONSHIPS_PVT - show dependent code
ViewCSI_T_PARTY_CONTACTS_V
ViewCSI_T_PARTY_DETAILS_V
ViewCS_AUDIT_REPORT_VW
Package BodyCS_KB_WF_PKG - show dependent code
Package BodyCS_SERVICEREQUEST_UTIL - show dependent code
ViewCS_SR_OWNERS_V
ViewCS_SR_SEARCH_NO_CONT_V
ViewCS_SR_SEARCH_V
Package BodyIBC_AUDIT_LOG_GRP - show dependent code
Package BodyIBC_UTILITIES_PVT - show dependent code
Package BodyIBC_VALIDATE_PVT - show dependent code
Package BodyIBU_DYN_USER_GROUPS_PKG - show dependent code
Package BodyIEU_DIAG_AUDIT_TRACK_PVT - show dependent code
ViewIEU_WP_TASK_OWNR_LOV_V
Package BodyIEX_PROCESS_ACCOUNT_WINNERS - show dependent code
Package BodyIEX_UWQ_POP_SUM_TBL_PVT - show dependent code
ViewJTF_RS_ALL_RESOURCES_VL
Package BodyJTF_RS_CONC_WF_PUB - show dependent code
ViewJTF_RS_DEFRESGROUPS_VL
Package BodyJTF_RS_GROUPS_AUD_PVT - show dependent code
Package BodyJTF_RS_GROUPS_PKG - show dependent code
Package BodyJTF_RS_GROUPS_PUB - show dependent code
PL/SQL PackageJTF_RS_GROUPS_PUB - show dependent code
Package BodyJTF_RS_GROUPS_PVT - show dependent code
PL/SQL PackageJTF_RS_GROUPS_PVT - show dependent code
PL/SQL PackageJTF_RS_GROUP_DENORM_PVT - show dependent code
Package BodyJTF_RS_GROUP_DENORM_PVT - show dependent code
Package BodyJTF_RS_GROUP_MEMBERS_PUB - show dependent code
PL/SQL PackageJTF_RS_GROUP_MEMBERS_PUB - show dependent code
Package BodyJTF_RS_GROUP_ORGS_PVT - show dependent code
PL/SQL PackageJTF_RS_GROUP_RELATE_CUHK - show dependent code
PL/SQL PackageJTF_RS_GROUP_RELATE_IUHK - show dependent code
Package BodyJTF_RS_GROUP_RELATE_IUHK - show dependent code
PL/SQL PackageJTF_RS_GROUP_RELATE_PUB - show dependent code
Package BodyJTF_RS_GROUP_RELATE_PUB - show dependent code
PL/SQL PackageJTF_RS_GROUP_RELATE_PVT - show dependent code
Package BodyJTF_RS_GROUP_RELATE_PVT - show dependent code
PL/SQL PackageJTF_RS_GROUP_RELATE_VUHK - show dependent code
Package BodyJTF_RS_GROUP_RELATE_VUHK - show dependent code
Package BodyJTF_RS_GROUP_REPORT_PUB - show dependent code
PL/SQL PackageJTF_RS_GROUP_USAGES_PUB - show dependent code
Package BodyJTF_RS_GROUP_USAGES_PUB - show dependent code
Package BodyJTF_RS_GROUP_USAGES_PVT - show dependent code
ViewJTF_RS_GRP_HIER_V
Package BodyJTF_RS_GRP_MEMBERSHIP_PUB - show dependent code
ViewJTF_RS_GRP_RELATIONS_VL
Package BodyJTF_RS_GRP_SUM_PUB - show dependent code
Package BodyJTF_RS_IMPORT_USER_PUB - show dependent code
Package BodyJTF_RS_JSP_LOV_RECS_PUB - show dependent code
ViewJTF_RS_RESOURCES_VL
PL/SQL PackageJTF_RS_RESOURCE_GROUP_CUHK - show dependent code
Package BodyJTF_RS_RESOURCE_GROUP_IUHK - show dependent code
PL/SQL PackageJTF_RS_RESOURCE_GROUP_IUHK - show dependent code
PL/SQL PackageJTF_RS_RESOURCE_GROUP_VUHK - show dependent code
Package BodyJTF_RS_SKILLS_REPORT_PUB - show dependent code
Package BodyJTF_RS_WF_INTEGRATION_PUB - show dependent code
ViewJTF_TASK_RESOURCES_VL
Package BodyJTF_TERRITORY_RESOURCE_PVT - show dependent code
ViewJTF_TERR_QLFY_RSC_DST_V
ViewJTF_TERR_QLFY_RSC_V
ViewJTF_TR_ALL_RESOURCES_V
Package BodyJTF_TTY_ALIGN_WEBADI_INT_PKG - show dependent code
ViewJTF_TTY_ALL_RESOURCES_V
Package BodyJTF_TTY_EXCEL_NAORG_PVT - show dependent code
ViewJTF_TTY_GEO_TERR_OWNER_LOV_V
Package BodyJTF_TTY_MAINTAIN_NA_PVT - show dependent code
ViewJTF_TTY_MY_DIRECTS_V
ViewJTF_TTY_MY_RESOURCES_V
Package BodyJTF_TTY_WEBADI_NADOC_PKG - show dependent code
Package BodyJTF_TTY_WEBADI_SALSTEAM_UPDATE - show dependent code
Package BodyJTY_WEBADI_OTH_TERR_DWNL_PKG - show dependent code
Package BodyOE_ID_TO_VALUE - show dependent code
ViewOKC_RESOURCE_GROUPS_V
ViewOKS_AUTH_SHOWALL_PROD_V
ViewOKS_PRODUCT_DETAILS_V
ViewOKS_RESOURCE_GROUPS_V
ViewPV_PRTNR_SALES_TEAM_V
Package BodyPV_TAP_BES_PKG - show dependent code
ViewQPR_SR_SG_HIER_V