[Home] [Help] [Dependency Information]
Object Name: | PA_FRCST_ITEM_DTLS_AR# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMOUNT_TYPE_ID | NUMBER | |||
BILLABLE_FLAG | VARCHAR2 | (1) | ||
CAPACITY_QUANTITY | NUMBER | |||
CONFIRMED_QTY | NUMBER | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
DENOM_AMOUNT | NUMBER | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
EXPENDITURE_ORGANIZATION_ID | NUMBER | |||
EXPENDITURE_ORG_ID | NUMBER | |||
FORECAST_ITEM_ID | NUMBER | |||
FORECAST_SUMMARIZED_CODE | VARCHAR2 | (30) | ||
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) | ||
LINE_NUM | NUMBER | |||
LINE_NUM_REVERSED | NUMBER | |||
NET_ZERO_FLAG | VARCHAR2 | (1) | ||
ORG_UTIL_CATEGORY_ID | NUMBER | |||
ORG_UTIL_WEIGHTED | NUMBER | |||
OVERCOMMITMENT_QTY | NUMBER | |||
OVERPROVISIONAL_QTY | NUMBER | |||
OVER_PROV_CONF_QTY | NUMBER | |||
PERSON_BILLABLE_FLAG | VARCHAR2 | (1) | ||
PJI_SUMMARIZED_FLAG | VARCHAR2 | (1) | ||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
PROJECT_ID | NUMBER | |||
PROJECT_ORG_ID | NUMBER | |||
PROJ_AMOUNT | NUMBER | |||
PROJ_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROVISIONAL_FLAG | VARCHAR2 | (1) | ||
PROVISIONAL_QTY | NUMBER | |||
PURGE_BATCH_ID | NUMBER | (15) | Yes | |
PURGE_PROJECT_ID | NUMBER | (15) | Yes | |
PURGE_RELEASE | VARCHAR2 | (50) | Yes | |
PVDR_ACCT_AMOUNT | NUMBER | |||
PVDR_ACCT_CURR_CODE | VARCHAR2 | (15) | ||
RCVR_ACCT_AMOUNT | NUMBER | |||
RCVR_ACCT_CURR_CODE | VARCHAR2 | (15) | ||
REDUCE_CAPACITY_FLAG | VARCHAR2 | (1) | ||
REQUEST_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
RESOURCE_TYPE_CODE | VARCHAR2 | (30) | ||
RESOURCE_UTIL_CATEGORY_ID | NUMBER | |||
RESOURCE_UTIL_WEIGHTED | NUMBER | |||
REVERSED_FLAG | VARCHAR2 | (1) | ||
TP_AMOUNT_TYPE | VARCHAR2 | (30) | ||
UTIL_SUMMARIZED_CODE | VARCHAR2 | (30) | ||
WORK_TYPE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT AMOUNT_TYPE_ID
, BILLABLE_FLAG
, CAPACITY_QUANTITY
, CONFIRMED_QTY
, CREATED_BY
, CREATION_DATE
, DENOM_AMOUNT
, DENOM_CURRENCY_CODE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORG_ID
, FORECAST_ITEM_ID
, FORECAST_SUMMARIZED_CODE
, ITEM_DATE
, ITEM_QUANTITY
, ITEM_UOM
, JOB_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_NUM
, LINE_NUM_REVERSED
, NET_ZERO_FLAG
, ORG_UTIL_CATEGORY_ID
, ORG_UTIL_WEIGHTED
, OVERCOMMITMENT_QTY
, OVERPROVISIONAL_QTY
, OVER_PROV_CONF_QTY
, PERSON_BILLABLE_FLAG
, PJI_SUMMARIZED_FLAG
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, PROJECT_ORG_ID
, PROJ_AMOUNT
, PROJ_CURRENCY_CODE
, PROVISIONAL_FLAG
, PROVISIONAL_QTY
, PURGE_BATCH_ID
, PURGE_PROJECT_ID
, PURGE_RELEASE
, PVDR_ACCT_AMOUNT
, PVDR_ACCT_CURR_CODE
, RCVR_ACCT_AMOUNT
, RCVR_ACCT_CURR_CODE
, REDUCE_CAPACITY_FLAG
, REQUEST_ID
, RESOURCE_ID
, RESOURCE_TYPE_CODE
, RESOURCE_UTIL_CATEGORY_ID
, RESOURCE_UTIL_WEIGHTED
, REVERSED_FLAG
, TP_AMOUNT_TYPE
, UTIL_SUMMARIZED_CODE
, WORK_TYPE_ID
FROM PA.PA_FRCST_ITEM_DTLS_AR#;
|
|
|