eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PA.PA_EVENTS

Object Details

Object Name:	PA_EVENTS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_EVENTS
Subobject Name:
Status:	VALID

PA_EVENTS stores events assigned to a task that
generate revenue and/or billing activities that are
not directly associated to the cost and revenue
generated by expenditure items.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_EVENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID EVENT_NUM TASK_ID
PA_EVENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_ID
PA_EVENTS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	PM_PRODUCT_CODE PM_EVENT_REFERENCE
PA_EVENTS_U4	NORMAL	UNIQUE	APPS_TS_TX_IDX	DELIVERABLE_ID ACTION_ID
PA_EVENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVENUE_DISTRIBUTED_FLAG PROJECT_ID COMPLETION_DATE TASK_ID
PA_EVENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_TYPE
PA_EVENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID REVENUE_DISTRIBUTED_FLAG
PA_EVENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILLING_ASSIGNMENT_ID
PA_EVENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID BILL_HOLD_FLAG
PA_EVENTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID BILLED_FLAG
PA_EVENTS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID BILLED_FLAG COMPLETION_DATE
PA_EVENTS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID BILL_HOLD_FLAG BILLED_FLAG AGREEMENT_ID
PA_EVENTS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID BILLED_FLAG BILL_HOLD_FLAG AGREEMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_ID	NUMBER	(15)		The identifier of the top level task to which the event is assigned
EVENT_NUM	NUMBER	(15)	Yes	The sequential number that identifies the event.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
EVENT_TYPE	VARCHAR2	(30)	Yes	The event type that classifies the event
DESCRIPTION	VARCHAR2	(240)	Yes	The free text description of the event. For billing events, the description is displayed as the invoice line description.
BILL_AMOUNT	NUMBER	(22)	Yes	The amount to be billed for the event on an invoice upon the event's completion date
REVENUE_AMOUNT	NUMBER	(22)	Yes	The amount of revenue to accrue for the event upon the event's completion date
REVENUE_DISTRIBUTED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the event's revenue has been distributed. (An event is either distributed or not. It cannot be partially accrued.)
BILL_HOLD_FLAG	VARCHAR2	(1)		Flag that indicates that the event is held from invoicing
COMPLETION_DATE	DATE			The date on which the event is complete and on or after which the event is processed for revenue accrual and/or invoicing
REV_DIST_REJECTION_CODE	VARCHAR2	(30)		The reason why the event was rejected during revenue distribution
REQUEST_ID	NUMBER	(15)		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column
PROGRAM_ID	NUMBER	(15)		Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which event is assigned.
ORGANIZATION_ID	NUMBER	(15)	Yes	The unique identifier of the organization for the event. For example, this may be used to credit revenue to different organization.
BILLING_ASSIGNMENT_ID	NUMBER	(15)		The unique identifier of billing extention assignment that is basis for creating the automatic event.
EVENT_NUM_REVERSED	NUMBER	(15)		The event_num of the event that this automatic event is reversing when the invoice that the original event was on gets cancelled.
CALLING_PLACE	VARCHAR2	(30)		The place in the program that called the Billing Extension which created this event
CALLING_PROCESS	VARCHAR2	(30)		The process that called the Billing Extension that created this event
AUDIT_COST_BUDGET_TYPE_CODE	VARCHAR2	(30)		Audit Cost budget type used for calculation of cost budget amounts
AUDIT_REV_BUDGET_TYPE_CODE	VARCHAR2	(30)		Audit revenue budget type used for calculation of revenue budget amounts
AUDIT_AMOUNT1	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT2	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT3	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT4	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT5	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT6	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT7	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT8	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT9	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
AUDIT_AMOUNT10	NUMBER			Audit amount column to know the audit amounts for events with automatic event type classification
EVENT_ID	NUMBER		Yes	Primary key for table.
INVENTORY_ORG_ID	NUMBER	(15)		inventory orgnization ID
INVENTORY_ITEM_ID	NUMBER	(15)		inventory item ID
QUANTITY_BILLED	NUMBER			Bill Quantity
UOM_CODE	VARCHAR2	(3)		Unit of Measure
UNIT_PRICE	NUMBER			Contract price
REFERENCE1	VARCHAR2	(240)		Generic Reference Column
REFERENCE2	VARCHAR2	(240)		Generic Reference Column
REFERENCE3	VARCHAR2	(240)		Generic Reference Column
REFERENCE4	VARCHAR2	(240)		Generic Reference Column
REFERENCE5	VARCHAR2	(240)		Generic Reference Column
REFERENCE6	VARCHAR2	(240)		Generic Reference Column
REFERENCE7	VARCHAR2	(240)		Generic Reference Column
REFERENCE8	VARCHAR2	(240)		Generic Reference Column
REFERENCE9	VARCHAR2	(240)		Generic Reference Column
REFERENCE10	VARCHAR2	(240)		Generic Reference Column
BILLED_FLAG	VARCHAR2	(1)		Indicates if a particular event has been billed completely (Y) or not (N).
BILL_TRANS_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code of the event.
BILL_TRANS_BILL_AMOUNT	NUMBER			Bill amount in the event transaction.
BILL_TRANS_REV_AMOUNT	NUMBER			Revenue Amount in the Event Transaction.
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		Project currency code.
PROJECT_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency to project currency
PROJECT_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency to project currency if Fixed Date rate date type is used for customer billing.
PROJECT_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency to project currency if User exchange rate type is used.
PROJECT_REV_RATE_DATE	DATE			Rate date used during revenue generation
PROJECT_REV_EXCHANGE_RATE	NUMBER			Exchange rate used during revenue generation.
PROJECT_REVENUE_AMOUNT	NUMBER			Revenue Amount in Project Currency. This is calculated by applying the Project Currency setup conversion rules to the bill transaction base revenue amount during revenue generation.
PROJECT_INV_RATE_DATE	DATE			Rate date used during invoice generation.
PROJECT_INV_EXCHANGE_RATE	NUMBER			Exchange rate used during invoice generation.
PROJECT_BILL_AMOUNT	NUMBER			Bill amount in Project Currency. This is calculated by applying the Project Currency setup conversion rules to the bill transaction base bill amount during invoice generation.
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		Project functional currency.
PROJFUNC_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency to project functional currency for customer billing.
PROJFUNC_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used for customer billing.
PROJFUNC_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency to project functional if User exchange rate type is used.
PROJFUNC_REV_RATE_DATE	DATE			Rate date used during revenue generation.
PROJFUNC_REV_EXCHANGE_RATE	NUMBER			Exchange rate used during revenue generation.
PROJFUNC_REVENUE_AMOUNT	NUMBER			Revenue amount in the project functional currency. This is calculated by applying the project functional currency setup conversion rules to the bill ransaction base revenue amount during revenue generation.
PROJFUNC_INV_RATE_DATE	DATE			Rate date used during invoice generation.
PROJFUNC_INV_EXCHANGE_RATE	NUMBER			Exchange rate used during invoice generation.
PROJFUNC_BILL_AMOUNT	NUMBER			Bill amount in the project functional currency. This is calculated by applying the Project functional currency setup conversion rules to the bill transaction base bill amount during invoice generation.
FUNDING_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency to funding currency for customer billing.
FUNDING_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency to funding currency if Fixed Date rate date type is used for customer billing.
FUNDING_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency to project or functional currency
REVPROC_CURRENCY_CODE	VARCHAR2	(15)		Revenue Processing Currency.
REVPROC_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency to revenue processing currency for customer billing.Currently, the revenue processing currency is the project functional currency.
REVPROC_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency to revenue processing currency if Fixed Date rate date type is used for customer billing.
REVPROC_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency to the revenue processing currency .
INVPROC_CURRENCY_CODE	VARCHAR2	(15)		Invoice Processing Currency.
INVPROC_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency to the invoice processing currency for customer billing.
INVPROC_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency to invoice processing currency if Fixed Date rate date type is used for customer billing.
INVPROC_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency to the invoice processing currency.
INV_GEN_REJECTION_CODE	VARCHAR2	(30)		Invoice generation rejection code.
ADJUSTING_REVENUE_FLAG	VARCHAR2	(1)		Indicate that the event is an adjusting revenue event
ZERO_REVENUE_AMOUNT_FLAG	VARCHAR2	(1)		The identifier of the zero revenue amount.
NON_UPDATEABLE_FLAG	VARCHAR2	(1)		This column indicates whether event is updateable or not.Valid values Y or N.
PROJECT_FUNDING_ID	NUMBER	(15)		The identifier of the project funding
REVENUE_HOLD_FLAG	VARCHAR2	(1)		This column indicates whether this event is on hold for revenue processing or not.Valid values Y or N.
AUDIT_COST_PLAN_TYPE_ID	NUMBER	(15)		Audit cost Fin Plan id used for calculation of cost Fin plan amounts
AUDIT_REV_PLAN_TYPE_ID	NUMBER	(15)		Audit revenue fin plan id used for calculation of revenue Fin Plan amounts
PM_PRODUCT_CODE	VARCHAR2	(30)		Unique identifier of the external system
PM_EVENT_REFERENCE	VARCHAR2	(25)		Unique identifier of an event in external system
DELIVERABLE_ID	NUMBER	(15)		Unique identifier of deliverable
ACTION_ID	NUMBER	(15)		Unique Identifier of the the action
RECORD_VERSION_NUMBER	NUMBER	(15)		Record version number of the deliverable
AGREEMENT_ID	VARCHAR2	(15)		The identifier of the project customers agreement for which event has to be billed.

