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

TABLE: PA.PA_DRAFT_REVENUE_ITEMS

Object Details
Object Name: PA_DRAFT_REVENUE_ITEMS
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_DRAFT_REVENUE_ITEMS
Subobject Name:
Status: VALID


PA_DRAFT_REVENUE_ITEMS stores the lines of a draft revenue. The
Generate Draft Revenue process creates a line for each revenue event
and for each unique grouping of revenue distribution lines.
Each grouping of revenue distribution lines is grouped by top task and
revenue category.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_DRAFT_REVENUE_ITEMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnDRAFT_REVENUE_NUM
ColumnLINE_NUM
PA_DRAFT_REVENUE_ITEMS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTASK_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes The identifier of the project for which the revenue is generated
DRAFT_REVENUE_NUM NUMBER (15) Yes The draft revenue number to which the revenue line belongs
LINE_NUM NUMBER (15) Yes The sequential number that identifies and orders the draft revenue item for a draft revenue
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
TASK_ID NUMBER (15)
The identifier of the task of the revenue line. For a line that accrues event revenue, this is the event task_id. For a line that accrues expenditure item revenue, this is the top_task_id of the tasks to which the items are charged.
AMOUNT NUMBER (22) Yes The revenue amount accrued for the draft revenue item
REVENUE_SOURCE VARCHAR2 (30) Yes The source from which the revenue for the revenue line is generated
REVENUE_CATEGORY_CODE VARCHAR2 (30)
The revenue category of the expenditure items grouped into the revenue line
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
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
REVPROC_CURRENCY_CODE VARCHAR2 (15)
Revenue processing currency.
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
Project functional currency.
PROJFUNC_REVENUE_AMOUNT NUMBER

Revenue amount in the project functional currency. This is calculated by applying the conversion rules set up for project functional currency during invoice generation
PROJECT_CURRENCY_CODE VARCHAR2 (15)
Project currency code.
PROJECT_REVENUE_AMOUNT NUMBER

Revenue amount in the project currency. This is calculated by applying the conversion rules set up for project currency during revenue generation.
FUNDING_CURRENCY_CODE VARCHAR2 (15)
Funding currency code.
FUNDING_REVENUE_AMOUNT NUMBER

Revenue amount in the funding currency. This is calculated by applying the conversion rules set up for funding currency during revenue generation.
REVTRANS_AMOUNT NUMBER

Transaction Amount in Revenue Currency
REVTRANS_CURRENCY_CODE VARCHAR2 (15)
Revenue Transaction Currency Code
Query Text

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


SELECT PROJECT_ID
,      DRAFT_REVENUE_NUM
,      LINE_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      TASK_ID
,      AMOUNT
,      REVENUE_SOURCE
,      REVENUE_CATEGORY_CODE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REVPROC_CURRENCY_CODE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_REVENUE_AMOUNT
,      PROJECT_CURRENCY_CODE
,      PROJECT_REVENUE_AMOUNT
,      FUNDING_CURRENCY_CODE
,      FUNDING_REVENUE_AMOUNT
,      REVTRANS_AMOUNT
,      REVTRANS_CURRENCY_CODE
FROM PA.PA_DRAFT_REVENUE_ITEMS;

Dependencies

[top of page]

PA.PA_DRAFT_REVENUE_ITEMS does not reference any database object

PA.PA_DRAFT_REVENUE_ITEMS is referenced by following:

SchemaAPPS
SynonymPA_DRAFT_REVENUE_ITEMS