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

VIEW: APPS.PA_AC_OLAP_STAGE_V

Object Details
Object Name: PA_AC_OLAP_STAGE_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OLAP_GROUP NUMBER
Yes
PROJECT_ID NUMBER (15) Yes Identifier for the project
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
CALENDAR_TYPE VARCHAR2 (1) Yes Specifies the calendar type (PA, GL, Enterprise)
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 OLAP_GROUP
,      PROJECT_ID
,      PROJECT_ELEMENT_ID
,      TIME_ID
,      CALENDAR_TYPE
,      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.PA_AC_OLAP_STAGE_V;

Dependencies

[top of page]

APPS.PA_AC_OLAP_STAGE_V references the following:

SchemaAPPS
SynonymPA_AC_OLAP_STAGE

APPS.PA_AC_OLAP_STAGE_V is not referenced by any database object