[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JTF_RS_DEFRESOURCES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  FND.JTF_RS_DEFRESOURCES_V
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| RESOURCE_ID | NUMBER | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| CATEGORY | VARCHAR2 | (30) | Yes | |
| CATG_MEANING | VARCHAR2 | (30) | Yes | |
| RESOURCE_NUMBER | VARCHAR2 | (30) | Yes | |
| SOURCE_ID | NUMBER | |||
| ADDRESS_ID | NUMBER | |||
| CONTACT_ID | NUMBER | |||
| MANAGING_EMPLOYEE_ID | NUMBER | |||
| START_DATE_ACTIVE | DATE | Yes | ||
| END_DATE_ACTIVE | DATE | |||
| TIME_ZONE | NUMBER | |||
| COST_PER_HR | NUMBER | |||
| PRIMARY_LANGUAGE | VARCHAR2 | (30) | ||
| SECONDARY_LANGUAGE | VARCHAR2 | (30) | ||
| SUPPORT_SITE_ID | NUMBER | |||
| IES_AGENT_LOGIN | VARCHAR2 | (240) | ||
| SERVER_GROUP_ID | NUMBER | |||
| ASSIGNED_TO_GROUP_ID | NUMBER | |||
| COST_CENTER | VARCHAR2 | (30) | ||
| CHARGE_TO_COST_CENTER | VARCHAR2 | (30) | ||
| COMPENSATION_CURRENCY_CODE | VARCHAR2 | (15) | ||
| COMMISSIONABLE_FLAG | VARCHAR2 | (1) | ||
| HOLD_REASON_CODE | VARCHAR2 | (30) | ||
| HOLD_PAYMENT | VARCHAR2 | (1) | ||
| COMP_SERVICE_TEAM_ID | NUMBER | |||
| TRANSACTION_NUMBER | NUMBER | |||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| USER_ID | NUMBER | |||
| RESOURCE_NAME | VARCHAR2 | (360) | ||
| SOURCE_NAME | VARCHAR2 | (360) | ||
| SOURCE_NUMBER | VARCHAR2 | (30) | ||
| SOURCE_JOB_TITLE | VARCHAR2 | (240) | ||
| SOURCE_EMAIL | VARCHAR2 | (2000) | ||
| SOURCE_PHONE | VARCHAR2 | (2000) | ||
| SOURCE_ORG_ID | NUMBER | |||
| SOURCE_ORG_NAME | VARCHAR2 | (360) | ||
| SOURCE_ADDRESS1 | VARCHAR2 | (240) | ||
| SOURCE_ADDRESS2 | VARCHAR2 | (240) | ||
| SOURCE_ADDRESS3 | VARCHAR2 | (240) | ||
| SOURCE_ADDRESS4 | VARCHAR2 | (240) | ||
| SOURCE_CITY | VARCHAR2 | (60) | ||
| SOURCE_POSTAL_CODE | VARCHAR2 | (60) | ||
| SOURCE_STATE | VARCHAR2 | (150) | ||
| SOURCE_PROVINCE | VARCHAR2 | (150) | ||
| SOURCE_COUNTY | VARCHAR2 | (150) | ||
| SOURCE_COUNTRY | VARCHAR2 | (60) | ||
| SOURCE_MGR_ID | NUMBER | |||
| SOURCE_MGR_NAME | VARCHAR2 | (360) | ||
| SOURCE_BUSINESS_GRP_ID | NUMBER | |||
| SOURCE_BUSINESS_GRP_NAME | VARCHAR2 | (360) | ||
| SOURCE_FIRST_NAME | VARCHAR2 | (360) | ||
| SOURCE_MIDDLE_NAME | VARCHAR2 | (360) | ||
| SOURCE_LAST_NAME | VARCHAR2 | (360) | ||
| SOURCE_CATEGORY | VARCHAR2 | (360) | ||
| SOURCE_STATUS | VARCHAR2 | (360) | ||
| USER_NAME | VARCHAR2 | (100) | ||
| SOURCE_OFFICE | VARCHAR2 | (45) | ||
| SOURCE_LOCATION | VARCHAR2 | (45) | ||
| SOURCE_MAILSTOP | VARCHAR2 | (45) | ||
| SOURCE_MOBILE_PHONE | VARCHAR2 | (60) | ||
| SOURCE_PAGER | VARCHAR2 | (60) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, RESOURCE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CATEGORY
, CATG_MEANING
, RESOURCE_NUMBER
, SOURCE_ID
, ADDRESS_ID
, CONTACT_ID
, MANAGING_EMPLOYEE_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, TIME_ZONE
, COST_PER_HR
, PRIMARY_LANGUAGE
, SECONDARY_LANGUAGE
, SUPPORT_SITE_ID
, IES_AGENT_LOGIN
, SERVER_GROUP_ID
, ASSIGNED_TO_GROUP_ID
, COST_CENTER
, CHARGE_TO_COST_CENTER
, COMPENSATION_CURRENCY_CODE
, COMMISSIONABLE_FLAG
, HOLD_REASON_CODE
, HOLD_PAYMENT
, COMP_SERVICE_TEAM_ID
, TRANSACTION_NUMBER
, OBJECT_VERSION_NUMBER
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, USER_ID
, RESOURCE_NAME
, SOURCE_NAME
, SOURCE_NUMBER
, SOURCE_JOB_TITLE
, SOURCE_EMAIL
, SOURCE_PHONE
, SOURCE_ORG_ID
, SOURCE_ORG_NAME
, SOURCE_ADDRESS1
, SOURCE_ADDRESS2
, SOURCE_ADDRESS3
, SOURCE_ADDRESS4
, SOURCE_CITY
, SOURCE_POSTAL_CODE
, SOURCE_STATE
, SOURCE_PROVINCE
, SOURCE_COUNTY
, SOURCE_COUNTRY
, SOURCE_MGR_ID
, SOURCE_MGR_NAME
, SOURCE_BUSINESS_GRP_ID
, SOURCE_BUSINESS_GRP_NAME
, SOURCE_FIRST_NAME
, SOURCE_MIDDLE_NAME
, SOURCE_LAST_NAME
, SOURCE_CATEGORY
, SOURCE_STATUS
, USER_NAME
, SOURCE_OFFICE
, SOURCE_LOCATION
, SOURCE_MAILSTOP
, SOURCE_MOBILE_PHONE
, SOURCE_PAGER
FROM APPS.JTF_RS_DEFRESOURCES_V;
APPS
JTF_OBJECTS_VL
JTF_RS_RESOURCE_EXTNS_VL
APPS.JTF_RS_DEFRESOURCES_V is not referenced by any database object
|
|
|
|