[Home] [Help] [Dependency Information]
Object Name: | FII_AP_LIA_I_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.FII_AP_LIA_I_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_FII_AP_LIA_I_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY |
SYS_OP_MAP_NONNULL("ORG_ID")
SYS_OP_MAP_NONNULL("SUPPLIER_ID") SYS_OP_MAP_NONNULL("ENT_YEAR_ID") SYS_OP_MAP_NONNULL("ENT_QTR_ID") SYS_OP_MAP_NONNULL("ENT_PERIOD_ID") SYS_OP_MAP_NONNULL("WEEK_ID") SYS_OP_MAP_NONNULL("REPORT_DATE_JULIAN") SYS_OP_MAP_NONNULL("GID1") |
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;
APPS.FII_AP_LIA_I_MV does not reference any database object
APPS.FII_AP_LIA_I_MV is referenced by following:
|
|
|