[Home] [Help] [Dependency Information]
Object Name: | PA_FORECAST_ITEM_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_ITEM_ID | NUMBER | Yes | ||
AMOUNT_TYPE_ID | NUMBER | Yes | ||
LINE_NUM | NUMBER | Yes | ||
RESOURCE_TYPE_CODE | VARCHAR2 | (30) | Yes | |
PERSON_BILLABLE_FLAG | VARCHAR2 | (1) | Yes | |
ITEM_DATE | DATE | Yes | ||
ITEM_UOM | VARCHAR2 | (30) | Yes | |
ITEM_QUANTITY | NUMBER | Yes | ||
EXPENDITURE_ORG_ID | NUMBER | |||
PROJECT_ORG_ID | NUMBER | |||
PVDR_ACCT_CURR_CODE | VARCHAR2 | (15) | ||
PVDR_ACCT_AMOUNT | NUMBER | |||
RCVR_ACCT_CURR_CODE | VARCHAR2 | (15) | ||
RCVR_ACCT_AMOUNT | NUMBER | |||
PROJ_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJ_AMOUNT | NUMBER | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
DENOM_AMOUNT | NUMBER | |||
TP_AMOUNT_TYPE | VARCHAR2 | (30) | ||
BILLABLE_FLAG | VARCHAR2 | (1) | Yes | |
FORECAST_SUMMARIZED_CODE | VARCHAR2 | (30) | Yes | |
UTIL_SUMMARIZED_CODE | VARCHAR2 | (30) | ||
WORK_TYPE_ID | NUMBER | Yes | ||
RESOURCE_UTIL_CATEGORY_ID | NUMBER | |||
ORG_UTIL_CATEGORY_ID | NUMBER | |||
RESOURCE_UTIL_WEIGHTED | NUMBER | |||
ORG_UTIL_WEIGHTED | NUMBER | |||
PROVISIONAL_FLAG | VARCHAR2 | (1) | Yes | |
REVERSED_FLAG | VARCHAR2 | (1) | Yes | |
NET_ZERO_FLAG | VARCHAR2 | (1) | Yes | |
REDUCE_CAPACITY_FLAG | VARCHAR2 | (1) | Yes | |
LINE_NUM_REVERSED | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
CAPACITY_QUANTITY | NUMBER | |||
OVERCOMMITMENT_QTY | NUMBER | |||
OVERPROVISIONAL_QTY | NUMBER | |||
OVER_PROV_CONF_QTY | NUMBER | |||
CONFIRMED_QTY | NUMBER | |||
PROVISIONAL_QTY | NUMBER | |||
JOB_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
PJI_SUMMARIZED_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_ITEM_ID
, AMOUNT_TYPE_ID
, LINE_NUM
, RESOURCE_TYPE_CODE
, PERSON_BILLABLE_FLAG
, ITEM_DATE
, ITEM_UOM
, ITEM_QUANTITY
, EXPENDITURE_ORG_ID
, PROJECT_ORG_ID
, PVDR_ACCT_CURR_CODE
, PVDR_ACCT_AMOUNT
, RCVR_ACCT_CURR_CODE
, RCVR_ACCT_AMOUNT
, PROJ_CURRENCY_CODE
, PROJ_AMOUNT
, DENOM_CURRENCY_CODE
, DENOM_AMOUNT
, TP_AMOUNT_TYPE
, BILLABLE_FLAG
, FORECAST_SUMMARIZED_CODE
, UTIL_SUMMARIZED_CODE
, WORK_TYPE_ID
, RESOURCE_UTIL_CATEGORY_ID
, ORG_UTIL_CATEGORY_ID
, RESOURCE_UTIL_WEIGHTED
, ORG_UTIL_WEIGHTED
, PROVISIONAL_FLAG
, REVERSED_FLAG
, NET_ZERO_FLAG
, REDUCE_CAPACITY_FLAG
, LINE_NUM_REVERSED
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CAPACITY_QUANTITY
, OVERCOMMITMENT_QTY
, OVERPROVISIONAL_QTY
, OVER_PROV_CONF_QTY
, CONFIRMED_QTY
, PROVISIONAL_QTY
, JOB_ID
, PROJECT_ID
, RESOURCE_ID
, EXPENDITURE_ORGANIZATION_ID
, PJI_SUMMARIZED_FLAG
FROM PA.PA_FORECAST_ITEM_DETAILS#;
|
|
|