Skip to content

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

VIEW: PA.PA_EVENTS_AR#

Object Details
Object Name: PA_EVENTS_AR#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PURGE_BATCH_ID NUMBER (15) Yes
PURGE_PROJECT_ID NUMBER (15) Yes
PURGE_RELEASE VARCHAR2 (50) Yes
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 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)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
AUDIT_AMOUNT1 NUMBER

AUDIT_AMOUNT10 NUMBER

AUDIT_AMOUNT2 NUMBER

AUDIT_AMOUNT3 NUMBER

AUDIT_AMOUNT4 NUMBER

AUDIT_AMOUNT5 NUMBER

AUDIT_AMOUNT6 NUMBER

AUDIT_AMOUNT7 NUMBER

AUDIT_AMOUNT8 NUMBER

AUDIT_AMOUNT9 NUMBER

AUDIT_COST_BUDGET_TYPE_CODE VARCHAR2 (30)
AUDIT_REV_BUDGET_TYPE_CODE VARCHAR2 (30)
BILL_AMOUNT NUMBER (22)
BILL_HOLD_FLAG VARCHAR2 (1)
BILLING_ASSIGNMENT_ID NUMBER (15)
CALLING_PLACE VARCHAR2 (30)
CALLING_PROCESS VARCHAR2 (30)
COMPLETION_DATE DATE

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
DESCRIPTION VARCHAR2 (240)
EVENT_ID NUMBER (15)
EVENT_NUM NUMBER (15)
EVENT_NUM_REVERSED NUMBER (15)
EVENT_TYPE VARCHAR2 (30)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
ORGANIZATION_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

PROJECT_ID NUMBER (15)
REQUEST_ID NUMBER (15)
REV_DIST_REJECTION_CODE VARCHAR2 (30)
REVENUE_AMOUNT NUMBER (22)
REVENUE_DISTRIBUTED_FLAG VARCHAR2 (1)
TASK_ID NUMBER (15)
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)
BILLED_FLAG VARCHAR2 (1)
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_DATE DATE

PROJECT_EXCHANGE_RATE NUMBER

PROJECT_REV_RATE_DATE DATE

PROJECT_REV_EXCHANGE_RATE NUMBER

PROJECT_REVENUE_AMOUNT NUMBER

PROJECT_INV_RATE_DATE DATE

PROJECT_INV_EXCHANGE_RATE NUMBER

PROJECT_BILL_AMOUNT NUMBER

PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_RATE_TYPE VARCHAR2 (30)
PROJFUNC_RATE_DATE DATE

PROJFUNC_EXCHANGE_RATE NUMBER

PROJFUNC_REV_RATE_DATE DATE

PROJFUNC_REV_EXCHANGE_RATE NUMBER

PROJFUNC_REVENUE_AMOUNT NUMBER

PROJFUNC_INV_RATE_DATE DATE

PROJFUNC_INV_EXCHANGE_RATE NUMBER

PROJFUNC_BILL_AMOUNT NUMBER

FUNDING_RATE_TYPE VARCHAR2 (30)
FUNDING_RATE_DATE DATE

FUNDING_EXCHANGE_RATE NUMBER

REVPROC_CURRENCY_CODE VARCHAR2 (15)
REVPROC_RATE_TYPE VARCHAR2 (30)
REVPROC_RATE_DATE VARCHAR2 (240)
REVPROC_EXCHANGE_RATE NUMBER

INVPROC_CURRENCY_CODE VARCHAR2 (15)
INVPROC_RATE_TYPE VARCHAR2 (30)
INVPROC_RATE_DATE VARCHAR2 (240)
INVPROC_EXCHANGE_RATE NUMBER

