[Home] [Help]
[Dependency Information]
| Object Name: | JTF_RS_GROUPS_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | JTF.JTF_RS_GROUPS_VL
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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. |
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;
APPS
JTF_RS_GROUPS_B
JTF_RS_GROUPS_TL
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
|
|
|
|