[Home] [Help] [Dependency Information]
Object Name: | PA_FRCST_ITEMS_AR# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|