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

TABLE: PA.PA_FRCST_ITEMS_AR

Object Details
Object Name: PA_FRCST_ITEMS_AR
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_FRCST_ITEMS_AR
Subobject Name:
Status: VALID


This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores similar information for each unassigned day for all resources that can be scheduled.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_FRCST_ITEMS_AR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPURGE_PROJECT_ID
Columns
Name Datatype Length Mandatory Comments
ASGMT_SYS_STATUS_CODE VARCHAR2 (30)
The system status of the assignment on the date of the item (item_date). This column is NULL for records with a forecast item type of 'U'.
ASSIGNMENT_ID NUMBER

The identifier of the assignment (for Forecast Item Type = U , this column is null)
AVAILABILITY_FLAG VARCHAR2 (1)
A value of 'Y' in this column indicates if the resource is available on the date of the item (item_date). This column is NULL for all other records, and for records with a forecast item type of 'A' or 'R'. This column ignores provisional
AVAILABILITY_QUANTITY NUMBER

The total number of hours the resource is available on the date of the item (item_date). This quantity is derived by subtracting the total number of confirmed hours from the capacity, and therefore, may include provisional hours. This c
BORROWED_FLAG VARCHAR2 (1)
Indicates if a borrowed resource is used for this assignment
BURDEN_REJECTION_CODE VARCHAR2 (30)
The rejection code of error during the burden amount calculation.
CAPACITY_QUANTITY NUMBER

This column is NULL for records with a forecast item type of 'A' or 'R'.
CONFIRMED_QTY NUMBER (30)
The total number of hours the resource is confirmed on the date of the item (item_date). This column is NULL for records with a forecast item type of 'A' or 'R' and for records with a forecast item type of 'U' if the amount is zero
COST_REJECTION_CODE VARCHAR2 (30)
The rejection code of error during the cost amount calculation
COST_TXN_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard Who column
DELETE_FLAG VARCHAR2 (1)
If the item is reversed , this flag indicates that it can be deleted once the amount details have been processed for summarization
ERROR_FLAG VARCHAR2 (1)
Indicates the forecast item generation error
EXPENDITURE_ORGANIZATION_ID NUMBER

Identifier of the expenditure organization. The value for this column is, derived from the assignment for open assignments and from the resource for staffed assignments.
EXPENDITURE_ORG_ID NUMBER

Identifier of the expenditure operating unit. The value of this column is, derived from the assignment for open assignments and from the resource for staffed assignments.
EXPENDITURE_TYPE VARCHAR2 (30)
The expenditure type defined for the assignment
EXPENDITURE_TYPE_CLASS VARCHAR2 (30)
The expenditure type class defined for the assignment
EXPFUNC_BURDENED_COST NUMBER

The burdened cost in expenditure functional currency of the forecast item
EXPFUNC_CURRENCY_CODE VARCHAR2 (15)
The expenditure functional currency code of the forecast item
EXPFUNC_RAW_COST NUMBER

The raw cost in expenditure functional currency of the forecast item
EXPFUNC_TRANSFER_PRICE NUMBER

The transfer price in expenditure functional currency of the forecast item
FORECAST_AMT_CALC_FLAG VARCHAR2 (1)
Indicates whether amount calculation has been done for the forecast item.
FORECAST_ITEM_ID NUMBER

The system -generated number that uniquely identifies the forecast item.
FORECAST_ITEM_TYPE VARCHAR2 (30)
Indicates the type of the forecast item. Valid values are: A for Assignment R for Requirement U for Unassigned Time.
GLOBAL_EXP_PERIOD_END_DATE DATE

The week end date to which this item corresponds based global expenditure week defined at the site level
ITEM_DATE DATE

The date of the forecast item
ITEM_QUANTITY NUMBER

The quantity for the item
ITEM_UOM VARCHAR2 (30)
The Unit of Measure for the item
JOB_ID NUMBER

Identifier of the job
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OTHER_REJECTION_CODE VARCHAR2 (30)
The rejection code of error for other than amount calculation
OVERCOMMITMENT_FLAG VARCHAR2 (1)
A value of 'Y' in this column indicates if the resource is overcommitted on the date of the item (item_date). This column is NULL for all other records, and for records with a forecast item type of 'A' or 'R'. This column ignores provisio
OVERCOMMITMENT_QUANTITY NUMBER

This quantity does not include provisional assignment hours. This column is NULL for records with a forecast item type of 'A' or 'R'.
OVERPROVISIONAL_QTY NUMBER

