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: PJI.PJI_AC_PROJ_F

Object Details

Object Name:	PJI_AC_PROJ_F
Object Type:	TABLE
Owner:	PJI
FND Design Data:	PJI.PJI_AC_PROJ_F
Subobject Name:
Status:	VALID

This table stores summarized data for booking and backlog measures at the project level for Project Intelligence

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJI_AC_PROJ_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID CALENDAR_TYPE PROJECT_ORGANIZATION_ID
PJI_AC_PROJ_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PROJECT_ID TIME_ID CALENDAR_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ORG_ID	NUMBER	(15)	Yes	Projects operating unit identifier for multi-organization installations.
PROJECT_ORGANIZATION_ID	NUMBER	(15)	Yes	Identifier of the organization that is responsible for the project work.
TIME_ID	NUMBER	(15)	Yes	Identifier of the time.
PROJECT_ID	NUMBER	(15)	Yes	Number that uniquely identifies the project.
PERIOD_TYPE_ID	NUMBER	(15)	Yes	Period type
CALENDAR_TYPE	VARCHAR2	(30)	Yes	Calendar type
CURRENCY_TYPE	VARCHAR2	(30)
REVENUE	NUMBER			Revenue Amount
INITIAL_FUNDING_AMOUNT	NUMBER			Amount of funding allocated to the project or top task with funding category as ORIGINAL
INITIAL_FUNDING_COUNT	NUMBER			Number of funding lines allocated to the project or top task with funding category as ORIGINAL
ADDITIONAL_FUNDING_AMOUNT	NUMBER			Amount of funding allocated to the project or top task with funding category as Additional
ADDITIONAL_FUNDING_COUNT	NUMBER			Number of funding lines allocated to the project or top task with funding category as Additional
CANCELLED_FUNDING_AMOUNT	NUMBER			Amount of funding allocated to the project or top task with funding category as CANCELLATION
CANCELLED_FUNDING_COUNT	NUMBER			Number of funding lines allocated to the project or top task with funding category as CANCELLATION
FUNDING_ADJUSTMENT_AMOUNT	NUMBER			Amount of funding allocated to the project or top task with funding category as CORRECTION, TRANSFER or REVALUATION
FUNDING_ADJUSTMENT_COUNT	NUMBER			Number of funding lines allocated to the project or top task with funding category as CORRECTION, TRANSFER or REVALUATION
REVENUE_WRITEOFF	NUMBER			Revenue Write-off amount
AR_INVOICE_AMOUNT	NUMBER			Total Invoice Amount
AR_INVOICE_COUNT	NUMBER			Total Number of Project Invoices
AR_CASH_APPLIED_AMOUNT	NUMBER			Total Cash Applied for Project invoices
AR_INVOICE_WRITEOFF_AMOUNT	NUMBER			Total Project Invoice write-off amount
AR_INVOICE_WRITEOFF_COUNT	NUMBER			Number of write-off lines
AR_CREDIT_MEMO_AMOUNT	NUMBER			Total Credit Memo Invoices Generated
AR_CREDIT_MEMO_COUNT	NUMBER			Total Number of Credit Memo Lines
UNBILLED_RECEIVABLES	NUMBER			The unbilled receivables balance that is posted to Oracle General Ledger or Oracle Receivables
UNEARNED_REVENUE	NUMBER			The unearned revenue balance that is posted to Oracle General Ledger or Oracle Receivables
AR_UNAPPR_INVOICE_AMOUNT	NUMBER			Total Unapproved Invoice Amount
AR_UNAPPR_INVOICE_COUNT	NUMBER			Total Number of Unapproved Invoices
AR_APPR_INVOICE_AMOUNT	NUMBER			Total Approved invoice Amount
AR_APPR_INVOICE_COUNT	NUMBER			Total Number of Approved Invoices
AR_AMOUNT_DUE	NUMBER			Total amount due
AR_COUNT_DUE	NUMBER			Total number amount lines
AR_AMOUNT_OVERDUE	NUMBER			Total amount overdue
AR_COUNT_OVERDUE	NUMBER			Total number of overdue amount lines
DORMANT_BACKLOG_INACTIV	NUMBER			Inactive dormant backlog amount
DORMANT_BACKLOG_START	NUMBER			Starting dormant backlog amount
LOST_BACKLOG	NUMBER			Lost dormant backlog
ACTIVE_BACKLOG	NUMBER			Active backlog
REVENUE_AT_RISK	NUMBER			Backlog revenue at risk
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created
CREATED_BY	NUMBER	(15)	Yes	Standard who column - User who has created this row
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
CURR_RECORD_TYPE_ID	NUMBER	(15)		Bitmask Identifier for the Currency record type
CURRENCY_CODE	VARCHAR2	(30)		Currency Code of the transaction

Query Text

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


SELECT PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      TIME_ID
,      PROJECT_ID
,      PERIOD_TYPE_ID
,      CALENDAR_TYPE
,      CURRENCY_TYPE
,      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_WRITEOFF_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
,      CURR_RECORD_TYPE_ID
,      CURRENCY_CODE
FROM PJI.PJI_AC_PROJ_F;

Dependencies

[top of page]

PJI.PJI_AC_PROJ_F does not reference any database object

PJI.PJI_AC_PROJ_F is referenced by following:

APPS: PJI_AC_CLS_F_MV; PJI_AC_ORG_F_MV; PJI_AC_PROJ_F