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

TABLE: APPS.FII_AP_PAID_XB_MV

Object Details
Object Name: FII_AP_PAID_XB_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.FII_AP_PAID_XB_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AP_PAID_XB_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnGID
ColumnPERIOD_TYPE_ID
ColumnTIME_ID
ColumnORG_ID
FII_AP_PAID_XB_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnGID
ColumnPERIOD_TYPE_ID
ColumnTIME_ID
ColumnSUPPLIER_ID
ColumnORG_ID
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 does not reference any database object

APPS.FII_AP_PAID_XB_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_MGT_KPI_MV
Materialized ViewFII_AP_PAID_XB_MV