[Home] [Help]
[Dependency Information]
| Object Name: | PA_EVENTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PA.PA_EVENTS_V
|
| 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
HR_ALL_ORGANIZATION_UNITS_TL
PA_CONVERSION_TYPES_V
PA_EVENTS
PA_EVENT_TYPES
PA_LOOKUPS
PA_PROJECTS
PA_SECURITY
- show dependent code
PA_TASKS
SYS
DUAL
APPS.PA_EVENTS_V is not referenced by any database object
|
|
|
|