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

MATERIALIZED VIEW: APPS.FII_AP_PAID_XB_MV

Object Details
Object Name: FII_AP_PAID_XB_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_AP_PAID_XB_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

FII_AP_INVOICE_B

[View Source Query]

Columns
Name Datatype Length Mandatory 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
PAID_AMT_B NUMBER

Total paid amount in base currency
PAID_AMT_PRIM_G NUMBER

Total paid amount in primary currency
PAID_AMT_SEC_G NUMBER

Total paid amount in 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 total paid amount in primary currency
PAID_INVOICE_AMT_MTD_PRIM_G NUMBER

Month to date total paid amount in primary currency
PAID_INVOICE_AMT_QTD_PRIM_G NUMBER

Quarter to date total paid amount in primary currency
PAID_INVOICE_AMT_YTD_PRIM_G NUMBER

Year to date total paid amount in primary currency
PAID_INVOICE_AMT_WTD_SEC_G NUMBER

Week to date total paid amount in secondary currency
PAID_INVOICE_AMT_MTD_SEC_G NUMBER

Month to date total paid amount in secondary currency
PAID_INVOICE_AMT_QTD_SEC_G NUMBER

Quarter to date total paid amount in secondary currency
PAID_INVOICE_AMT_YTD_SEC_G NUMBER

Year to date total paid amount in secondary currency
PAID_INV_COUNT_WTD NUMBER

PAID_INV_COUNT_MTD NUMBER

PAID_INV_COUNT_QTD NUMBER

PAID_INV_COUNT_YTD NUMBER

PAYMENT_COUNT_WTD NUMBER

Week to date total number of payments
PAYMENT_COUNT_MTD NUMBER

Month to date total number of payments
PAYMENT_COUNT_QTD NUMBER

Quarter to date total number of payments
PAYMENT_COUNT_YTD NUMBER

Year to date total number of payments
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
E_PAYMENT_AMT_B NUMBER

Total electronic paid amount in base currency
E_PAYMENT_AMT_PRIM_G NUMBER

Total electronic paid amount in primary currency
E_PAYMENT_AMT_SEC_G NUMBER

Total electronic paid amount in secondary currency
E_PAYMENT_COUNT NUMBER

Total number of electronic payments
PAID_DIS_OFFERED_WTD_B NUMBER

Week to date total discounts offered in base currency
PAID_DIS_OFFERED_MTD_B NUMBER

Month to date total discounts offered in base currency
PAID_DIS_OFFERED_QTD_B NUMBER

Quarter to date total discounts offered in base currency
PAID_DIS_OFFERED_YTD_B NUMBER

Year to date total discounts offered in base currency
PAID_DIS_OFFERED_WTD_PRIM_G NUMBER

Week to date total discounts offered in primary currency
PAID_DIS_OFFERED_MTD_PRIM_G NUMBER

Month to date total discounts offered in primary currency
PAID_DIS_OFFERED_QTD_PRIM_G NUMBER

Quarter to date total discounts offered in primary currency
PAID_DIS_OFFERED_YTD_PRIM_G NUMBER

Year to date total discounts offered in primary currency
PAID_DIS_OFFERED_WTD_SEC_G NUMBER

Week to date total discounts offered in secondary currency
PAID_DIS_OFFERED_MTD_SEC_G NUMBER

Month to date total discounts offered in secondary currency
PAID_DIS_OFFERED_QTD_SEC_G NUMBER

Quarter to date total discounts offered in secondary currency
PAID_DIS_OFFERED_YTD_SEC_G NUMBER

Year to date total discounts 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
PAID_DIS_LOST_WTD_B NUMBER

Week to date total discounts lost in base currency
PAID_DIS_LOST_MTD_B NUMBER

Month to date total discounts lost in base currency
PAID_DIS_LOST_QTD_B NUMBER

Quarter to date total discounts lost in base currency
PAID_DIS_LOST_YTD_B NUMBER

Year to date total discounts lost in base currency
PAID_DIS_LOST_WTD_PRIM_G NUMBER

Week to date total discounts lost in primary currency
PAID_DIS_LOST_MTD_PRIM_G NUMBER

Month to date total discounts lost in primary currency
PAID_DIS_LOST_QTD_PRIM_G NUMBER

Quarter to date total discounts lost in primary currency
PAID_DIS_LOST_YTD_PRIM_G NUMBER

Year to date total discounts lost in primary currency
PAID_DIS_LOST_WTD_SEC_G NUMBER

Week to date total discounts lost in secondary currency
PAID_DIS_LOST_MTD_SEC_G NUMBER

Month to date total discounts lost in secondary currency
PAID_DIS_LOST_QTD_SEC_G NUMBER

Quarter to date total discounts lost in secondary currency
PAID_DIS_LOST_YTD_SEC_G NUMBER

Year to date total discounts lost in secondary currency
INVOICE_TO_PAYMENT_DAYS NUMBER

Weighted average number of days to pay the invoice
Query Text

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


SELECT ORG_ID
,      SUPPLIER_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      GID
,      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
,      E_PAYMENT_AMT_B
,      E_PAYMENT_AMT_PRIM_G
,      E_PAYMENT_AMT_SEC_G
,      E_PAYMENT_COUNT
,      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
,      PAID_DIS_LOST_WTD_B
,      PAID_DIS_LOST_MTD_B
,      PAID_DIS_LOST_QTD_B
,      PAID_DIS_LOST_YTD_B
,      PAID_DIS_LOST_WTD_PRIM_G
,      PAID_DIS_LOST_MTD_PRIM_G
,      PAID_DIS_LOST_QTD_PRIM_G
,      PAID_DIS_LOST_YTD_PRIM_G
,      PAID_DIS_LOST_WTD_SEC_G
,      PAID_DIS_LOST_MTD_SEC_G
,      PAID_DIS_LOST_QTD_SEC_G
,      PAID_DIS_LOST_YTD_SEC_G
,      INVOICE_TO_PAYMENT_DAYS
FROM APPS.FII_AP_PAID_XB_MV;

Dependencies

[top of page]

APPS.FII_AP_PAID_XB_MV references the following:

SchemaAPPS
TableFII_AP_PAID_XB_MV
SchemaFII
TableFII_AP_INVOICE_B
TableFII_AP_PAY_SCHED_B
TableFII_TIME_DAY
APPS.FII_AP_PAID_XB_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_MGT_KPI_MV