[Home] [Help] [Dependency Information]
Object Name: | FII_AP_MGT_KPI_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | FII_AP_MGT_KPI_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | COMPLETE |
Build Mode: | DEFERRED |
Fast Refreshable: | NO |
FII_AP_PAYOL_XB_MV
FII_TIME_DAY
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 |
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;
APPS.FII_AP_MGT_KPI_MV is not referenced by any database object
|
|
|