[Home] [Help]
[Dependency Information]
Object Name: | PA_EVENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
EVENT_ID | NUMBER | |||
PROJECT_ID | NUMBER | (15) | ||
PROJECT_NUMBER | VARCHAR2 | (25) | ||
PROJECT_NAME | VARCHAR2 | (30) | ||
TASK_ID | NUMBER | (15) | ||
TASK_NUMBER | VARCHAR2 | (25) | ||
TASK_NAME | VARCHAR2 | (20) | ||
AGREEMENT_ID | VARCHAR2 | (15) | ||
FEDERAL_FLAG | VARCHAR2 | (1) | ||
EVENT_NUM | NUMBER | (15) | ||
EVENT_TYPE | VARCHAR2 | (30) | ||
EVENT_TYPE_CLASSIFICATION | VARCHAR2 | (30) | ||
EVENT_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (240) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
BILL_AMOUNT | NUMBER | (22) | ||
REVENUE_AMOUNT | NUMBER | (22) | ||
BILL_HOLD_FLAG | VARCHAR2 | (1) | ||
REVENUE_DISTRIBUTED_FLAG | VARCHAR2 | (1) | ||
PROJECT_LEVEL_FUNDING_FLAG | VARCHAR2 | (1) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
INVENTORY_ORG_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
QUANTITY_BILLED | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
UNIT_PRICE | NUMBER | |||
REFERENCE1 | VARCHAR2 | (240) | ||
REFERENCE2 | VARCHAR2 | (240) | ||
REFERENCE3 | VARCHAR2 | (240) | ||
REFERENCE4 | VARCHAR2 | (240) | ||
REFERENCE5 | VARCHAR2 | (240) | ||
REFERENCE6 | VARCHAR2 | (240) | ||
REFERENCE7 | VARCHAR2 | (240) | ||
REFERENCE8 | VARCHAR2 | (240) | ||
REFERENCE9 | VARCHAR2 | (240) | ||
REFERENCE10 | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
BILL_TRANS_CURRENCY_CODE | VARCHAR2 | (15) | ||
BILL_TRANS_BILL_AMOUNT | NUMBER | |||
BILL_TRANS_REV_AMOUNT | NUMBER | |||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_RATE_TYPE_NAME | VARCHAR2 | (30) | ||
PROJECT_RATE_DATE | DATE | |||
PROJECT_EXCHANGE_RATE | NUMBER | |||
PROJECT_BILL_AMOUNT | NUMBER | |||
PROJECT_INV_EXCHANGE_RATE | NUMBER | |||
PROJECT_INV_RATE_DATE | DATE | |||
PROJECT_REVENUE_AMOUNT | NUMBER | |||
PROJECT_REV_EXCHANGE_RATE | NUMBER | |||
PROJECT_REV_RATE_DATE | DATE | |||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJFUNC_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_RATE_TYPE_NAME | VARCHAR2 | (30) | ||
PROJFUNC_RATE_DATE | DATE | |||
PROJFUNC_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_BILL_AMOUNT | NUMBER | |||
PROJFUNC_INV_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_INV_RATE_DATE | DATE | |||
PROJFUNC_REVENUE_AMOUNT | NUMBER | |||
PROJFUNC_REV_EXCHANGE_RATE | NUMBER | |||
PROJFUNC_REV_RATE_DATE | DATE | |||
FUNDING_RATE_TYPE | VARCHAR2 | (30) | ||
FUNDING_RATE_TYPE_NAME | VARCHAR2 | (30) | ||
FUNDING_RATE_DATE | DATE | |||
FUNDING_EXCHANGE_RATE | NUMBER | |||
INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
INVPROC_RATE_TYPE | VARCHAR2 | (30) | ||
INVPROC_RATE_DATE | DATE | |||
INVPROC_EXCHANGE_RATE | NUMBER | |||
REVPROC_CURRENCY_CODE | VARCHAR2 | (15) | ||
REVPROC_RATE_TYPE | VARCHAR2 | (30) | ||
REVPROC_RATE_DATE | DATE | |||
REVPROC_EXCHANGE_RATE | NUMBER | |||
INV_GEN_REJECTION_CODE | VARCHAR2 | (30) | ||
INV_GEN_REJECTION_REASON | VARCHAR2 | (80) | ||
REV_GEN_REJECTION_REASON | VARCHAR2 | (80) | ||
PROJ_LEVEL_CURR_COD | VARCHAR2 | (15) | ||
PROJ_LEVEL_RT_DT_COD | VARCHAR2 | (30) | ||
PROJ_LEVEL_RT_TYP | VARCHAR2 | (30) | ||
PROJ_LEVEL_RT_DT | DATE | |||
PROJ_LEVEL_EXCH_RT | NUMBER | |||
PROJ_LEVEL_FUNC_CURR_COD | VARCHAR2 | (15) | ||
PROJ_LEVEL_FUNC_RT_DT_COD | VARCHAR2 | (30) | ||
PROJ_LEVEL_FUNC_RT_TYP | VARCHAR2 | (30) | ||
PROJ_LEVEL_FUNC_RT_DT | DATE | |||
PROJ_LEVEL_FUNC_EXCH_RT | NUMBER | |||
PROJ_LEVEL_FUND_RT_DT_COD | VARCHAR2 | (30) | ||
PROJ_LEVEL_FUND_RT_TYP | VARCHAR2 | (30) | ||
PROJ_LEVEL_FUND_RT_DT | DATE | |||
PROJ_LEVEL_FUND_EXCH_RT | NUMBER | |||
PROJ_LEVEL_REVPRO_CURR_COD | VARCHAR2 | (15) | ||
PROJ_LEVEL_INVPRO_CURR_TYP | VARCHAR2 | (30) | ||
MULTI_CURRENCY_BILLING_FLAG | VARCHAR2 | (1) | ||
ADJUSTING_REVENUE_FLAG | VARCHAR2 | (1) | ||
ZERO_REVENUE_AMOUNT_FLAG | VARCHAR2 | (1) | ||
NON_UPDATEABLE_FLAG | VARCHAR2 | (1) | ||
AUDIT_COST_PLAN_TYPE_ID | NUMBER | (15) | ||
AUDIT_REV_PLAN_TYPE_ID | NUMBER | (15) | ||
REVENUE_HOLD_FLAG | VARCHAR2 | (1) | ||
BILLED_FLAG | VARCHAR2 | (1) | ||
PM_PRODUCT_CODE | VARCHAR2 | (30) | ||
PM_EVENT_REFERENCE | VARCHAR2 | (25) | ||
PM_PRODUCT_CODE_DISP | VARCHAR2 | (80) | ||
DELIVERABLE_ID | NUMBER | (15) | ||
ACTION_ID | NUMBER | (15) | ||
RECORD_VERSION_NUMBER | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, EVENT_ID
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, AGREEMENT_ID
, FEDERAL_FLAG
, EVENT_NUM
, EVENT_TYPE
, EVENT_TYPE_CLASSIFICATION
, EVENT_DATE
, DESCRIPTION
, ORGANIZATION_ID
, ORGANIZATION_NAME
, BILL_AMOUNT
, REVENUE_AMOUNT
, BILL_HOLD_FLAG
, REVENUE_DISTRIBUTED_FLAG
, PROJECT_LEVEL_FUNDING_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, INVENTORY_ORG_ID
, INVENTORY_ITEM_ID
, QUANTITY_BILLED
, UOM_CODE
, UNIT_PRICE
, REFERENCE1
, REFERENCE2
, REFERENCE3
, REFERENCE4
, REFERENCE5
, REFERENCE6
, REFERENCE7
, REFERENCE8
, REFERENCE9
, REFERENCE10
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, BILL_TRANS_CURRENCY_CODE
, BILL_TRANS_BILL_AMOUNT
, BILL_TRANS_REV_AMOUNT
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE
, PROJECT_RATE_TYPE_NAME
, PROJECT_RATE_DATE
, PROJECT_EXCHANGE_RATE
, PROJECT_BILL_AMOUNT
, PROJECT_INV_EXCHANGE_RATE
, PROJECT_INV_RATE_DATE
, PROJECT_REVENUE_AMOUNT
, PROJECT_REV_EXCHANGE_RATE
, PROJECT_REV_RATE_DATE
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_TYPE_NAME
, PROJFUNC_RATE_DATE
, PROJFUNC_EXCHANGE_RATE
, PROJFUNC_BILL_AMOUNT
, PROJFUNC_INV_EXCHANGE_RATE
, PROJFUNC_INV_RATE_DATE
, PROJFUNC_REVENUE_AMOUNT
, PROJFUNC_REV_EXCHANGE_RATE
, PROJFUNC_REV_RATE_DATE
, FUNDING_RATE_TYPE
, FUNDING_RATE_TYPE_NAME
, FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE
, INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE
, INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE
, REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE
, REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE
, INV_GEN_REJECTION_CODE
, INV_GEN_REJECTION_REASON
, REV_GEN_REJECTION_REASON
, PROJ_LEVEL_CURR_COD
, PROJ_LEVEL_RT_DT_COD
, PROJ_LEVEL_RT_TYP
, PROJ_LEVEL_RT_DT
, PROJ_LEVEL_EXCH_RT
, PROJ_LEVEL_FUNC_CURR_COD
, PROJ_LEVEL_FUNC_RT_DT_COD
, PROJ_LEVEL_FUNC_RT_TYP
, PROJ_LEVEL_FUNC_RT_DT
, PROJ_LEVEL_FUNC_EXCH_RT
, PROJ_LEVEL_FUND_RT_DT_COD
, PROJ_LEVEL_FUND_RT_TYP
, PROJ_LEVEL_FUND_RT_DT
, PROJ_LEVEL_FUND_EXCH_RT
, PROJ_LEVEL_REVPRO_CURR_COD
, PROJ_LEVEL_INVPRO_CURR_TYP
, MULTI_CURRENCY_BILLING_FLAG
, ADJUSTING_REVENUE_FLAG
, ZERO_REVENUE_AMOUNT_FLAG
, NON_UPDATEABLE_FLAG
, AUDIT_COST_PLAN_TYPE_ID
, AUDIT_REV_PLAN_TYPE_ID
, REVENUE_HOLD_FLAG
, BILLED_FLAG
, PM_PRODUCT_CODE
, PM_EVENT_REFERENCE
, PM_PRODUCT_CODE_DISP
, DELIVERABLE_ID
, ACTION_ID
, RECORD_VERSION_NUMBER
FROM APPS.PA_EVENTS_V;
APPS.PA_EVENTS_V is not referenced by any database object
|
|
|