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

TABLE: APPS.FII_AP_MGT_KPI_MV

Object Details
Object Name: FII_AP_MGT_KPI_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.FII_AP_MGT_KPI_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AP_MGT_KPI_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnPERIOD_TYPE_ID
ColumnTIME_ID
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Operating Unit Identifier
TIME_ID NUMBER

Time Identifier
PERIOD_TYPE_ID NUMBER

Period type identifier
INVOICE_COUNT_ENTERED NUMBER

Total number of invoices entered
E_INVOICE_COUNT NUMBER

Total number of electronic invoices
PAID_AMT_B NUMBER

Total paid amount in base currency
PAID_AMT_PRIM_G NUMBER

Total paid amount in the primary currency
PAID_AMT_SEC_G NUMBER

Total paid amount in the secondary currency
PAID_INVOICE_AMT_WTD_B NUMBER

Week to date total paid amount in base currency
PAID_INVOICE_AMT_MTD_B NUMBER

Month to date total paid amount in base currency
PAID_INVOICE_AMT_QTD_B NUMBER

Quarter to date total paid amount in base currency
PAID_INVOICE_AMT_YTD_B NUMBER

Year to date total paid amount in base currency
PAID_INVOICE_AMT_WTD_PRIM_G NUMBER

Week to date paid amount in primary currency
PAID_INVOICE_AMT_MTD_PRIM_G NUMBER

Month to date paid amount in primary currency
PAID_INVOICE_AMT_QTD_PRIM_G NUMBER

Quarter to date paid amount in primary currency
PAID_INVOICE_AMT_YTD_PRIM_G NUMBER

Year to date paid amount in primary currency
PAID_INVOICE_AMT_WTD_SEC_G NUMBER

Week to date paid amount in secondary currency
PAID_INVOICE_AMT_MTD_SEC_G NUMBER

Month to date paid amount in secondary currency
PAID_INVOICE_AMT_QTD_SEC_G NUMBER

Quarter to date paid amount in secondary currency
PAID_INVOICE_AMT_YTD_SEC_G NUMBER

Year to date paid amount in secondary currency
PAID_INV_COUNT_WTD NUMBER

Week to date number of paid invoices
PAID_INV_COUNT_MTD NUMBER

Month to date number of paid invoices
PAID_INV_COUNT_QTD NUMBER

Quarter to date number of paid invoices
PAID_INV_COUNT_YTD NUMBER

Year to date number of paid invoices
PAYMENT_COUNT_WTD NUMBER

Week to date Total number of payments on all the invoices
PAYMENT_COUNT_MTD NUMBER

Month to date Total number of payments on all the invoices
PAYMENT_COUNT_QTD NUMBER

Quarter to date Total number of payments on all the invoices
PAYMENT_COUNT_YTD NUMBER

Year to date Total number of payments on all the invoices
PAID_ON_TIME_AMT_B NUMBER

Total on time paid amount in base currency
PAID_ON_TIME_AMT_PRIM_G NUMBER

Total on time paid amount in primary currency
PAID_ON_TIME_AMT_SEC_G NUMBER

Total on time paid amount in secondary currency
PAID_LATE_AMT_B NUMBER

Total late paid amount in base currency
PAID_LATE_AMT_PRIM_G NUMBER

Total late paid amount in primary currency
PAID_LATE_AMT_SEC_G NUMBER

Total late paid amount in secondary currency
PAID_DIS_OFFERED_WTD_B NUMBER

Week to date total discount offered in base currency
PAID_DIS_OFFERED_MTD_B NUMBER

Month to date discount offered in base currency
PAID_DIS_OFFERED_QTD_B NUMBER

Quarter to date discount offered in base currency
PAID_DIS_OFFERED_YTD_B NUMBER

Year to date discount offered in base currency
PAID_DIS_OFFERED_WTD_PRIM_G NUMBER

Week to date discount offered in primary currency
PAID_DIS_OFFERED_MTD_PRIM_G NUMBER

Month to date discount offered in primary currency
PAID_DIS_OFFERED_QTD_PRIM_G NUMBER

Quarter to date discount offered in primary currency
PAID_DIS_OFFERED_YTD_PRIM_G NUMBER

Year to date discount offered in primary currency
PAID_DIS_OFFERED_WTD_SEC_G NUMBER

Week to date discount offered in secondary currency
PAID_DIS_OFFERED_MTD_SEC_G NUMBER

Month to date discount offered in secondary currency
PAID_DIS_OFFERED_QTD_SEC_G NUMBER

