[Home] [Help] [Dependency Information]
Object Name: | FII_AP_LIA_I_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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 |
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
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 |
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;
|
|
|