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

TABLE: APPS.FII_AP_LIA_IB_MV

Object Details
Object Name: FII_AP_LIA_IB_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.FII_AP_LIA_IB_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_FII_AP_LIA_IB_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ORG_ID")
ColumnSYS_OP_MAP_NONNULL("SUPPLIER_ID")
ColumnSYS_OP_MAP_NONNULL("TIME_ID")
ColumnSYS_OP_MAP_NONNULL("PERIOD_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("GID")
FII_AP_LIA_IB_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnGID
ColumnPERIOD_TYPE_ID
ColumnTIME_ID
ColumnORG_ID
FII_AP_LIA_IB_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
COUNT_ALL NUMBER

Internal aggregation for fast MV refresh
OPEN_AMT_B NUMBER

Total unpaid invoice amounts in base currency
OPEN_AMT_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_AMT_PRIM_G NUMBER

Total unpaid invoice amounts in primary currency
OPEN_AMT_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_AMT_SEC_G NUMBER

Total unpaid invoice amounts in secondary currency
OPEN_AMT_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_COUNT NUMBER

Total number of unpaid invoices
OPEN_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_COUNT NUMBER

Total number of unpaid invoices which are due
OPEN_DUE_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_AMT_B NUMBER

Total past due unpaid invoice amounts in base currency
OPEN_PAST_DUE_AMT_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_AMT_PRIM_G NUMBER

Total past due unpaid invoice amounts in primary currency
OPEN_PAST_DUE_AMT_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_AMT_SEC_G NUMBER

Total past due unpaid invoice amount in secondary currency
OPEN_PAST_DUE_AMT_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_COUNT NUMBER

Total number of unpaid invoices which are past due
OPEN_PAST_DUE_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAYMENT_AMT_B NUMBER

Total payment amount on unpaid invoices in base currency
OPEN_PAYMENT_AMT_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAYMENT_AMT_PRIM_G NUMBER

Total payment amount on unpaid invoices in primary currency
OPEN_PAYMENT_AMT_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAYMENT_AMT_SEC_G NUMBER

Total payment amount on unpaid invoices in secondary currency
OPEN_PAYMENT_AMT_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_OFFERED_B NUMBER

Total discounts offered on unpaid invoices in base currency
OPEN_DISCOUNT_OFFERED_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_OFFERED_PRIM_G NUMBER

Total discounts offered on unpaid invoices in primary currency
OPEN_DIS_OFFERED_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_OFFERED_SEC_G NUMBER

Total discounts offered on unpaid invoices in secondary currency
OPEN_DIS_OFFERED_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_REMAINING_B NUMBER

Total discounts remaining on unpaid invoices in base currency
OPEN_DIS_REMAINING_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_REMAINING_PRIM_G NUMBER

Total discounts remaining on unpaid invoices in primary currency
OPEN_DIS_REMAINING_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_REMAINING_SEC_G NUMBER

Total discounts remaining on unpaid invoices in secondary currency
OPEN_DIS_REMAINING_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_TAKEN_B NUMBER

Total discounts taken on unpaid invoices in base currency
OPEN_DIS_TAKEN_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_TAKEN_PRIM_G NUMBER

Total discounts taken on unpaid invoices in primary currency
OPEN_DIS_TAKEN_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_TAKEN_SEC_G NUMBER

Total discounts taken on unpaid invoices in secondary currency
OPEN_DIS_TAKEN_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_LOST_B NUMBER

Total discounts lost on unpaid invoices in base currency
OPEN_DIS_LOST_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_LOST_PRIM_G NUMBER

Total discounts lost on unpaid invoices in primary currency
OPEN_DIS_LOST_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DISCOUNT_LOST_SEC_G NUMBER

Total discounts lost on unpaid invoices in secondary currency
OPEN_DIS_LOST_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET1_B NUMBER

Total unpaid invoice amounts Due After 30 Days in base currency
OPEN_DUE_BKT1_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET1_PRIM_G NUMBER

Total unpaid invoice amount Due After 30 Days in primary currency
OPEN_DUE_BKT1_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET1_SEC_G NUMBER

Total unpaid invoice amounts Due After 30 Days in secondary currency
OPEN_DUE_BKT1_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET1_COUNT NUMBER

Total number of unpaid invoices Due After 30 Days
OPEN_DUE_BKT1_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET2_B NUMBER

Total unpaid invoice amounts Due in 16 - 30 Days in base currency
OPEN_DUE_BKT2_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET2_PRIM_G NUMBER

Total unpaid invoice amounts Due in 16 - 30 Days in primary currency
OPEN_DUE_BKT2_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET2_SEC_G NUMBER

Total unpaid invoice amounts Due in 16 - 30 Days in secondary currency
OPEN_DUE_BKT2_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET2_COUNT NUMBER

Total number of unpaid invoices Due in 16 - 30 Days
OPEN_DUE_BKT2_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET3_B NUMBER

Total unpaid invoice amounts Due in 1 - 15 Days in base currency
OPEN_DUE_BKT3_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET3_PRIM_G NUMBER

Total unpaid invoice amounts Due in 1 - 15 Days in primary currency
OPEN_DUE_BKT3_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET3_SEC_G NUMBER

Total unpaid invoice amounts Due in 1 - 15 Days in secondary currency
OPEN_DUE_BKT3_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET3_COUNT NUMBER

Total number of unpaid invoices Due in 1 - 15 Days
OPEN_DUE_BKT3_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET1_B NUMBER

Total unpaid invoice amounts Past Due After 30 Days in base currency
OPEN_PAST_DUE_BKT1_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET1_PRIM_G NUMBER

Total unpaid invoice amounts Past Due After 30 Days in primary currency
OPEN_PAST_DUE_BKT1_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET1_SEC_G NUMBER

Total unpaid invoice amounts Past Due After 30 Days in secondary currency
OPEN_PAST_DUE_BKT1_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET1_COUNT NUMBER

Total number of unpaid invoices Past Due After 30 Days
OPEN_PAST_DUE_BKT1_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET2_B NUMBER

Total unpaid invoice amounts Past Due in 16 - 30 Days in base currency
OPEN_PAST_DUE_BKT2_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET2_PRIM_G NUMBER

Total unpaid invoice amounts Past Due in 16 - 30 Days in primary currency
OPEN_PAST_DUE_BKT2_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET2_SEC_G NUMBER

Total unpaid invoice amounts Past Due in 16 - 30 Days in secondary currency
OPEN_PAST_DUE_BKT2_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET2_COUNT NUMBER

Total number of unpaid invoices Past Due in 16 - 30 Days
OPEN_PAST_DUE_BKT2_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET3_B NUMBER

Total unpaid invoice amounts Past Due in 1 - 15 Days in base currency
OPEN_PAST_DUE_BKT3_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET3_PRIM_G NUMBER

Total unpaid invoice amounts Past Due in 1 - 15 Days in primary currency
OPEN_PAST_DUE_BKT3_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET3_SEC_G NUMBER

Total unpaid invoice amounts Past Due in 1 - 15 Days in secondary currency
OPEN_PAST_DUE_BKT3_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_PAST_DUE_BUCKET3_COUNT NUMBER

Total number of unpaid invoices Past Due in 1 - 15 Days
OPEN_PAST_DUE_BKT3_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
ON_TIME_PAYMENT_AMT_B NUMBER

Total on time payment amounts in base currency
ON_TIME_PAYMENT_AMT_B_CNT NUMBER

Internal aggregation for fast MV refresh
ON_TIME_PAYMENT_AMT_PRIM_G NUMBER

Total on time payment amounts in primary currency
ON_TIME_PAYMENT_AMT_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
ON_TIME_PAYMENT_AMT_SEC_G NUMBER

Total on time payment amounts in secondary currency
ON_TIME_PAYMENT_AMT_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
LATE_PAYMENT_AMT_B NUMBER

Total late payment amounts in base currency
LATE_PAYMENT_AMT_B_CNT NUMBER

Internal aggregation for fast MV refresh
LATE_PAYMENT_AMT_PRIM_G NUMBER

Total late payment amounts in primary currency
LATE_PAYMENT_AMT_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
LATE_PAYMENT_AMT_SEC_G NUMBER

Total late payment amounts in secondary currency
LATE_PAYMENT_AMT_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
WT_OPEN_DUE_AMT_B NUMBER

Total weighted unpaid due amount in base currency
WT_OPEN_DUE_AMT_B_CNT NUMBER

Internal aggregation for fast MV refresh
WT_OPEN_DUE_AMT_PRIM_G NUMBER

Total weighted unpaid due amount in primary currency
WT_OPEN_DUE_AMT_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
WT_OPEN_DUE_AMT_SEC_G NUMBER

Total weighted unpaid due amount in secondary currency
WT_OPEN_DUE_AMT_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
WT_OPEN_PAST_DUE_AMT_B NUMBER

Total weighted unpaid past due amount in base currency
WT_OPEN_PAST_DUE_AMT_B_CNT NUMBER

Internal aggregation for fast MV refresh
WT_OPEN_PAST_DUE_AMT_PRIM_G NUMBER

Total weighted unpaid past due amount in primary currency
WT_OP_PAST_DUE_AMT_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
WT_OPEN_PAST_DUE_AMT_SEC_G NUMBER

Total weighted unpaid past due amount in secondary currency
WT_OPEN_PAST_DUE_AMT_SEC_G_CNT NUMBER

Internal aggregation 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
,      COUNT_ALL
,      OPEN_AMT_B
,      OPEN_AMT_B_CNT
,      OPEN_AMT_PRIM_G
,      OPEN_AMT_PRIM_G_CNT
,      OPEN_AMT_SEC_G
,      OPEN_AMT_SEC_G_CNT
,      OPEN_COUNT
,      OPEN_COUNT_CNT
,      OPEN_DUE_COUNT
,      OPEN_DUE_COUNT_CNT
,      OPEN_PAST_DUE_AMT_B
,      OPEN_PAST_DUE_AMT_B_CNT
,      OPEN_PAST_DUE_AMT_PRIM_G
,      OPEN_PAST_DUE_AMT_PRIM_G_CNT
,      OPEN_PAST_DUE_AMT_SEC_G
,      OPEN_PAST_DUE_AMT_SEC_G_CNT
,      OPEN_PAST_DUE_COUNT
,      OPEN_PAST_DUE_COUNT_CNT
,      OPEN_PAYMENT_AMT_B
,      OPEN_PAYMENT_AMT_B_CNT
,      OPEN_PAYMENT_AMT_PRIM_G
,      OPEN_PAYMENT_AMT_PRIM_G_CNT
,      OPEN_PAYMENT_AMT_SEC_G
,      OPEN_PAYMENT_AMT_SEC_G_CNT
,      OPEN_DISCOUNT_OFFERED_B
,      OPEN_DISCOUNT_OFFERED_B_CNT
,      OPEN_DISCOUNT_OFFERED_PRIM_G
,      OPEN_DIS_OFFERED_PRIM_G_CNT
,      OPEN_DISCOUNT_OFFERED_SEC_G
,      OPEN_DIS_OFFERED_SEC_G_CNT
,      OPEN_DISCOUNT_REMAINING_B
,      OPEN_DIS_REMAINING_B_CNT
,      OPEN_DISCOUNT_REMAINING_PRIM_G
,      OPEN_DIS_REMAINING_PRIM_G_CNT
,      OPEN_DISCOUNT_REMAINING_SEC_G
,      OPEN_DIS_REMAINING_SEC_G_CNT
,      OPEN_DISCOUNT_TAKEN_B
,      OPEN_DIS_TAKEN_B_CNT
,      OPEN_DISCOUNT_TAKEN_PRIM_G
,      OPEN_DIS_TAKEN_PRIM_G_CNT
,      OPEN_DISCOUNT_TAKEN_SEC_G
,      OPEN_DIS_TAKEN_SEC_G_CNT
,      OPEN_DISCOUNT_LOST_B
,      OPEN_DIS_LOST_B_CNT
,      OPEN_DISCOUNT_LOST_PRIM_G
,      OPEN_DIS_LOST_PRIM_G_CNT
,      OPEN_DISCOUNT_LOST_SEC_G
,      OPEN_DIS_LOST_SEC_G_CNT
,      OPEN_DUE_BUCKET1_B
,      OPEN_DUE_BKT1_B_CNT
,      OPEN_DUE_BUCKET1_PRIM_G
,      OPEN_DUE_BKT1_PRIM_G_CNT
,      OPEN_DUE_BUCKET1_SEC_G
,      OPEN_DUE_BKT1_SEC_G_CNT
,      OPEN_DUE_BUCKET1_COUNT
,      OPEN_DUE_BKT1_COUNT_CNT
,      OPEN_DUE_BUCKET2_B
,      OPEN_DUE_BKT2_B_CNT
,      OPEN_DUE_BUCKET2_PRIM_G
,      OPEN_DUE_BKT2_PRIM_G_CNT
,      OPEN_DUE_BUCKET2_SEC_G
,      OPEN_DUE_BKT2_SEC_G_CNT
,      OPEN_DUE_BUCKET2_COUNT
,      OPEN_DUE_BKT2_COUNT_CNT
,      OPEN_DUE_BUCKET3_B
,      OPEN_DUE_BKT3_B_CNT
,      OPEN_DUE_BUCKET3_PRIM_G
,      OPEN_DUE_BKT3_PRIM_G_CNT
,      OPEN_DUE_BUCKET3_SEC_G
,      OPEN_DUE_BKT3_SEC_G_CNT
,      OPEN_DUE_BUCKET3_COUNT
,      OPEN_DUE_BKT3_COUNT_CNT
,      OPEN_PAST_DUE_BUCKET1_B
,      OPEN_PAST_DUE_BKT1_B_CNT
,      OPEN_PAST_DUE_BUCKET1_PRIM_G
,      OPEN_PAST_DUE_BKT1_PRIM_G_CNT
,      OPEN_PAST_DUE_BUCKET1_SEC_G
,      OPEN_PAST_DUE_BKT1_SEC_G_CNT
,      OPEN_PAST_DUE_BUCKET1_COUNT
,      OPEN_PAST_DUE_BKT1_COUNT_CNT
,      OPEN_PAST_DUE_BUCKET2_B
,      OPEN_PAST_DUE_BKT2_B_CNT
,      OPEN_PAST_DUE_BUCKET2_PRIM_G
,      OPEN_PAST_DUE_BKT2_PRIM_G_CNT
,      OPEN_PAST_DUE_BUCKET2_SEC_G
,      OPEN_PAST_DUE_BKT2_SEC_G_CNT
,      OPEN_PAST_DUE_BUCKET2_COUNT
,      OPEN_PAST_DUE_BKT2_COUNT_CNT
,      OPEN_PAST_DUE_BUCKET3_B
,      OPEN_PAST_DUE_BKT3_B_CNT
,      OPEN_PAST_DUE_BUCKET3_PRIM_G
,      OPEN_PAST_DUE_BKT3_PRIM_G_CNT
,      OPEN_PAST_DUE_BUCKET3_SEC_G
,      OPEN_PAST_DUE_BKT3_SEC_G_CNT
,      OPEN_PAST_DUE_BUCKET3_COUNT
,      OPEN_PAST_DUE_BKT3_COUNT_CNT
,      ON_TIME_PAYMENT_AMT_B
,      ON_TIME_PAYMENT_AMT_B_CNT
,      ON_TIME_PAYMENT_AMT_PRIM_G
,      ON_TIME_PAYMENT_AMT_PRIM_G_CNT
,      ON_TIME_PAYMENT_AMT_SEC_G
,      ON_TIME_PAYMENT_AMT_SEC_G_CNT
,      LATE_PAYMENT_AMT_B
,      LATE_PAYMENT_AMT_B_CNT
,      LATE_PAYMENT_AMT_PRIM_G
,      LATE_PAYMENT_AMT_PRIM_G_CNT
,      LATE_PAYMENT_AMT_SEC_G
,      LATE_PAYMENT_AMT_SEC_G_CNT
,      WT_OPEN_DUE_AMT_B
,      WT_OPEN_DUE_AMT_B_CNT
,      WT_OPEN_DUE_AMT_PRIM_G
,      WT_OPEN_DUE_AMT_PRIM_G_CNT
,      WT_OPEN_DUE_AMT_SEC_G
,      WT_OPEN_DUE_AMT_SEC_G_CNT
,      WT_OPEN_PAST_DUE_AMT_B
,      WT_OPEN_PAST_DUE_AMT_B_CNT
,      WT_OPEN_PAST_DUE_AMT_PRIM_G
,      WT_OP_PAST_DUE_AMT_PRIM_G_CNT
,      WT_OPEN_PAST_DUE_AMT_SEC_G
,      WT_OPEN_PAST_DUE_AMT_SEC_G_CNT
FROM APPS.FII_AP_LIA_IB_MV;

Dependencies

[top of page]

APPS.FII_AP_LIA_IB_MV does not reference any database object

APPS.FII_AP_LIA_IB_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_LIA_IB_MV
Materialized ViewFII_AP_LIA_KPI_MV