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


VIEW: APPS.PJI_AC_XBS_ACCUM_F_V

Object Details
Object Name: PJI_AC_XBS_ACCUM_F_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJI.PJI_AC_XBS_ACCUM_F_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

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 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

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
CUSTOM16 NUMBER

Custom measure16
CUSTOM17 NUMBER

Custom measure17
CUSTOM18 NUMBER

Custom measure18
CUSTOM19 NUMBER

Custom measure19
CUSTOM20 NUMBER

Custom measure20
CUSTOM21 NUMBER

Custom measure21
CUSTOM22 NUMBER

Custom measure22
CUSTOM23 NUMBER

Custom measure23
CUSTOM24 NUMBER

Custom measure24
CUSTOM25 NUMBER

Custom measure25
CUSTOM26 NUMBER

Custom measure26
CUSTOM27 NUMBER

Custom measure27
CUSTOM28 NUMBER

Custom measure28
CUSTOM29 NUMBER

Custom measure29
CUSTOM30 NUMBER

Custom measure30
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
,      CUSTOM16
,      CUSTOM17
,      CUSTOM18
,      CUSTOM19
,      CUSTOM20
,      CUSTOM21
,      CUSTOM22
,      CUSTOM23
,      CUSTOM24
,      CUSTOM25
,      CUSTOM26
,      CUSTOM27
,      CUSTOM28
,      CUSTOM29
,      CUSTOM30
FROM APPS.PJI_AC_XBS_ACCUM_F_V;

Dependencies

[top of page]

APPS.PJI_AC_XBS_ACCUM_F_V references the following:

SchemaAPPS
SynonymPJI_AC_XBS_ACCUM_F
APPS.PJI_AC_XBS_ACCUM_F_V is referenced by following:

SchemaAPPS
Package BodyPJI_REP_MEASURE_UTIL - show dependent code