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

MATERIALIZED VIEW: APPS.FII_AP_LIA_I_MV

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

FII_AP_LIA_B_MV
     FII_AP_AGING_BKTS_B
     FII_AP_DUE_COUNTS_B
     FII_AP_INVOICE_B
     FII_AP_PAY_SCHED_B
FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Operating Unit Identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

FII week Identifier
REPORT_DATE_JULIAN NUMBER

Reporting date in Julian format
TIME_ID NUMBER

Time identifier
PERIOD_TYPE_ID NUMBER

Period type identifier
COUNT_ALL NUMBER

Internal aggregation for fast MV refresh
OPEN_AMT_B NUMBER

Total unpaid invoice amount in base currency
OPEN_AMT_B_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_AMT_PRIM_G NUMBER

Total unpaid invoice amount in primary currency
OPEN_AMT_PRIM_G_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_AMT_SEC_G NUMBER

Total unpaid invoice amount 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 amount 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 amount 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 past due unpaid invoices
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 refresj
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 open 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 open 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 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 invoice amounts 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 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 invoices Due After 30 Days
OPEN_DUE_BKT1_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET2_B NUMBER

Total 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 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 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 invoices Due in 16 - 30 Days
OPEN_DUE_BKT2_COUNT_CNT NUMBER

Internal aggregation for fast MV refresh
OPEN_DUE_BUCKET3_B NUMBER

Total 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 amount 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 amount 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 amount 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 amount in base currency
LATE_PAYMENT_AMT_B_CNT NUMBER

Internal aggregation for fast MV refresh
LATE_PAYMENT_AMT_PRIM_G NUMBER

Total late payment amount 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 amount in secondary currency
LATE_PAYMENT_AMT_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
WT_OPEN_DUE_AMT_B NUMBER

Total weighted 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 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 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 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 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 past due amount in secondary currency
WT_OPEN_PAST_DUE_AMT_SEC_G_CNT NUMBER

Internal aggregation for fast MV refresh
GID1 NUMBER

Grouping Identifier
Query Text

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


SELECT ORG_ID
,      SUPPLIER_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      TIME_ID
,      PERIOD_TYPE_ID
,      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
,      GID1
FROM APPS.FII_AP_LIA_I_MV;

Dependencies

[top of page]

APPS.FII_AP_LIA_I_MV references the following:

SchemaAPPS
TableFII_AP_LIA_B_MV
Materialized ViewFII_AP_LIA_B_MV
TableFII_AP_LIA_I_MV
SchemaFII
TableFII_TIME_DAY
APPS.FII_AP_LIA_I_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_LIA_IB_MV