INV_GEN_REJECTION_CODE VARCHAR2 (30)
ADJUSTING_REVENUE_FLAG VARCHAR2 (1)
ZERO_REVENUE_AMOUNT_FLAG VARCHAR2 (1)
NON_UPDATEABLE_FLAG VARCHAR2 (1)
PROJECT_FUNDING_ID NUMBER (15)
REVENUE_HOLD_FLAG VARCHAR2 (1)
AUDIT_COST_PLAN_TYPE_ID NUMBER (15)
AUDIT_REV_PLAN_TYPE_ID NUMBER (15)
PM_PRODUCT_CODE VARCHAR2 (30)
PM_EVENT_REFERENCE VARCHAR2 (25)
DELIVERABLE_ID NUMBER (15)
ACTION_ID NUMBER (15)
RECORD_VERSION_NUMBER NUMBER (15)
AGREEMENT_ID VARCHAR2 (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PURGE_BATCH_ID
,      PURGE_PROJECT_ID
,      PURGE_RELEASE
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      AUDIT_AMOUNT1
,      AUDIT_AMOUNT10
,      AUDIT_AMOUNT2
,      AUDIT_AMOUNT3
,      AUDIT_AMOUNT4
,      AUDIT_AMOUNT5
,      AUDIT_AMOUNT6
,      AUDIT_AMOUNT7
,      AUDIT_AMOUNT8
,      AUDIT_AMOUNT9
,      AUDIT_COST_BUDGET_TYPE_CODE
,      AUDIT_REV_BUDGET_TYPE_CODE
,      BILL_AMOUNT
,      BILL_HOLD_FLAG
,      BILLING_ASSIGNMENT_ID
,      CALLING_PLACE
,      CALLING_PROCESS
,      COMPLETION_DATE
,      CREATED_BY
,      CREATION_DATE
,      DESCRIPTION
,      EVENT_ID
,      EVENT_NUM
,      EVENT_NUM_REVERSED
,      EVENT_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      ORGANIZATION_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      REQUEST_ID
,      REV_DIST_REJECTION_CODE
,      REVENUE_AMOUNT
,      REVENUE_DISTRIBUTED_FLAG
,      TASK_ID
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      QUANTITY_BILLED
,      UOM_CODE
,      UNIT_PRICE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      BILLED_FLAG
,      BILL_TRANS_CURRENCY_CODE
,      BILL_TRANS_BILL_AMOUNT
,      BILL_TRANS_REV_AMOUNT
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE
,      PROJECT_EXCHANGE_RATE
,      PROJECT_REV_RATE_DATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJECT_REVENUE_AMOUNT
,      PROJECT_INV_RATE_DATE
,      PROJECT_INV_EXCHANGE_RATE
,      PROJECT_BILL_AMOUNT
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_RATE_DATE
,      PROJFUNC_EXCHANGE_RATE
,      PROJFUNC_REV_RATE_DATE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_REVENUE_AMOUNT
,      PROJFUNC_INV_RATE_DATE
,      PROJFUNC_INV_EXCHANGE_RATE
,      PROJFUNC_BILL_AMOUNT
,      FUNDING_RATE_TYPE
,      FUNDING_RATE_DATE
,      FUNDING_EXCHANGE_RATE
,      REVPROC_CURRENCY_CODE
,      REVPROC_RATE_TYPE
,      REVPROC_RATE_DATE
,      REVPROC_EXCHANGE_RATE
,      INVPROC_CURRENCY_CODE
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_EXCHANGE_RATE
,      INV_GEN_REJECTION_CODE
,      ADJUSTING_REVENUE_FLAG
,      ZERO_REVENUE_AMOUNT_FLAG
,      NON_UPDATEABLE_FLAG
,      PROJECT_FUNDING_ID
,      REVENUE_HOLD_FLAG
,      AUDIT_COST_PLAN_TYPE_ID
,      AUDIT_REV_PLAN_TYPE_ID
,      PM_PRODUCT_CODE
,      PM_EVENT_REFERENCE
,      DELIVERABLE_ID
,      ACTION_ID
,      RECORD_VERSION_NUMBER
,      AGREEMENT_ID
FROM PA.PA_EVENTS_AR#;

Dependencies

[top of page]

PA.PA_EVENTS_AR# references the following:

SchemaPA
TablePA_EVENTS_AR
PA.PA_EVENTS_AR# is referenced by following:

SchemaAPPS
SynonymPA_EVENTS_AR