[Home] [Help] [Dependency Information]
Object Name: | PA_C_RES_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_C_RES_DETAILS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_SOURCE_ID | NUMBER | (10) | ||
RESOURCE_NAME | VARCHAR2 | (240) | ||
RESOURCE_NUMBER | VARCHAR2 | (30) | ||
RESOURCE_EMAIL | VARCHAR2 | (240) | ||
RESOURCE_JOB_ID | NUMBER | |||
RESOURCE_JOB_NAME | VARCHAR2 | (700) | ||
RESOURCE_JOB_LEVEL | NUMBER | |||
MAPPED_JOB_NAME | VARCHAR2 | (4000) | ||
MAPPED_JOB_LEVEL | NUMBER | |||
RESOURCE_ORGANIZATION_ID | NUMBER | |||
RESOURCE_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
RESOURCE_CALENDAR_NAME | VARCHAR2 | (4000) | ||
RESOURCE_MANAGER_NAME | VARCHAR2 | (240) | ||
RESOURCE_MANAGER_ID | NUMBER | |||
WORK_IN_CURRENT_LOCATION_ONLY | VARCHAR2 | (30) | ||
WORK_IN_ALL_LOCATIONS | VARCHAR2 | (30) | ||
TRAVEL_DOMESTICALLY | VARCHAR2 | (30) | ||
TRAVEL_INTERNATIONALLY | VARCHAR2 | (30) | ||
PERSON_TYPE | VARCHAR2 | (4000) | ||
PROJECTED_END_DATE | DATE | |||
SUPPLIER_NAME | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_SOURCE_ID
, RESOURCE_NAME
, RESOURCE_NUMBER
, RESOURCE_EMAIL
, RESOURCE_JOB_ID
, RESOURCE_JOB_NAME
, RESOURCE_JOB_LEVEL
, MAPPED_JOB_NAME
, MAPPED_JOB_LEVEL
, RESOURCE_ORGANIZATION_ID
, RESOURCE_ORGANIZATION_NAME
, RESOURCE_CALENDAR_NAME
, RESOURCE_MANAGER_NAME
, RESOURCE_MANAGER_ID
, WORK_IN_CURRENT_LOCATION_ONLY
, WORK_IN_ALL_LOCATIONS
, TRAVEL_DOMESTICALLY
, TRAVEL_INTERNATIONALLY
, PERSON_TYPE
, PROJECTED_END_DATE
, SUPPLIER_NAME
FROM APPS.PA_C_RES_DETAILS_V;
APPS.PA_C_RES_DETAILS_V is not referenced by any database object
|
|
|