[Home] [Help] [Dependency Information]
Object Name: | PJI_AC_XBS_ACCUM_F_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PJI.PJI_AC_XBS_ACCUM_F_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|