Query Text

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


SELECT TASK_ID
,      EVENT_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      EVENT_TYPE
,      DESCRIPTION
,      BILL_AMOUNT
,      REVENUE_AMOUNT
,      REVENUE_DISTRIBUTED_FLAG
,      BILL_HOLD_FLAG
,      COMPLETION_DATE
,      REV_DIST_REJECTION_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      PROJECT_ID
,      ORGANIZATION_ID
,      BILLING_ASSIGNMENT_ID
,      EVENT_NUM_REVERSED
,      CALLING_PLACE
,      CALLING_PROCESS
,      AUDIT_COST_BUDGET_TYPE_CODE
,      AUDIT_REV_BUDGET_TYPE_CODE
,      AUDIT_AMOUNT1
,      AUDIT_AMOUNT2
,      AUDIT_AMOUNT3
,      AUDIT_AMOUNT4
,      AUDIT_AMOUNT5
,      AUDIT_AMOUNT6
,      AUDIT_AMOUNT7
,      AUDIT_AMOUNT8
,      AUDIT_AMOUNT9
,      AUDIT_AMOUNT10
,      EVENT_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;

Dependencies

[top of page]

PA.PA_EVENTS does not reference any database object

PA.PA_EVENTS is referenced by following:

PA: PA_EVENTS#