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]

TABLE: APPS.FII_AP_IVATY_XB_MV

Object Details

Object Name:	FII_AP_IVATY_XB_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.FII_AP_IVATY_XB_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_FII_AP_IVATY_XB_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("ORG_ID") SYS_OP_MAP_NONNULL("SUPPLIER_ID") SYS_OP_MAP_NONNULL("TIME_ID") SYS_OP_MAP_NONNULL("PERIOD_TYPE_ID") SYS_OP_MAP_NONNULL("GID")
FII_AP_IVATY_XB_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	GID PERIOD_TYPE_ID TIME_ID ORG_ID
FII_AP_IVATY_XB_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	GID PERIOD_TYPE_ID TIME_ID SUPPLIER_ID ORG_ID

Columns

Name	Datatype	Length	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 does not reference any database object

APPS.FII_AP_IVATY_XB_MV is referenced by following:

APPS: FII_AP_IVATY_XB_MV; FII_AP_MGT_KPI_MV