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

MATERIALIZED VIEW: APPS.FII_AP_IVATY_B_MV

Object Details
Object Name: FII_AP_IVATY_B_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_AP_IVATY_B_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_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
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

FII week Identifier
REPORT_DATE_JULIAN NUMBER

Reporting date in Julian format
TIME_ID NUMBER

Time Identifier
PERIOD_TYPE_ID NUMBER

Period type identifier
INVOICE_AMT_B NUMBER

Total invoice amount in base currency
INVOICE_AMT_BC NUMBER

Internal aggregation for fast MV refresh
PRIM_INVOICE_AMT NUMBER

Total invoice amount in primary currency
PRIM_INVOICE_AMTC NUMBER

Internal aggregation for fast MV refresh
SEC_INVOICE_AMT NUMBER

Total invoice amount in secondary currency
SEC_INVOICE_AMTC NUMBER

INVOICE_ENTERED_COUNT NUMBER

Total number of invoices entered
DISTRIBUTION_COUNT NUMBER

Total number of distributions for each invoice
DISTRIBUTION_COUNTC NUMBER

Internal aggregation for fast MV refresh
E_INVOICE_AMT_B NUMBER

Total electronic invoice amount in base currency
E_INVOICE_AMT_BC NUMBER

Internal aggregation for fast MV refresh
PRIM_E_INVOICE_AMT NUMBER

Total electronic invoice amount in primary currency
PRIM_E_INVOICE_AMTC NUMBER

Internal aggregation for fast MV refresh
SEC_E_INVOICE_AMT NUMBER

Total electronic invoice amount in secondary currency
SEC_E_INVOICE_AMTC NUMBER

Internal aggregation for fast MV refresh
E_INVOICE_COUNT NUMBER

E_INVOICE_COUNTC NUMBER

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 invoice 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 invoice of type CREDIT
CREDIT_COUNTC NUMBER

Internal aggregation for fast MV refresh
DEBIT_COUNT NUMBER

Total number of invoice of type DEBIT
DEBIT_COUNTC NUMBER

Internal aggregation for fast MV refresh
MIXED_COUNT NUMBER

Total number of invoice of type MIXED
MIXED_COUNTC NUMBER

Internal aggregation for fast MV refresh
INTEREST_COUNT NUMBER

Total number of invoice of type INTEREST
INTEREST_COUNTC NUMBER

Internal aggregation for fast MV refresh
GID1 NUMBER

Grouping Identifier
Query Text

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


SELECT ORG_ID
,      SUPPLIER_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      TIME_ID
,      PERIOD_TYPE_ID
,      INVOICE_AMT_B
,      INVOICE_AMT_BC
,      PRIM_INVOICE_AMT
,      PRIM_INVOICE_AMTC
,      SEC_INVOICE_AMT
,      SEC_INVOICE_AMTC
,      INVOICE_ENTERED_COUNT
,      DISTRIBUTION_COUNT
,      DISTRIBUTION_COUNTC
,      E_INVOICE_AMT_B
,      E_INVOICE_AMT_BC
,      PRIM_E_INVOICE_AMT
,      PRIM_E_INVOICE_AMTC
,      SEC_E_INVOICE_AMT
,      SEC_E_INVOICE_AMTC
,      E_INVOICE_COUNT
,      E_INVOICE_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
,      GID1
FROM APPS.FII_AP_IVATY_B_MV;

Dependencies

[top of page]

APPS.FII_AP_IVATY_B_MV references the following:

SchemaAPPS
TableFII_AP_IVATY_B_MV
SchemaFII
TableFII_AP_INVOICE_B
TableFII_TIME_DAY
APPS.FII_AP_IVATY_B_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_IVATY_XB_MV