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

TABLE: PJI.PJI_AC_XBS_ACCUM_F

Object Details
Object Name: PJI_AC_XBS_ACCUM_F
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_AC_XBS_ACCUM_F
Subobject Name:
Status: VALID


This table stores summarized booking and backlog activity measures for project performance by work breakdown and program hierarchies. It also stores data by for different calendars and currencies


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_AC_XBS_ACCUM_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPROJECT_ELEMENT_ID
ColumnTIME_ID
ColumnCURRENCY_CODE
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Identifier for the project
PROJECT_ORG_ID NUMBER (15) Yes Identifier of the Project Operating Unit
PROJECT_ORGANIZATION_ID NUMBER (15) Yes Identifier of the Project Organization
PROJECT_ELEMENT_ID NUMBER (15) Yes This is the WBS element id and consists of projects and tasks.
TIME_ID NUMBER (15) Yes Numeric identifier for time
PERIOD_TYPE_ID NUMBER (15) Yes Numeric identifier for the period type (period, quarter, year, weeks)
CALENDAR_TYPE VARCHAR2 (1) Yes Specifies the calendar type (PA, GL, Enterprise)
WBS_ROLLUP_FLAG VARCHAR2 (1) Yes Indicates, for the given project structure version, whether the amounts are rolled up by WBS or not. N = No (Task self amounts.) Y = Yes (Task amounts rolled up by WBS. Rolled up amounts do not include self amounts.)
PRG_ROLLUP_FLAG VARCHAR2 (1) Yes Indicates whether the amounts are rolled up by Project Hierarchy or not. N = No (Amounts within a given project.) Y = Yes (Project structure version amounts rolled up by Project Hierarchy. Rolled up amounts do not include self amounts.)
CURR_RECORD_TYPE_ID NUMBER (15) Yes Bitmask Identifier for the Currency record type. 1- Global Secondary, 2 - Global Primary, 4 - Project, 8 - Project Functional, 16 - Transaction
CURRENCY_CODE VARCHAR2 (30) Yes Currency Code
REVENUE NUMBER

Accrued Revenue
INITIAL_FUNDING_AMOUNT NUMBER

Initial Bookings Amount
INITIAL_FUNDING_COUNT NUMBER

Initial Bookings Count
ADDITIONAL_FUNDING_AMOUNT NUMBER

Additional Bookings Amount
ADDITIONAL_FUNDING_COUNT NUMBER

Additional Bookings Count
CANCELLED_FUNDING_AMOUNT NUMBER

Cancelled Bookings Amount
CANCELLED_FUNDING_COUNT NUMBER

Cancelled Bookings Count
FUNDING_ADJUSTMENT_AMOUNT NUMBER

Bookings Adjustments Amount
FUNDING_ADJUSTMENT_COUNT NUMBER

Bookings Adjustments Count
REVENUE_WRITEOFF NUMBER

Revenue Write-off
AR_INVOICE_AMOUNT NUMBER

AR Invoiced Amount
AR_INVOICE_COUNT NUMBER

AR Invoiced Count
AR_CASH_APPLIED_AMOUNT NUMBER

Cash Applied Amount
AR_INVOICE_WRITE_OFF_AMOUNT NUMBER

AR Invoice Write-off Amount
AR_INVOICE_WRITEOFF_COUNT NUMBER

AR Invoice Write-off Count
AR_CREDIT_MEMO_AMOUNT NUMBER

AR Credit Memo Amount
AR_CREDIT_MEMO_COUNT NUMBER

Billable Labor Hours
UNBILLED_RECEIVABLES NUMBER

Unbilled Receivables
UNEARNED_REVENUE NUMBER

Unearned Revenue
AR_UNAPPR_INVOICE_AMOUNT NUMBER

Unapproved AR Invoices Amount
AR_UNAPPR_INVOICE_COUNT NUMBER

Unapproved AR Invoices Count
AR_APPR_INVOICE_AMOUNT NUMBER

Approved AR Invoices Amount
AR_APPR_INVOICE_COUNT NUMBER

