[Home] [Help] [Dependency Information]
Object Name: | PJI_AC_ORGO_F_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | PJI_AC_ORGO_F_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
PJI_AC_ORG_F_MV
PJI_AC_PROJ_F
PJI_ORG_DENORM
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | |||
CALENDAR_TYPE | VARCHAR2 | (30) | Yes | |
PERIOD_TYPE_ID | NUMBER | (15) | Yes | |
CURR_RECORD_TYPE_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | (15) | Yes | |
CNT | NUMBER | |||
REVENUE | NUMBER | |||
REVENUE_CNT | NUMBER | |||
PROJECT_COUNT | NUMBER | |||
PROJECT_COUNT_CNT | NUMBER | |||
INITIAL_FUNDING_AMOUNT | NUMBER | |||
INITIAL_FUNDING_AMOUNT_CNT | NUMBER | |||
INITIAL_FUNDING_COUNT | NUMBER | |||
INITIAL_FUNDING_COUNT_CNT | NUMBER | |||
ADDITIONAL_FUNDING_AMOUNT | NUMBER | |||
ADDITIONAL_FUNDING_AMOUNT_CNT | NUMBER | |||
ADDITIONAL_FUNDING_COUNT | NUMBER | |||
ADDITIONAL_FUNDING_COUNT_CNT | NUMBER | |||
CANCELLED_FUNDING_AMOUNT | NUMBER | |||
CANCELLED_FUNDING_AMOUNT_CNT | NUMBER | |||
CANCELLED_FUNDING_COUNT | NUMBER | |||
CANCELLED_FUNDING_COUNT_CNT | NUMBER | |||
FUNDING_ADJUSTMENT_AMOUNT | NUMBER | |||
FUNDING_ADJUSTMENT_AMOUNT_CNT | NUMBER | |||
FUNDING_ADJUSTMENT_COUNT | NUMBER | |||
FUNDING_ADJUSTMENT_COUNT_CNT | NUMBER | |||
REVENUE_WRITEOFF | NUMBER | |||
REVENUE_WRITEOFF_CNT | NUMBER | |||
AR_INVOICE_AMOUNT | NUMBER | |||
AR_INVOICE_AMOUNT_CNT | NUMBER | |||
AR_INVOICE_COUNT | NUMBER | |||
AR_INVOICE_COUNT_CNT | NUMBER | |||
AR_CASH_APPLIED_AMOUNT | NUMBER | |||
AR_CASH_APPLIED_AMOUNT_CNT | NUMBER | |||
AR_INVOICE_WRITEOFF_AMOUNT | NUMBER | |||
AR_INVOICE_WRITEOFF_AMOUNT_CNT | NUMBER | |||
AR_INVOICE_WRITEOFF_COUNT | NUMBER | |||
AR_INVOICE_WRITEOFF_COUNT_CNT | NUMBER | |||
AR_CREDIT_MEMO_AMOUNT | NUMBER | |||
AR_CREDIT_MEMO_AMOUNT_CNT | NUMBER | |||
AR_CREDIT_MEMO_COUNT | NUMBER | |||
AR_CREDIT_MEMO_COUNT_CNT | NUMBER | |||
UNBILLED_RECEIVABLES | NUMBER | |||
UNBILLED_RECEIVABLES_CNT | NUMBER | |||
UNEARNED_REVENUE | NUMBER | |||
UNEARNED_REVENUE_CNT | NUMBER | |||
AR_UNAPPR_INVOICE_AMOUNT | NUMBER | |||
AR_UNAPPR_INVOICE_AMOUNT_CNT | NUMBER | |||
AR_UNAPPR_INVOICE_COUNT | NUMBER | |||
AR_UNAPPR_INVOICE_COUNT_CNT | NUMBER | |||
AR_APPR_INVOICE_AMOUNT | NUMBER | |||
AR_APPR_INVOICE_AMOUNT_CNT | NUMBER | |||
AR_APPR_INVOICE_COUNT | NUMBER | |||
AR_APPR_INVOICE_COUNT_CNT | NUMBER | |||
AR_AMOUNT_DUE | NUMBER | |||
AR_AMOUNT_DUE_CNT | NUMBER | |||
AR_COUNT_DUE | NUMBER | |||
AR_COUNT_DUE_CNT | NUMBER | |||
AR_AMOUNT_OVERDUE | NUMBER | |||
AR_AMOUNT_OVERDUE_CNT | NUMBER | |||
AR_COUNT_OVERDUE | NUMBER | |||
AR_COUNT_OVERDUE_CNT | NUMBER | |||
DORMANT_BACKLOG_INACTIV | NUMBER | |||
DORMANT_BACKLOG_INACTIV_CNT | NUMBER | |||
DORMANT_BACKLOG_START | NUMBER | |||
DORMANT_BACKLOG_START_CNT | NUMBER | |||
LOST_BACKLOG | NUMBER | |||
LOST_BACKLOG_CNT | NUMBER | |||
ACTIVE_BACKLOG | NUMBER | |||
ACTIVE_BACKLOG_CNT | NUMBER | |||
REVENUE_AT_RISK | NUMBER | |||
REVENUE_AT_RISK_CNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, ORGANIZATION_ID
, CALENDAR_TYPE
, PERIOD_TYPE_ID
, CURR_RECORD_TYPE_ID
, CURRENCY_CODE
, ORG_ID
, CNT
, REVENUE
, REVENUE_CNT
, PROJECT_COUNT
, PROJECT_COUNT_CNT
, INITIAL_FUNDING_AMOUNT
, INITIAL_FUNDING_AMOUNT_CNT
, INITIAL_FUNDING_COUNT
, INITIAL_FUNDING_COUNT_CNT
, ADDITIONAL_FUNDING_AMOUNT
, ADDITIONAL_FUNDING_AMOUNT_CNT
, ADDITIONAL_FUNDING_COUNT
, ADDITIONAL_FUNDING_COUNT_CNT
, CANCELLED_FUNDING_AMOUNT
, CANCELLED_FUNDING_AMOUNT_CNT
, CANCELLED_FUNDING_COUNT
, CANCELLED_FUNDING_COUNT_CNT
, FUNDING_ADJUSTMENT_AMOUNT
, FUNDING_ADJUSTMENT_AMOUNT_CNT
, FUNDING_ADJUSTMENT_COUNT
, FUNDING_ADJUSTMENT_COUNT_CNT
, REVENUE_WRITEOFF
, REVENUE_WRITEOFF_CNT
, AR_INVOICE_AMOUNT
, AR_INVOICE_AMOUNT_CNT
, AR_INVOICE_COUNT
, AR_INVOICE_COUNT_CNT
, AR_CASH_APPLIED_AMOUNT
, AR_CASH_APPLIED_AMOUNT_CNT
, AR_INVOICE_WRITEOFF_AMOUNT
, AR_INVOICE_WRITEOFF_AMOUNT_CNT
, AR_INVOICE_WRITEOFF_COUNT
, AR_INVOICE_WRITEOFF_COUNT_CNT
, AR_CREDIT_MEMO_AMOUNT
, AR_CREDIT_MEMO_AMOUNT_CNT
, AR_CREDIT_MEMO_COUNT
, AR_CREDIT_MEMO_COUNT_CNT
, UNBILLED_RECEIVABLES
, UNBILLED_RECEIVABLES_CNT
, UNEARNED_REVENUE
, UNEARNED_REVENUE_CNT
, AR_UNAPPR_INVOICE_AMOUNT
, AR_UNAPPR_INVOICE_AMOUNT_CNT
, AR_UNAPPR_INVOICE_COUNT
, AR_UNAPPR_INVOICE_COUNT_CNT
, AR_APPR_INVOICE_AMOUNT
, AR_APPR_INVOICE_AMOUNT_CNT
, AR_APPR_INVOICE_COUNT
, AR_APPR_INVOICE_COUNT_CNT
, AR_AMOUNT_DUE
, AR_AMOUNT_DUE_CNT
, AR_COUNT_DUE
, AR_COUNT_DUE_CNT
, AR_AMOUNT_OVERDUE
, AR_AMOUNT_OVERDUE_CNT
, AR_COUNT_OVERDUE
, AR_COUNT_OVERDUE_CNT
, DORMANT_BACKLOG_INACTIV
, DORMANT_BACKLOG_INACTIV_CNT
, DORMANT_BACKLOG_START
, DORMANT_BACKLOG_START_CNT
, LOST_BACKLOG
, LOST_BACKLOG_CNT
, ACTIVE_BACKLOG
, ACTIVE_BACKLOG_CNT
, REVENUE_AT_RISK
, REVENUE_AT_RISK_CNT
FROM APPS.PJI_AC_ORGO_F_MV;
APPS.PJI_AC_ORGO_F_MV is not referenced by any database object
|
|
|