eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: PA.PA_FORECAST_ITEMS#

Object Details

Object Name:	PA_FORECAST_ITEMS#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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

Query Text

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#;

Dependencies

[top of page]

PA.PA_FORECAST_ITEMS# references the following:

PA: PA_FORECAST_ITEMS

PA.PA_FORECAST_ITEMS# is referenced by following:

APPS: PA_FORECAST_ITEMS