[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PJI_DIS_ORGWT_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PJI.PJI_DIS_ORGWT_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Discoverer view of organization work type utilization data.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CAPACITY_HRS | NUMBER | Actual capacity based on resources calendar. | ||
| RES_TOTAL_HRS_A | NUMBER | Resource total actual hours | ||
| RES_CONF_HRS_S | NUMBER | Resource confirmed assigned hours | ||
| TOTAL_HRS_A | NUMBER | Total actual hours (as per timecards). | ||
| BILL_HRS_A | NUMBER | Capacity hours less total hours | ||
| CONF_HRS_S | NUMBER | Confirmed assignment hours | ||
| PROV_HRS_S | NUMBER | Provisional assignment hours for the resource. | ||
| CONF_OVERCOM_HRS_S | NUMBER | Confirmed over committed hours | ||
| PROV_OVERCOM_HRS_S | NUMBER | Provisional over committed hours | ||
| PERIOD_NAME | VARCHAR2 | (100) | Period name | |
| QUARTER_NAME | VARCHAR2 | (100) | Quarter name | |
| YEAR | VARCHAR2 | (100) | Year | |
| PERIOD_START_DATE | DATE | Period start date | ||
| PERIOD_END_DATE | DATE | Period end date | ||
| QUARTER_START_DATE | DATE | Quarter start date | ||
| QUARTER_END_DATE | DATE | Quarter end date | ||
| YEAR_START_DATE | DATE | Year start date | ||
| YEAR_END_DATE | DATE | Year end date | ||
| PERIOD_TYPE_ID | NUMBER | (15) | Yes | Level of calendar rollup |
| CALENDAR_TYPE | VARCHAR2 | (1) | Yes | Type of calendar |
| TIME_ID | NUMBER | (15) | Yes | Time identifier |
| WORK_TYPE_ID | NUMBER | (15) | Yes | Identifier for work type |
| ORGANIZATION_ID | NUMBER | The identifier of the organization that incurred the charges. | ||
| SUB_ORGANIZATION_ID | NUMBER | Identifier for subordinate organization. | ||
| ORGANIZATION_LEVEL | NUMBER | Level of organization | ||
| SUB_ORGANIZATION_LEVEL | NUMBER | Level of subordinate organization | ||
| ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Organization name |
| SUB_ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Subordinate organization name |
| EXPENDITURE_ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations of expenditure item. | |
| PERIOD_ID | NUMBER | Identifier for the period. | ||
| PERIOD_TYPE | VARCHAR2 | (19) | Identifier for the period type. | |
| QUARTER_ID | NUMBER | Identifier for the quarter | ||
| YEAR_ID | NUMBER | Identifier for the year. | ||
| CALENDAR_ID | NUMBER | Identifier for the calendar. | ||
| LAST_ACT_EXTR_DATE | NUMBER | Date of last actuals summarization run. | ||
| ORG_UTIL_CALC_METH | VARCHAR2 | (4000) | Organization utilization calculated method | |
| RES_UTIL_CALC_METH | VARCHAR2 | (4000) | Resource utilization calculated method |
Cut, paste (and edit) the following text to query this object:
SELECT CAPACITY_HRS
, RES_TOTAL_HRS_A
, RES_CONF_HRS_S
, TOTAL_HRS_A
, BILL_HRS_A
, CONF_HRS_S
, PROV_HRS_S
, CONF_OVERCOM_HRS_S
, PROV_OVERCOM_HRS_S
, PERIOD_NAME
, QUARTER_NAME
, YEAR
, PERIOD_START_DATE
, PERIOD_END_DATE
, QUARTER_START_DATE
, QUARTER_END_DATE
, YEAR_START_DATE
, YEAR_END_DATE
, PERIOD_TYPE_ID
, CALENDAR_TYPE
, TIME_ID
, WORK_TYPE_ID
, ORGANIZATION_ID
, SUB_ORGANIZATION_ID
, ORGANIZATION_LEVEL
, SUB_ORGANIZATION_LEVEL
, ORGANIZATION_NAME
, SUB_ORGANIZATION_NAME
, EXPENDITURE_ORG_ID
, PERIOD_ID
, PERIOD_TYPE
, QUARTER_ID
, YEAR_ID
, CALENDAR_ID
, LAST_ACT_EXTR_DATE
, ORG_UTIL_CALC_METH
, RES_UTIL_CALC_METH
FROM APPS.PJI_DIS_ORGWT_V;
APPS
FND_PROFILE
- show dependent code
HR_ALL_ORGANIZATION_UNITS_TL
PA_WORK_TYPES_B
PJI_ORG_DENORM
PJI_ORG_EXTR_INFO
PJI_PMV_ORGZ_DIM_TMP
PJI_PMV_ORG_DIM_TMP
PJI_RM_WT_F_MV
PJI_TIME_MV
PJI_UTILS
- show dependent code
PUBLIC
DUAL
APPS.PJI_DIS_ORGWT_V is not referenced by any database object
|
|
|
|