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

TABLE: APPS.FII_AP_IVATY_B_MV

Object Details
Object Name: FII_AP_IVATY_B_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.FII_AP_IVATY_B_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_FII_AP_IVATY_B_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ORG_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("REPORT_DATE_JULIAN")
ColumnSYS_OP_MAP_NONNULL("GID1")
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 does not reference any database object

APPS.FII_AP_IVATY_B_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_IVATY_B_MV
Materialized ViewFII_AP_IVATY_XB_MV