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

MATERIALIZED VIEW: APPS.FII_AP_IVATY_XB_MV

Object Details
Object Name: FII_AP_IVATY_XB_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_AP_IVATY_XB_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_AP_IVATY_B_MV
     FII_AP_INVOICE_B
     FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Operating Unit Identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
TIME_ID NUMBER

Time identifier
PERIOD_TYPE_ID NUMBER

Period Type Identifier
GID NUMBER

Grouping Identifier
INVOICE_AMT_ENTERED_B NUMBER

Total invoice amount in base currency
INVOICE_AMT_ENTERED_BC NUMBER

Internal aggregation for fast MV refresh
INVOICE_AMT_ENTERED_PRIM_G NUMBER

Total invoice amount in primary currency
INVOICE_AMT_ENTERED_PRIM_GC NUMBER

Internal aggregation for fast MV refresh
INVOICE_AMT_ENTERED_SEC_G NUMBER

Total invoice amount in scondary currency
INVOICE_AMT_ENTERED_SEC_GC NUMBER

Internal aggregation for fast MV refresh
INVOICE_COUNT_ENTERED NUMBER

Total number of invoices entered
INVOICE_COUNT_ENTEREDC NUMBER

Aggregation function on column for fast MV refresh
E_INVOICE_AMT_B NUMBER

Total electronic invoice amounts in base currency
E_INVOICE_AMT_BC NUMBER

Aggregation function on above column for fast MV refresh
E_INVOICE_AMT_PRIM_G NUMBER

Total electronic invoice amounts in primary currency
E_INVOICE_AMT_PRIM_GC NUMBER

Internal aggregation for fast MV refresh
E_INVOICE_AMT_SEC_G NUMBER

Total electronic invoice amounts in secondary currency
E_INVOICE_AMT_SEC_GC NUMBER

Internal aggregation for fast MV refresh
E_INVOICE_COUNT NUMBER

Total number of electronic invoices
E_INVOICE_COUNTC NUMBER

Internal aggregation for fast MV refresh
DISTRIBUTION_COUNT NUMBER

Total number of distributions of all the invoices
DISTRIBUTION_COUNTC NUMBER

Internal aggregation for fast MV refresh
E_DISTRIBUTION_COUNT NUMBER

Total number of distributions for each electronic invoice
E_DISTRIBUTION_COUNTC NUMBER

Internal aggregation for fast MV refresh
XML_COUNT NUMBER

Total number of invoices of source XML GATEWAY
XML_COUNTC NUMBER

Internal aggregation for fast MV refresh
EDI_COUNT NUMBER

Total number of invoices of source EDI GATEWAY
EDI_COUNTC NUMBER

Internal aggregation for fast MV refresh
ERS_COUNT NUMBER

Total number of invoices of source ERS
ERS_COUNTC NUMBER

Internal aggregation for fast MV refresh
ISP_COUNT NUMBER

Total number of invoices of source ISP
ISP_COUNTC NUMBER

Internal aggregation for fast MV refresh
ASBN_COUNT NUMBER

Total number of invoices of source ASBN
ASBN_COUNTC NUMBER

Internal aggregation for fast MV refresh
OTHER_INTEGRATED_COUNT NUMBER

Total number of invoices of source other than XML, EDI, ERS, ISP, ASBN
OTHER_INTEGRATED_COUNTC NUMBER

Internal aggregation for fast MV refresh
STANDARD_COUNT NUMBER

Total number of invoices of type STANDARD
STANDARD_COUNTC NUMBER

Internal aggregation for fast MV refresh
WITHHOLDING_COUNT NUMBER

Total number of invoices of type AWT
WITHHOLDING_COUNTC NUMBER

Internal aggregation for fast MV refresh
PREPAYMENT_COUNT NUMBER

Total number of invoices of type PREPAYMENT
PREPAYMENT_COUNTC NUMBER

Internal aggregation for fast MV refresh
CREDIT_COUNT NUMBER

Total number of invoices of type CREDIT
CREDIT_COUNTC NUMBER

Internal aggregation for fast MV refresh
DEBIT_COUNT NUMBER

Total number of invoices of type DEBIT
DEBIT_COUNTC NUMBER

Internal aggregation for fast MV refresh
MIXED_COUNT NUMBER

Total number of invoices of type MIXED
MIXED_COUNTC NUMBER

Internal aggregation for fast MV refresh
INTEREST_COUNT NUMBER

Total number of invoices of type INTEREST
INTEREST_COUNTC NUMBER

Internal aggregation for fast MV refresh
CNT NUMBER

Aggregation value for fast MV refresh
Query Text

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


SELECT ORG_ID
,      SUPPLIER_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      GID
,      INVOICE_AMT_ENTERED_B
,      INVOICE_AMT_ENTERED_BC
,      INVOICE_AMT_ENTERED_PRIM_G
,      INVOICE_AMT_ENTERED_PRIM_GC
,      INVOICE_AMT_ENTERED_SEC_G
,      INVOICE_AMT_ENTERED_SEC_GC
,      INVOICE_COUNT_ENTERED
,      INVOICE_COUNT_ENTEREDC
,      E_INVOICE_AMT_B
,      E_INVOICE_AMT_BC
,      E_INVOICE_AMT_PRIM_G
,      E_INVOICE_AMT_PRIM_GC
,      E_INVOICE_AMT_SEC_G
,      E_INVOICE_AMT_SEC_GC
,      E_INVOICE_COUNT
,      E_INVOICE_COUNTC
,      DISTRIBUTION_COUNT
,      DISTRIBUTION_COUNTC
,      E_DISTRIBUTION_COUNT
,      E_DISTRIBUTION_COUNTC
,      XML_COUNT
,      XML_COUNTC
,      EDI_COUNT
,      EDI_COUNTC
,      ERS_COUNT
,      ERS_COUNTC
,      ISP_COUNT
,      ISP_COUNTC
,      ASBN_COUNT
,      ASBN_COUNTC
,      OTHER_INTEGRATED_COUNT
,      OTHER_INTEGRATED_COUNTC
,      STANDARD_COUNT
,      STANDARD_COUNTC
,      WITHHOLDING_COUNT
,      WITHHOLDING_COUNTC
,      PREPAYMENT_COUNT
,      PREPAYMENT_COUNTC
,      CREDIT_COUNT
,      CREDIT_COUNTC
,      DEBIT_COUNT
,      DEBIT_COUNTC
,      MIXED_COUNT
,      MIXED_COUNTC
,      INTEREST_COUNT
,      INTEREST_COUNTC
,      CNT
FROM APPS.FII_AP_IVATY_XB_MV;

Dependencies

[top of page]

APPS.FII_AP_IVATY_XB_MV references the following:

SchemaAPPS
TableFII_AP_IVATY_B_MV
Materialized ViewFII_AP_IVATY_B_MV
TableFII_AP_IVATY_XB_MV
APPS.FII_AP_IVATY_XB_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_MGT_KPI_MV