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

VIEW: APPS.JTF_TERR_RESOURCES_V

Object Details
Object Name: JTF_TERR_RESOURCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_TERR_RESOURCES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view stores all the informations of the resources assigned to territories .


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier of the table jtf_terr_rsc
TERR_RSC_ID NUMBER
Yes Unique identifier of the table jtf_terr_rsc
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TERR_ID NUMBER
Yes Unique identifier of the territory
RESOURCE_ID NUMBER
Yes Unique identifier of the resource
RESOURCE_TYPE VARCHAR2 (60)
Identifies the Resource Type , like employee .
RESOURCE_TYPE_NAME VARCHAR2 (30) Yes Description of the resource type
GROUP_ID NUMBER

Unique identifier of the resource group to which the resource belongs.
GROUP_NAME VARCHAR2 (4000)
Name of the group
ROLE VARCHAR2 (60)
Role of the resource
PRIMARY_CONTACT_FLAG VARCHAR2 (1)
Indicates whether the resource is the primary contact.
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active
FULL_ACCESS_FLAG VARCHAR2 (1)
Full Access Flag
ORG_ID NUMBER

Organization identifier
RESOURCE_NAME VARCHAR2 (4000)
Name of the resource
ROLE_NAME VARCHAR2 (60)
Name of the role
PERSON_ID NUMBER

Unique identifier of the person
Query Text

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


SELECT ROW_ID
,      TERR_RSC_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TERR_ID
,      RESOURCE_ID
,      RESOURCE_TYPE
,      RESOURCE_TYPE_NAME
,      GROUP_ID
,      GROUP_NAME
,      ROLE
,      PRIMARY_CONTACT_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      FULL_ACCESS_FLAG
,      ORG_ID
,      RESOURCE_NAME
,      ROLE_NAME
,      PERSON_ID
FROM APPS.JTF_TERR_RESOURCES_V;

Dependencies

[top of page]

APPS.JTF_TERR_RESOURCES_V references the following:

SchemaAPPS
ViewJTF_OBJECTS_VL
ViewJTF_RS_ROLES_VL
PL/SQL PackageJTF_TERRITORY_RESOURCE_PVT - show dependent code
SynonymJTF_TERR_RSC
APPS.JTF_TERR_RESOURCES_V is referenced by following:

SchemaAPPS
Package BodyJTF_TERRITORY_GET_PUB - show dependent code
Package BodyJTF_TERR_CHANGES_REPORT_PVT - show dependent code
Package BodyJTF_TERR_DEFINITION_PARAM_PVT - show dependent code
Package BodyJTF_TERR_DEFINITION_REPORT_PVT - show dependent code
Package BodyJTF_TERR_JSP_LOV_RECS_PUB - show dependent code
ViewJTF_TERR_SRCH_ADV_ESCL_V
ViewJTF_TERR_SRCH_ADV_MAIN_V
ViewJTF_TERR_SRCH_ESCL_V
ViewJTF_TERR_SRCH_MAIN_V