Skip to content

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

MATERIALIZED VIEW: APPS.FII_AR_REV_SUM_MV

Object Details
Object Name: FII_AR_REV_SUM_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_AR_REV_SUM_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

FII_AR_REVENUE_B
FII_COM_CC_MAPPINGS
FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

PERIOD_TYPE_ID NUMBER

REPORT_DATE_JULIAN NUMBER

ENT_QTR_ID NUMBER

ENT_PERIOD_ID NUMBER

WEEK_ID NUMBER

ENT_YEAR_ID NUMBER

LINE_OF_BUSINESS_ID NUMBER

MANAGER_ID NUMBER

PRODUCT_CATEGORY_ID NUMBER

LEDGER_ID NUMBER (10)
SALES_CHANNEL_CODE VARCHAR2 (30)
ACCT_CURRENCY_CODE VARCHAR2 (15)
COUNT_GRP NUMBER

REV_ACTUAL_B NUMBER

COUNT_REV_ACTUAL_B NUMBER

REV_PRIM_ACTUAL_G NUMBER

COUNT_REV_PRIM_ACTUAL_G NUMBER

REV_SEC_ACTUAL_G NUMBER

COUNT_REV_SEC_ACTUAL_G NUMBER

GID NUMBER

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      REPORT_DATE_JULIAN
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      ENT_YEAR_ID
,      LINE_OF_BUSINESS_ID
,      MANAGER_ID
,      PRODUCT_CATEGORY_ID
,      LEDGER_ID
,      SALES_CHANNEL_CODE
,      ACCT_CURRENCY_CODE
,      COUNT_GRP
,      REV_ACTUAL_B
,      COUNT_REV_ACTUAL_B
,      REV_PRIM_ACTUAL_G
,      COUNT_REV_PRIM_ACTUAL_G
,      REV_SEC_ACTUAL_G
,      COUNT_REV_SEC_ACTUAL_G
,      GID
FROM APPS.FII_AR_REV_SUM_MV;

Dependencies

[top of page]

APPS.FII_AR_REV_SUM_MV references the following:

SchemaAPPS
TableFII_AR_REV_SUM_MV
SchemaFII
TableFII_AR_REVENUE_B
TableFII_COM_CC_MAPPINGS
TableFII_TIME_DAY

APPS.FII_AR_REV_SUM_MV is not referenced by any database object