eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

MATERIALIZED VIEW: APPS.POA_IDL_001_MV

Object Details

Object Name:	POA_IDL_001_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	POA_IDL_001_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_COM_CC_DIM_MAPS
POA_IDL_BS_J_MV
     AP_SUPPLIERS
     AP_SUPPLIER_SITES_ALL
     FII_AP_INV_B
     FII_AP_INV_DIST_F
     FII_TIME_DAY

[View Source Query]

Columns

Name	Datatype	Length	Comments
GRP_ID	NUMBER		Grouping ID Column
TIME_ID	NUMBER		Nested Grouping ID Column for Time
AGGREGATION_LEVEL	NUMBER		Grouping ID Column
ORG_ID	NUMBER	(15)	Operating Unit Identifier
SUPPLIER_ID	NUMBER	(15)	Supplier Identifier
INV_D_CREATED_BY	NUMBER	(15)	Invoice Distribution Creator Identifier
COMPANY_ID	NUMBER	(15)	Company Identifier
COST_CENTER_ID	NUMBER	(15)	Cost-center Identifier
ENT_QTR_ID	NUMBER		Enterprise Quarter Identifier
ENT_PERIOD_ID	NUMBER		Enterprise Period Identifier
WEEK_ID	NUMBER		FII Week Identifier
DAY_ID	NUMBER		FII Day Identifier
AMOUNT_B	NUMBER		Invoice Amount in Functional Currency
AMOUNT_G	NUMBER		Invoice Amount in Global Currency
AMOUNT_SG	NUMBER		Invoice Amount in Secondary Global Currency
LEAKAGE_AMOUNT_B	NUMBER		Payables Leakage Amount in Functional Currency
LEAKAGE_AMOUNT_G	NUMBER		Payables Leakage Amount in Global Currency
LEAKAGE_AMOUNT_SG	NUMBER		Payables Leakage Amount in Secondary Global Currency
C_AMOUNT_B	NUMBER		Count Columns
C_AMOUNT_G	NUMBER		Count Columns
C_AMOUNT_SG	NUMBER		Count Columns
C_LEAKAGE_AMOUNT_B	NUMBER		Count Columns
C_LEAKAGE_AMOUNT_G	NUMBER		Count Columns
C_LEAKAGE_AMOUNT_SG	NUMBER		Count Columns
C_TOTAL	NUMBER		Row Count

Query Text

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


SELECT GRP_ID
,      TIME_ID
,      AGGREGATION_LEVEL
,      ORG_ID
,      SUPPLIER_ID
,      INV_D_CREATED_BY
,      COMPANY_ID
,      COST_CENTER_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      DAY_ID
,      AMOUNT_B
,      AMOUNT_G
,      AMOUNT_SG
,      LEAKAGE_AMOUNT_B
,      LEAKAGE_AMOUNT_G
,      LEAKAGE_AMOUNT_SG
,      C_AMOUNT_B
,      C_AMOUNT_G
,      C_AMOUNT_SG
,      C_LEAKAGE_AMOUNT_B
,      C_LEAKAGE_AMOUNT_G
,      C_LEAKAGE_AMOUNT_SG
,      C_TOTAL
FROM APPS.POA_IDL_001_MV;

Dependencies

[top of page]

APPS.POA_IDL_001_MV references the following:

APPS: POA_IDL_001_MV; POA_IDL_BS_J_MV; POA_IDL_BS_J_MV
FII: FII_COM_CC_DIM_MAPS

APPS.POA_IDL_001_MV is referenced by following:

APPS: POA_IDL_002_MV