[Home] [Help] [Dependency Information]
Object Name: | MLOG$_FII_AP_LIA_I_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
snapshot log for master table APPS.FII_AP_LIA_I_MV
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COUNT_ALL | NUMBER | |||
LATE_PAYMENT_AMT_B | NUMBER | |||
LATE_PAYMENT_AMT_PRIM_G | NUMBER | |||
LATE_PAYMENT_AMT_SEC_G | NUMBER | |||
ON_TIME_PAYMENT_AMT_B | NUMBER | |||
ON_TIME_PAYMENT_AMT_PRIM_G | NUMBER | |||
ON_TIME_PAYMENT_AMT_SEC_G | NUMBER | |||
OPEN_AMT_B | NUMBER | |||
OPEN_AMT_PRIM_G | NUMBER | |||
OPEN_AMT_SEC_G | NUMBER | |||
OPEN_COUNT | NUMBER | |||
OPEN_DISCOUNT_LOST_B | NUMBER | |||
OPEN_DISCOUNT_LOST_PRIM_G | NUMBER | |||
OPEN_DISCOUNT_LOST_SEC_G | NUMBER | |||
OPEN_DISCOUNT_OFFERED_B | NUMBER | |||
OPEN_DISCOUNT_OFFERED_PRIM_G | NUMBER | |||
OPEN_DISCOUNT_OFFERED_SEC_G | NUMBER | |||
OPEN_DISCOUNT_REMAINING_B | NUMBER | |||
OPEN_DISCOUNT_REMAINING_PRIM_G | NUMBER | |||
OPEN_DISCOUNT_REMAINING_SEC_G | NUMBER | |||
OPEN_DISCOUNT_TAKEN_B | NUMBER | |||
OPEN_DISCOUNT_TAKEN_PRIM_G | NUMBER | |||
OPEN_DISCOUNT_TAKEN_SEC_G | NUMBER | |||
OPEN_DUE_BUCKET1_B | NUMBER | |||
OPEN_DUE_BUCKET1_COUNT | NUMBER | |||
OPEN_DUE_BUCKET1_PRIM_G | NUMBER | |||
OPEN_DUE_BUCKET1_SEC_G | NUMBER | |||
OPEN_DUE_BUCKET2_B | NUMBER | |||
OPEN_DUE_BUCKET2_COUNT | NUMBER | |||
OPEN_DUE_BUCKET2_PRIM_G | NUMBER | |||
OPEN_DUE_BUCKET2_SEC_G | NUMBER | |||
OPEN_DUE_BUCKET3_B | NUMBER | |||
OPEN_DUE_BUCKET3_COUNT | NUMBER | |||
OPEN_DUE_BUCKET3_PRIM_G | NUMBER | |||
OPEN_DUE_BUCKET3_SEC_G | NUMBER | |||
OPEN_DUE_COUNT | NUMBER | |||
OPEN_PAST_DUE_AMT_B | NUMBER | |||
OPEN_PAST_DUE_AMT_PRIM_G | NUMBER | |||
OPEN_PAST_DUE_AMT_SEC_G | NUMBER | |||
OPEN_PAST_DUE_BUCKET1_B | NUMBER | |||
OPEN_PAST_DUE_BUCKET1_COUNT | NUMBER | |||
OPEN_PAST_DUE_BUCKET1_PRIM_G | NUMBER | |||
OPEN_PAST_DUE_BUCKET1_SEC_G | NUMBER | |||
OPEN_PAST_DUE_BUCKET2_B | NUMBER | |||
OPEN_PAST_DUE_BUCKET2_COUNT | NUMBER | |||
OPEN_PAST_DUE_BUCKET2_PRIM_G | NUMBER | |||
OPEN_PAST_DUE_BUCKET2_SEC_G | NUMBER | |||
OPEN_PAST_DUE_BUCKET3_B | NUMBER | |||
OPEN_PAST_DUE_BUCKET3_COUNT | NUMBER | |||
OPEN_PAST_DUE_BUCKET3_PRIM_G | NUMBER | |||
OPEN_PAST_DUE_BUCKET3_SEC_G | NUMBER | |||
OPEN_PAST_DUE_COUNT | NUMBER | |||
OPEN_PAYMENT_AMT_B | NUMBER | |||
OPEN_PAYMENT_AMT_PRIM_G | NUMBER | |||
OPEN_PAYMENT_AMT_SEC_G | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
PERIOD_TYPE_ID | NUMBER | |||
SUPPLIER_ID | NUMBER | (15) | ||
TIME_ID | NUMBER | |||
WT_OPEN_DUE_AMT_B | NUMBER | |||
WT_OPEN_DUE_AMT_PRIM_G | NUMBER | |||
WT_OPEN_DUE_AMT_SEC_G | NUMBER | |||
WT_OPEN_PAST_DUE_AMT_B | NUMBER | |||
WT_OPEN_PAST_DUE_AMT_PRIM_G | NUMBER | |||
WT_OPEN_PAST_DUE_AMT_SEC_G | NUMBER | |||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) |
Cut, paste (and edit) the following text to query this object:
SELECT COUNT_ALL
, LATE_PAYMENT_AMT_B
, LATE_PAYMENT_AMT_PRIM_G
, LATE_PAYMENT_AMT_SEC_G
, ON_TIME_PAYMENT_AMT_B
, ON_TIME_PAYMENT_AMT_PRIM_G
, ON_TIME_PAYMENT_AMT_SEC_G
, OPEN_AMT_B
, OPEN_AMT_PRIM_G
, OPEN_AMT_SEC_G
, OPEN_COUNT
, OPEN_DISCOUNT_LOST_B
, OPEN_DISCOUNT_LOST_PRIM_G
, OPEN_DISCOUNT_LOST_SEC_G
, OPEN_DISCOUNT_OFFERED_B
, OPEN_DISCOUNT_OFFERED_PRIM_G
, OPEN_DISCOUNT_OFFERED_SEC_G
, OPEN_DISCOUNT_REMAINING_B
, OPEN_DISCOUNT_REMAINING_PRIM_G
, OPEN_DISCOUNT_REMAINING_SEC_G
, OPEN_DISCOUNT_TAKEN_B
, OPEN_DISCOUNT_TAKEN_PRIM_G
, OPEN_DISCOUNT_TAKEN_SEC_G
, OPEN_DUE_BUCKET1_B
, OPEN_DUE_BUCKET1_COUNT
, OPEN_DUE_BUCKET1_PRIM_G
, OPEN_DUE_BUCKET1_SEC_G
, OPEN_DUE_BUCKET2_B
, OPEN_DUE_BUCKET2_COUNT
, OPEN_DUE_BUCKET2_PRIM_G
, OPEN_DUE_BUCKET2_SEC_G
, OPEN_DUE_BUCKET3_B
, OPEN_DUE_BUCKET3_COUNT
, OPEN_DUE_BUCKET3_PRIM_G
, OPEN_DUE_BUCKET3_SEC_G
, OPEN_DUE_COUNT
, OPEN_PAST_DUE_AMT_B
, OPEN_PAST_DUE_AMT_PRIM_G
, OPEN_PAST_DUE_AMT_SEC_G
, OPEN_PAST_DUE_BUCKET1_B
, OPEN_PAST_DUE_BUCKET1_COUNT
, OPEN_PAST_DUE_BUCKET1_PRIM_G
, OPEN_PAST_DUE_BUCKET1_SEC_G
, OPEN_PAST_DUE_BUCKET2_B
, OPEN_PAST_DUE_BUCKET2_COUNT
, OPEN_PAST_DUE_BUCKET2_PRIM_G
, OPEN_PAST_DUE_BUCKET2_SEC_G
, OPEN_PAST_DUE_BUCKET3_B
, OPEN_PAST_DUE_BUCKET3_COUNT
, OPEN_PAST_DUE_BUCKET3_PRIM_G
, OPEN_PAST_DUE_BUCKET3_SEC_G
, OPEN_PAST_DUE_COUNT
, OPEN_PAYMENT_AMT_B
, OPEN_PAYMENT_AMT_PRIM_G
, OPEN_PAYMENT_AMT_SEC_G
, ORG_ID
, PERIOD_TYPE_ID
, SUPPLIER_ID
, TIME_ID
, WT_OPEN_DUE_AMT_B
, WT_OPEN_DUE_AMT_PRIM_G
, WT_OPEN_DUE_AMT_SEC_G
, WT_OPEN_PAST_DUE_AMT_B
, WT_OPEN_PAST_DUE_AMT_PRIM_G
, WT_OPEN_PAST_DUE_AMT_SEC_G
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM APPS.MLOG$_FII_AP_LIA_I_MV;
APPS.MLOG$_FII_AP_LIA_I_MV does not reference any database object
APPS.MLOG$_FII_AP_LIA_I_MV is not referenced by any database object
|
|
|