[Home] [Help] [Dependency Information]
Object Name: | PA_REP_RES_SCHHRS_WK_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_REP_RES_SCHHRS_WK_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 |
---|---|---|---|---|
YEAR | NUMBER | Year to which the global week belong | ||
MONTH | NUMBER | Month to which the global week belongs | ||
GLOBAL_WEEK | DATE | Global week end date | ||
ITEM_DATE | DATE | Yes | Item date which will be used as day of the week | |
CONFIRMED_HOURS | NUMBER | Number of hours for which the resource is confirmed | ||
PROVISIONAL_HOURS | NUMBER | Number of hours for which the resource is provisional | ||
RESOURCE_ID | NUMBER | Internal identifier for the resource |
Cut, paste (and edit) the following text to query this object:
SELECT YEAR
, MONTH
, GLOBAL_WEEK
, ITEM_DATE
, CONFIRMED_HOURS
, PROVISIONAL_HOURS
, RESOURCE_ID
FROM APPS.PA_REP_RES_SCHHRS_WK_V;
APPS.PA_REP_RES_SCHHRS_WK_V is not referenced by any database object
|
|
|