Approved AR Invoices Count
AR_AMOUNT_DUE NUMBER

AR Invoices Due Amount
AR_COUNT_DUE NUMBER

AR Invoices Due Count
AR_AMOUNT_OVERDUE NUMBER

AR Invoices Overdue Amount
AR_COUNT_OVERDUE NUMBER

AR Invoices Overdue Count
DORMANT_BACKLOG_INACTIV NUMBER

Dormant Backlog (No activity)
DORMANT_BACKLOG_START NUMBER

Dormant Backlog (Not started)
LOST_BACKLOG NUMBER

Lost Backlog (Project closed)
ACTIVE_BACKLOG NUMBER

Active Backlog
REVENUE_AT_RISK NUMBER

Revenue at Risk
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)
Standard Who Column
CUSTOM1 NUMBER

Custom measure1
CUSTOM2 NUMBER

Custom measure2
CUSTOM3 NUMBER

Custom measure3
CUSTOM4 NUMBER

Custom measure4
CUSTOM5 NUMBER

Custom measure5
CUSTOM6 NUMBER

Custom measure6
CUSTOM7 NUMBER

Custom measure7
CUSTOM8 NUMBER

Custom measure8
CUSTOM9 NUMBER

Custom measure9
CUSTOM10 NUMBER

Custom measure10
CUSTOM11 NUMBER

Custom measure11
CUSTOM12 NUMBER

Custom measure12
CUSTOM13 NUMBER

Custom measure13
CUSTOM14 NUMBER

Custom measure14
CUSTOM15 NUMBER

Custom measure15
Query Text

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


SELECT PROJECT_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ELEMENT_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      CALENDAR_TYPE
,      WBS_ROLLUP_FLAG
,      PRG_ROLLUP_FLAG
,      CURR_RECORD_TYPE_ID
,      CURRENCY_CODE
,      REVENUE
,      INITIAL_FUNDING_AMOUNT
,      INITIAL_FUNDING_COUNT
,      ADDITIONAL_FUNDING_AMOUNT
,      ADDITIONAL_FUNDING_COUNT
,      CANCELLED_FUNDING_AMOUNT
,      CANCELLED_FUNDING_COUNT
,      FUNDING_ADJUSTMENT_AMOUNT
,      FUNDING_ADJUSTMENT_COUNT
,      REVENUE_WRITEOFF
,      AR_INVOICE_AMOUNT
,      AR_INVOICE_COUNT
,      AR_CASH_APPLIED_AMOUNT
,      AR_INVOICE_WRITE_OFF_AMOUNT
,      AR_INVOICE_WRITEOFF_COUNT
,      AR_CREDIT_MEMO_AMOUNT
,      AR_CREDIT_MEMO_COUNT
,      UNBILLED_RECEIVABLES
,      UNEARNED_REVENUE
,      AR_UNAPPR_INVOICE_AMOUNT
,      AR_UNAPPR_INVOICE_COUNT
,      AR_APPR_INVOICE_AMOUNT
,      AR_APPR_INVOICE_COUNT
,      AR_AMOUNT_DUE
,      AR_COUNT_DUE
,      AR_AMOUNT_OVERDUE
,      AR_COUNT_OVERDUE
,      DORMANT_BACKLOG_INACTIV
,      DORMANT_BACKLOG_START
,      LOST_BACKLOG
,      ACTIVE_BACKLOG
,      REVENUE_AT_RISK
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOM1
,      CUSTOM2
,      CUSTOM3
,      CUSTOM4
,      CUSTOM5
,      CUSTOM6
,      CUSTOM7
,      CUSTOM8
,      CUSTOM9
,      CUSTOM10
,      CUSTOM11
,      CUSTOM12
,      CUSTOM13
,      CUSTOM14
,      CUSTOM15
FROM PJI.PJI_AC_XBS_ACCUM_F;

Dependencies

[top of page]

PJI.PJI_AC_XBS_ACCUM_F does not reference any database object

PJI.PJI_AC_XBS_ACCUM_F is referenced by following:

SchemaPJI
ViewPJI_AC_XBS_ACCUM_F#