Skip to content

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 Comments
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:

SchemaPA
TablePA_FRCST_ITEMS_AR
PA.PA_FRCST_ITEMS_AR# is referenced by following:

SchemaAPPS
SynonymPA_FRCST_ITEMS_AR