The total number of hours the resource is overcommitted using only provisional assignment hours on the date of the item (item_date). This quantity does not include confirmed assignment hours. This column is NULL for records with a foreca
OVER_PROV_CONF_QTY NUMBER (30)
The total number of hours the resource is overcommitted using provisional and confirmed assignment hours on the date of the item (item_date). This column is NULL for records with a forecast item type of 'A' or 'R' and for records with a
PERSON_ID NUMBER

Identifier of the Person (for Staffed and Unassigned Time only)
PROGRAM_APPLICATION_ID NUMBER

Concurrent program Who column
PROGRAM_ID NUMBER

Concurrent program Who column
PROGRAM_UPDATE_DATE DATE

Concurrent program Who column
PROJECT_BURDENED_COST NUMBER

The burdened cost in project currency of the forecast item
PROJECT_CURRENCY_CODE VARCHAR2 (15)
The project currency code of the forecast item
PROJECT_ID NUMBER

Identifier of the project
PROJECT_ORGANIZATION_ID NUMBER

Identifier of the project organization.
PROJECT_ORG_ID NUMBER

Identifier of the project operating unit.
PROJECT_RAW_COST NUMBER

The raw cost in project currency of the forecast item
PROJECT_REVENUE NUMBER

The revenue in project currency of the forecast item
PROJECT_TRANSFER_PRICE NUMBER

The transfer price in project currency of the forecast item
PROJECT_TYPE_CLASS VARCHAR2 (30)
The project type classification of the project assignment
PROJFUNC_BURDENED_COST NUMBER

The burdened cost in project functional currency of the forecast item
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
The project functional currency code of the forecast item
PROJFUNC_RAW_COST NUMBER

The raw cost in project functional currency of the forecast item
PROJFUNC_REVENUE NUMBER

The revenue in project functional currency of the forecast item
PROJFUNC_TRANSFER_PRICE NUMBER

The transfer price in project functional currency of the forecast item
PROVISIONAL_FLAG VARCHAR2 (1)
Indicates whether the assignment is Provisional
PROVISIONAL_QTY NUMBER (30)
The total number of hours the resource is provisionally assigned on the date of the item (item_date). This column is NULL for records with a forecast item type of 'A' or 'R' and for records with a forecast item type of 'U' if the amount
PURGE_BATCH_ID NUMBER (15) Yes Purge batch Id
PURGE_PROJECT_ID NUMBER (15) Yes Purged project Id
PURGE_RELEASE VARCHAR2 (50) Yes Purge release version
PVDR_GL_PERIOD_NAME VARCHAR2 (30)
The item corresponding to the GL Period Name as per the calendar in the provider ledger.
PVDR_PA_PERIOD_NAME VARCHAR2 (30)
The item corresponding to the PA Period Name as per the calendar in the provider ledger.
PVDR_PERIOD_SET_NAME VARCHAR2 (30)
The accounting calendar name corresponding to the provider ledger.
RCVR_GL_PERIOD_NAME VARCHAR2 (30)
The item corresponding to the GL Period Name as per the calendar in the receiver ledger.
RCVR_PA_PERIOD_NAME VARCHAR2 (30)
The item corresponding to the PA Period Name as per the calendar in the provider ledger.
RCVR_PERIOD_SET_NAME VARCHAR2 (30)
The period set corresponding to the receiver ledger.
REQUEST_ID NUMBER

Concurrent program Who column
RESOURCE_ID NUMBER

Resource ID
REVENUE_TXN_CURRENCY_CODE VARCHAR2 (15)
The revenue currency code of the transaction
REV_REJECTION_CODE VARCHAR2 (30)
The rejection code of error during the revenue amount calculation
TP_AMOUNT_TYPE VARCHAR2 (30)
Stores the transfer price amount type
TP_REJECTION_CODE VARCHAR2 (30)
The rejection code of error during the transfer price amount calculation
TP_TXN_CURRENCY_CODE VARCHAR2 (15)
Stores the transfer price currency code for the transaction
TXN_BURDENED_COST NUMBER

The burdened cost in transaction currency of the forecast item
TXN_RAW_COST NUMBER

The raw cost in transaction currency of the forecast item
TXN_REVENUE NUMBER

The revenue in transaction currency of the forecast item
TXN_TRANSFER_PRICE NUMBER

The transfer price in transaction currency of the forecast item
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 does not reference any database object

PA.PA_FRCST_ITEMS_AR is referenced by following:

SchemaAPPS
SynonymPA_FRCST_ITEMS_AR