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

MATERIALIZED VIEW: APPS.POA_IDL_002_MV

Object Details
Object Name: POA_IDL_002_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: POA_IDL_002_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_COMPANY_HIERARCHIES
FII_COST_CTR_HIERARCHIES
POA_IDL_001_MV
     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 Mandatory Comments
GRP_ID NUMBER

Grouping ID Column
TIME_ID NUMBER

Nested Grouping ID Column for Time
ORG_ID NUMBER (15)
Operating Unit Identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
INV_D_CREATED_BY NUMBER (15)
Invoice Distribution Creator Identifier
PARENT_COMPANY_ID NUMBER (15)
Parent Company Identifier
PARENT_CC_ID NUMBER (15)
Parent Cost-center Identifier
COMPANY_ID NUMBER (15)
Company Identifier
COST_CENTER_ID NUMBER (15)
Cost-center 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
AGGREGATION_LEVEL NUMBER

Grouping ID Column
Query Text

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


SELECT GRP_ID
,      TIME_ID
,      ORG_ID
,      SUPPLIER_ID
,      INV_D_CREATED_BY
,      PARENT_COMPANY_ID
,      PARENT_CC_ID
,      COMPANY_ID
,      COST_CENTER_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
,      AGGREGATION_LEVEL
FROM APPS.POA_IDL_002_MV;

Dependencies

[top of page]

APPS.POA_IDL_002_MV references the following:

SchemaAPPS
TablePOA_IDL_001_MV
Materialized ViewPOA_IDL_001_MV
TablePOA_IDL_002_MV
SchemaFII
TableFII_COMPANY_HIERARCHIES
TableFII_COST_CTR_HIERARCHIES

APPS.POA_IDL_002_MV is not referenced by any database object