DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PA_EVENTS_V

Object Details
Object Name: PA_EVENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_EVENTS_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
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)
Query Text

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;

Dependencies

[top of page]

APPS.PA_EVENTS_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewPA_CONVERSION_TYPES_V
SynonymPA_EVENTS
SynonymPA_EVENT_TYPES
ViewPA_LOOKUPS
SynonymPA_PROJECTS
PL/SQL PackagePA_SECURITY - show dependent code
SynonymPA_TASKS
SchemaSYS
TableDUAL

APPS.PA_EVENTS_V is not referenced by any database object