[Home] [Help]
[Dependency Information]
VIEW: APPS.JTF_TASK_RESOURCES_VL
Object Details
Object Name: | JTF_TASK_RESOURCES_VL |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_TASK_RESOURCES_VL
|
---|
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
RESOURCE_ID |
NUMBER |
|
|
|
RESOURCE_NUMBER |
VARCHAR2 |
(30) |
|
|
RESOURCE_TYPE |
VARCHAR2 |
(19) |
|
|
RESOURCE_NAME |
VARCHAR2 |
(360) |
|
|
EMAIL |
VARCHAR2 |
(2000) |
|
|
START_DATE_ACTIVE |
DATE |
|
|
|
END_DATE_ACTIVE |
DATE |
|
|
|
PHONE |
VARCHAR2 |
(2000) |
|
|
PERSON_PARTY_ID |
NUMBER |
|
|
|
ORG_ID |
NUMBER |
|
|
|
ORG_NAME |
VARCHAR2 |
(360) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, RESOURCE_NUMBER
, RESOURCE_TYPE
, RESOURCE_NAME
, EMAIL
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PHONE
, PERSON_PARTY_ID
, ORG_ID
, ORG_NAME
FROM APPS.JTF_TASK_RESOURCES_VL;
Dependencies
[top of page]
APPS.JTF_TASK_RESOURCES_VL references the following:
-
APPS
-
JTF_RS_GROUPS_VL
-
JTF_RS_RESOURCE_EXTNS_VL
-
JTF_RS_TEAMS_VL
APPS.JTF_TASK_RESOURCES_VL is referenced by following:
-
APPS
-
CSFW_TASKS_PUB
- show dependent code
-
JTF_ASSIGN_PUB
- show dependent code
-
JTF_CALENDAR_PUB
- show dependent code
-
JTF_CALENDAR_PUB_24HR
- show dependent code
-
JTF_CAL_RESOURCE_ASSIGN_PKG
- show dependent code
-
JTF_CAL_RES_ASSIGN_V
-
JTF_TASK_MASS_PVT
- show dependent code