[Home] [Help] [Dependency Information]
Object Name: | PA_FORECAST_ITEMS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_ITEM_ID | NUMBER | Yes | ||
FORECAST_ITEM_TYPE | VARCHAR2 | (30) | Yes | |
PROJECT_ORG_ID | NUMBER | Yes | ||
EXPENDITURE_ORG_ID | NUMBER | Yes | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
PROJECT_ORGANIZATION_ID | NUMBER | |||
PROJECT_ID | NUMBER | Yes | ||
PROJECT_TYPE_CLASS | VARCHAR2 | (30) | Yes | |
PERSON_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
BORROWED_FLAG | VARCHAR2 | (1) | Yes | |
ASSIGNMENT_ID | NUMBER | |||
ITEM_DATE | DATE | Yes | ||
ITEM_UOM | VARCHAR2 | (30) | Yes | |
ITEM_QUANTITY | NUMBER | Yes | ||
PVDR_PERIOD_SET_NAME | VARCHAR2 | (30) | ||
PVDR_PA_PERIOD_NAME | VARCHAR2 | (30) | ||
PVDR_GL_PERIOD_NAME | VARCHAR2 | (30) | ||
RCVR_PERIOD_SET_NAME | VARCHAR2 | (30) | ||
RCVR_PA_PERIOD_NAME | VARCHAR2 | (30) | ||
RCVR_GL_PERIOD_NAME | VARCHAR2 | (30) | ||
GLOBAL_EXP_PERIOD_END_DATE | DATE | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | |
EXPENDITURE_TYPE_CLASS | VARCHAR2 | (30) | Yes | |
COST_REJECTION_CODE | VARCHAR2 | (30) | ||
REV_REJECTION_CODE | VARCHAR2 | (30) | ||
TP_REJECTION_CODE | VARCHAR2 | (30) | ||
BURDEN_REJECTION_CODE | VARCHAR2 | (30) | ||
OTHER_REJECTION_CODE | VARCHAR2 | (30) | ||
DELETE_FLAG | VARCHAR2 | (1) | Yes | |
ERROR_FLAG | VARCHAR2 | (1) | Yes | |
PROVISIONAL_FLAG | VARCHAR2 | (1) | Yes | |
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 | |||
ASGMT_SYS_STATUS_CODE | VARCHAR2 | (30) | ||
CAPACITY_QUANTITY | NUMBER | |||
OVERCOMMITMENT_QUANTITY | NUMBER | |||
AVAILABILITY_QUANTITY | NUMBER | |||
OVERCOMMITMENT_FLAG | VARCHAR2 | (1) | ||
AVAILABILITY_FLAG | VARCHAR2 | (1) | ||
TP_AMOUNT_TYPE | VARCHAR2 | (30) | ||
FORECAST_AMT_CALC_FLAG | VARCHAR2 | (1) | ||
COST_TXN_CURRENCY_CODE | VARCHAR2 | (15) | ||
TXN_RAW_COST | NUMBER | |||
TXN_BURDENED_COST | NUMBER | |||
REVENUE_TXN_CURRENCY_CODE | VARCHAR2 | (15) | ||
TXN_REVENUE | NUMBER | |||
TP_TXN_CURRENCY_CODE | VARCHAR2 | (15) | ||
TXN_TRANSFER_PRICE | NUMBER | |||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_RAW_COST | NUMBER | |||
PROJECT_BURDENED_COST | NUMBER | |||
PROJECT_REVENUE | NUMBER | |||
PROJECT_TRANSFER_PRICE | NUMBER | |||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJFUNC_RAW_COST | NUMBER | |||
PROJFUNC_BURDENED_COST | NUMBER | |||
PROJFUNC_REVENUE | NUMBER | |||
PROJFUNC_TRANSFER_PRICE | NUMBER | |||
EXPFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
EXPFUNC_RAW_COST | NUMBER | |||
EXPFUNC_BURDENED_COST | NUMBER | |||
EXPFUNC_TRANSFER_PRICE | NUMBER | |||
OVERPROVISIONAL_QTY | NUMBER | |||
OVER_PROV_CONF_QTY | NUMBER | |||
CONFIRMED_QTY | NUMBER | |||
PROVISIONAL_QTY | NUMBER | |||
JOB_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_ITEM_ID
, FORECAST_ITEM_TYPE
, PROJECT_ORG_ID
, EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID
, PROJECT_ORGANIZATION_ID
, PROJECT_ID
, PROJECT_TYPE_CLASS
, PERSON_ID
, RESOURCE_ID
, BORROWED_FLAG
, ASSIGNMENT_ID
, ITEM_DATE
, ITEM_UOM
, ITEM_QUANTITY
, PVDR_PERIOD_SET_NAME
, PVDR_PA_PERIOD_NAME
, PVDR_GL_PERIOD_NAME
, RCVR_PERIOD_SET_NAME
, RCVR_PA_PERIOD_NAME
, RCVR_GL_PERIOD_NAME
, GLOBAL_EXP_PERIOD_END_DATE
, EXPENDITURE_TYPE
, EXPENDITURE_TYPE_CLASS
, COST_REJECTION_CODE
, REV_REJECTION_CODE
, TP_REJECTION_CODE
, BURDEN_REJECTION_CODE
, OTHER_REJECTION_CODE
, DELETE_FLAG
, ERROR_FLAG
, PROVISIONAL_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ASGMT_SYS_STATUS_CODE
, CAPACITY_QUANTITY
, OVERCOMMITMENT_QUANTITY
, AVAILABILITY_QUANTITY
, OVERCOMMITMENT_FLAG
, AVAILABILITY_FLAG
, TP_AMOUNT_TYPE
, FORECAST_AMT_CALC_FLAG
, COST_TXN_CURRENCY_CODE
, TXN_RAW_COST
, TXN_BURDENED_COST
, REVENUE_TXN_CURRENCY_CODE
, TXN_REVENUE
, TP_TXN_CURRENCY_CODE
, TXN_TRANSFER_PRICE
, PROJECT_CURRENCY_CODE
, PROJECT_RAW_COST
, PROJECT_BURDENED_COST
, PROJECT_REVENUE
, PROJECT_TRANSFER_PRICE
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_RAW_COST
, PROJFUNC_BURDENED_COST
, PROJFUNC_REVENUE
, PROJFUNC_TRANSFER_PRICE
, EXPFUNC_CURRENCY_CODE
, EXPFUNC_RAW_COST
, EXPFUNC_BURDENED_COST
, EXPFUNC_TRANSFER_PRICE
, OVERPROVISIONAL_QTY
, OVER_PROV_CONF_QTY
, CONFIRMED_QTY
, PROVISIONAL_QTY
, JOB_ID
FROM PA.PA_FORECAST_ITEMS#;
|
|
|