Quarter to date discount offered in secondary currency
PAID_DIS_OFFERED_YTD_SEC_G NUMBER

Year to date discount offered in secondary currency
PAID_DIS_TAKEN_B NUMBER

Total discount taken in base currency
PAID_DIS_TAKEN_PRIM_G NUMBER

Total discount taken in primary currency
PAID_DIS_TAKEN_SEC_G NUMBER

Total discount taken in secondary currency
INVOICE_TO_PAYMENT_DAYS NUMBER

Average of number of days to pay a invoice
PAID_ON_TIME_COUNT_WTD NUMBER

Week to date number of invoices paid on time
PAID_ON_TIME_COUNT_MTD NUMBER

Month to date number of invoices paid on time
PAID_ON_TIME_COUNT_QTD NUMBER

Quarter to date number of invoices paid on time
PAID_ON_TIME_COUNT_YTD NUMBER

Year to date number of invoices paid on time
PAID_LATE_COUNT_WTD NUMBER

Week to date number of invoices paid late
PAID_LATE_COUNT_MTD NUMBER

Month to date number of invoices paid late
PAID_LATE_COUNT_QTD NUMBER

Quarter to date number of invoices paid late
PAID_LATE_COUNT_YTD NUMBER

Year to date number of invoices paid late
Query Text

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


SELECT ORG_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      INVOICE_COUNT_ENTERED
,      E_INVOICE_COUNT
,      PAID_AMT_B
,      PAID_AMT_PRIM_G
,      PAID_AMT_SEC_G
,      PAID_INVOICE_AMT_WTD_B
,      PAID_INVOICE_AMT_MTD_B
,      PAID_INVOICE_AMT_QTD_B
,      PAID_INVOICE_AMT_YTD_B
,      PAID_INVOICE_AMT_WTD_PRIM_G
,      PAID_INVOICE_AMT_MTD_PRIM_G
,      PAID_INVOICE_AMT_QTD_PRIM_G
,      PAID_INVOICE_AMT_YTD_PRIM_G
,      PAID_INVOICE_AMT_WTD_SEC_G
,      PAID_INVOICE_AMT_MTD_SEC_G
,      PAID_INVOICE_AMT_QTD_SEC_G
,      PAID_INVOICE_AMT_YTD_SEC_G
,      PAID_INV_COUNT_WTD
,      PAID_INV_COUNT_MTD
,      PAID_INV_COUNT_QTD
,      PAID_INV_COUNT_YTD
,      PAYMENT_COUNT_WTD
,      PAYMENT_COUNT_MTD
,      PAYMENT_COUNT_QTD
,      PAYMENT_COUNT_YTD
,      PAID_ON_TIME_AMT_B
,      PAID_ON_TIME_AMT_PRIM_G
,      PAID_ON_TIME_AMT_SEC_G
,      PAID_LATE_AMT_B
,      PAID_LATE_AMT_PRIM_G
,      PAID_LATE_AMT_SEC_G
,      PAID_DIS_OFFERED_WTD_B
,      PAID_DIS_OFFERED_MTD_B
,      PAID_DIS_OFFERED_QTD_B
,      PAID_DIS_OFFERED_YTD_B
,      PAID_DIS_OFFERED_WTD_PRIM_G
,      PAID_DIS_OFFERED_MTD_PRIM_G
,      PAID_DIS_OFFERED_QTD_PRIM_G
,      PAID_DIS_OFFERED_YTD_PRIM_G
,      PAID_DIS_OFFERED_WTD_SEC_G
,      PAID_DIS_OFFERED_MTD_SEC_G
,      PAID_DIS_OFFERED_QTD_SEC_G
,      PAID_DIS_OFFERED_YTD_SEC_G
,      PAID_DIS_TAKEN_B
,      PAID_DIS_TAKEN_PRIM_G
,      PAID_DIS_TAKEN_SEC_G
,      INVOICE_TO_PAYMENT_DAYS
,      PAID_ON_TIME_COUNT_WTD
,      PAID_ON_TIME_COUNT_MTD
,      PAID_ON_TIME_COUNT_QTD
,      PAID_ON_TIME_COUNT_YTD
,      PAID_LATE_COUNT_WTD
,      PAID_LATE_COUNT_MTD
,      PAID_LATE_COUNT_QTD
,      PAID_LATE_COUNT_YTD
FROM APPS.FII_AP_MGT_KPI_MV;

Dependencies

[top of page]

APPS.FII_AP_MGT_KPI_MV does not reference any database object

APPS.FII_AP_MGT_KPI_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_MGT_KPI_MV