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

TABLE: PJI.PJI_AC_AGGR_PJP0

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

This table is mirror of PJI_AC_XBS_ACCUM_FROM used during summarization.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15) Yes Partitioning column.
PROJECT_ID NUMBER (15) Yes Identifier for the project
PROJECT_ORG_ID NUMBER (15) Yes Identifier for 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.
PRG_ROLLUP_FLAG VARCHAR2 (1) Yes Indicates whether the amounts are rolled up by Project Hierarchy or not.
CURR_RECORD_TYPE_ID NUMBER (15) Yes Identifier for the Currency record type
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

AR Credit Memo Count
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
Query Text

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


SELECT WORKER_ID
,      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
FROM PJI.PJI_AC_AGGR_PJP0;

Dependencies

[top of page]

PJI.PJI_AC_AGGR_PJP0 does not reference any database object

PJI.PJI_AC_AGGR_PJP0 is referenced by following:

SchemaAPPS
SynonymPJI_AC_AGGR_PJP0