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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ASGMT_SYS_STATUS_CODE	VARCHAR2	(30)
ASSIGNMENT_ID	NUMBER
AVAILABILITY_FLAG	VARCHAR2	(1)
AVAILABILITY_QUANTITY	NUMBER
BORROWED_FLAG	VARCHAR2	(1)
BURDEN_REJECTION_CODE	VARCHAR2	(30)
CAPACITY_QUANTITY	NUMBER
CONFIRMED_QTY	NUMBER	(30)
COST_REJECTION_CODE	VARCHAR2	(30)
COST_TXN_CURRENCY_CODE	VARCHAR2	(15)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
DELETE_FLAG	VARCHAR2	(1)
ERROR_FLAG	VARCHAR2	(1)
EXPENDITURE_ORGANIZATION_ID	NUMBER
EXPENDITURE_ORG_ID	NUMBER
EXPENDITURE_TYPE	VARCHAR2	(30)
EXPENDITURE_TYPE_CLASS	VARCHAR2	(30)
EXPFUNC_BURDENED_COST	NUMBER
EXPFUNC_CURRENCY_CODE	VARCHAR2	(15)
EXPFUNC_RAW_COST	NUMBER
EXPFUNC_TRANSFER_PRICE	NUMBER
FORECAST_AMT_CALC_FLAG	VARCHAR2	(1)
FORECAST_ITEM_ID	NUMBER
FORECAST_ITEM_TYPE	VARCHAR2	(30)
GLOBAL_EXP_PERIOD_END_DATE	DATE
ITEM_DATE	DATE
ITEM_QUANTITY	NUMBER
ITEM_UOM	VARCHAR2	(30)
JOB_ID	NUMBER
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
OTHER_REJECTION_CODE	VARCHAR2	(30)
OVERCOMMITMENT_FLAG	VARCHAR2	(1)
OVERCOMMITMENT_QUANTITY	NUMBER
OVERPROVISIONAL_QTY	NUMBER
OVER_PROV_CONF_QTY	NUMBER	(30)
PERSON_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
PROJECT_BURDENED_COST	NUMBER
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_ID	NUMBER
PROJECT_ORGANIZATION_ID	NUMBER
PROJECT_ORG_ID	NUMBER
PROJECT_RAW_COST	NUMBER
PROJECT_REVENUE	NUMBER
PROJECT_TRANSFER_PRICE	NUMBER
PROJECT_TYPE_CLASS	VARCHAR2	(30)
PROJFUNC_BURDENED_COST	NUMBER
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
PROJFUNC_RAW_COST	NUMBER
PROJFUNC_REVENUE	NUMBER
PROJFUNC_TRANSFER_PRICE	NUMBER
PROVISIONAL_FLAG	VARCHAR2	(1)
PROVISIONAL_QTY	NUMBER	(30)
PURGE_BATCH_ID	NUMBER	(15)	Yes
PURGE_PROJECT_ID	NUMBER	(15)	Yes
PURGE_RELEASE	VARCHAR2	(50)	Yes
PVDR_GL_PERIOD_NAME	VARCHAR2	(30)
PVDR_PA_PERIOD_NAME	VARCHAR2	(30)
PVDR_PERIOD_SET_NAME	VARCHAR2	(30)
RCVR_GL_PERIOD_NAME	VARCHAR2	(30)
RCVR_PA_PERIOD_NAME	VARCHAR2	(30)
RCVR_PERIOD_SET_NAME	VARCHAR2	(30)
REQUEST_ID	NUMBER
RESOURCE_ID	NUMBER
REVENUE_TXN_CURRENCY_CODE	VARCHAR2	(15)
REV_REJECTION_CODE	VARCHAR2	(30)
TP_AMOUNT_TYPE	VARCHAR2	(30)
TP_REJECTION_CODE	VARCHAR2	(30)
TP_TXN_CURRENCY_CODE	VARCHAR2	(15)
TXN_BURDENED_COST	NUMBER
TXN_RAW_COST	NUMBER
TXN_REVENUE	NUMBER
TXN_TRANSFER_PRICE	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASGMT_SYS_STATUS_CODE
,      ASSIGNMENT_ID
,      AVAILABILITY_FLAG
,      AVAILABILITY_QUANTITY
,      BORROWED_FLAG
,      BURDEN_REJECTION_CODE
,      CAPACITY_QUANTITY
,      CONFIRMED_QTY
,      COST_REJECTION_CODE
,      COST_TXN_CURRENCY_CODE
,      CREATED_BY
,      CREATION_DATE
,      DELETE_FLAG
,      ERROR_FLAG
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_TYPE_CLASS
,      EXPFUNC_BURDENED_COST
,      EXPFUNC_CURRENCY_CODE
,      EXPFUNC_RAW_COST
,      EXPFUNC_TRANSFER_PRICE
,      FORECAST_AMT_CALC_FLAG
,      FORECAST_ITEM_ID
,      FORECAST_ITEM_TYPE
,      GLOBAL_EXP_PERIOD_END_DATE
,      ITEM_DATE
,      ITEM_QUANTITY
,      ITEM_UOM
,      JOB_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OTHER_REJECTION_CODE
,      OVERCOMMITMENT_FLAG
,      OVERCOMMITMENT_QUANTITY
,      OVERPROVISIONAL_QTY
,      OVER_PROV_CONF_QTY
,      PERSON_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_BURDENED_COST
,      PROJECT_CURRENCY_CODE
,      PROJECT_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ORG_ID
,      PROJECT_RAW_COST
,      PROJECT_REVENUE
,      PROJECT_TRANSFER_PRICE
,      PROJECT_TYPE_CLASS
,      PROJFUNC_BURDENED_COST
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_RAW_COST
,      PROJFUNC_REVENUE
,      PROJFUNC_TRANSFER_PRICE
,      PROVISIONAL_FLAG
,      PROVISIONAL_QTY
,      PURGE_BATCH_ID
,      PURGE_PROJECT_ID
,      PURGE_RELEASE
,      PVDR_GL_PERIOD_NAME
,      PVDR_PA_PERIOD_NAME
,      PVDR_PERIOD_SET_NAME
,      RCVR_GL_PERIOD_NAME
,      RCVR_PA_PERIOD_NAME
,      RCVR_PERIOD_SET_NAME
,      REQUEST_ID
,      RESOURCE_ID
,      REVENUE_TXN_CURRENCY_CODE
,      REV_REJECTION_CODE
,      TP_AMOUNT_TYPE
,      TP_REJECTION_CODE
,      TP_TXN_CURRENCY_CODE
,      TXN_BURDENED_COST
,      TXN_RAW_COST
,      TXN_REVENUE
,      TXN_TRANSFER_PRICE
FROM PA.PA_FRCST_ITEMS_AR#;

Dependencies

[top of page]

PA.PA_FRCST_ITEMS_AR# references the following:

PA: PA_FRCST_ITEMS_AR

PA.PA_FRCST_ITEMS_AR# is referenced by following:

APPS: PA_FRCST_ITEMS_AR