[Home] [Help] [Dependency Information]
Object Name: | MLOG$_FII_AP_LIA_B_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
snapshot log for master table APPS.FII_AP_LIA_B_MV
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISCOUNT_LOST_B | NUMBER | |||
DISCOUNT_OFFERED_B | NUMBER | |||
DISCOUNT_REMAINING_B | NUMBER | |||
DISCOUNT_TAKEN_B | NUMBER | |||
DUE_BUCKET1_B | NUMBER | |||
DUE_BUCKET1_COUNT | NUMBER | |||
DUE_BUCKET2_B | NUMBER | |||
DUE_BUCKET2_COUNT | NUMBER | |||
DUE_BUCKET3_B | NUMBER | |||
DUE_BUCKET3_COUNT | NUMBER | |||
DUE_COUNT | NUMBER | |||
LATE_PAYMENT_AMT_B | NUMBER | |||
ON_TIME_PAYMENT_AMT_B | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
PAST_DUE_AMT_B | NUMBER | |||
PAST_DUE_BUCKET1_B | NUMBER | |||
PAST_DUE_BUCKET1_COUNT | NUMBER | |||
PAST_DUE_BUCKET2_B | NUMBER | |||
PAST_DUE_BUCKET2_COUNT | NUMBER | |||
PAST_DUE_BUCKET3_B | NUMBER | |||
PAST_DUE_BUCKET3_COUNT | NUMBER | |||
PAST_DUE_COUNT | NUMBER | |||
PAYMENT_AMT_B | NUMBER | |||
PRIM_DISCOUNT_LOST | NUMBER | |||
PRIM_DISCOUNT_OFFERED | NUMBER | |||
PRIM_DISCOUNT_REMAINING | NUMBER | |||
PRIM_DISCOUNT_TAKEN | NUMBER | |||
PRIM_DUE_BUCKET1 | NUMBER | |||
PRIM_DUE_BUCKET2 | NUMBER | |||
PRIM_DUE_BUCKET3 | NUMBER | |||
PRIM_LATE_PAYMENT_AMT | NUMBER | |||
PRIM_ON_TIME_PAYMENT_AMT | NUMBER | |||
PRIM_PAST_DUE_AMT | NUMBER | |||
PRIM_PAST_DUE_BUCKET1 | NUMBER | |||
PRIM_PAST_DUE_BUCKET2 | NUMBER | |||
PRIM_PAST_DUE_BUCKET3 | NUMBER | |||
PRIM_PAYMENT_AMT | NUMBER | |||
PRIM_UNPAID_AMT | NUMBER | |||
SEC_DISCOUNT_LOST | NUMBER | |||
SEC_DISCOUNT_OFFERED | NUMBER | |||
SEC_DISCOUNT_REMAINING | NUMBER | |||
SEC_DISCOUNT_TAKEN | NUMBER | |||
SEC_DUE_BUCKET1 | NUMBER | |||
SEC_DUE_BUCKET2 | NUMBER | |||
SEC_DUE_BUCKET3 | NUMBER | |||
SEC_LATE_PAYMENT_AMT | NUMBER | |||
SEC_ON_TIME_PAYMENT_AMT | NUMBER | |||
SEC_PAST_DUE_AMT | NUMBER | |||
SEC_PAST_DUE_BUCKET1 | NUMBER | |||
SEC_PAST_DUE_BUCKET2 | NUMBER | |||
SEC_PAST_DUE_BUCKET3 | NUMBER | |||
SEC_PAYMENT_AMT | NUMBER | |||
SEC_UNPAID_AMT | NUMBER | |||
SUPPLIER_ID | NUMBER | (15) | ||
TIME_ID | NUMBER | |||
UNPAID_AMT_B | NUMBER | |||
UNPAID_COUNT | 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 DISCOUNT_LOST_B
, DISCOUNT_OFFERED_B
, DISCOUNT_REMAINING_B
, DISCOUNT_TAKEN_B
, DUE_BUCKET1_B
, DUE_BUCKET1_COUNT
, DUE_BUCKET2_B
, DUE_BUCKET2_COUNT
, DUE_BUCKET3_B
, DUE_BUCKET3_COUNT
, DUE_COUNT
, LATE_PAYMENT_AMT_B
, ON_TIME_PAYMENT_AMT_B
, ORG_ID
, PAST_DUE_AMT_B
, PAST_DUE_BUCKET1_B
, PAST_DUE_BUCKET1_COUNT
, PAST_DUE_BUCKET2_B
, PAST_DUE_BUCKET2_COUNT
, PAST_DUE_BUCKET3_B
, PAST_DUE_BUCKET3_COUNT
, PAST_DUE_COUNT
, PAYMENT_AMT_B
, PRIM_DISCOUNT_LOST
, PRIM_DISCOUNT_OFFERED
, PRIM_DISCOUNT_REMAINING
, PRIM_DISCOUNT_TAKEN
, PRIM_DUE_BUCKET1
, PRIM_DUE_BUCKET2
, PRIM_DUE_BUCKET3
, PRIM_LATE_PAYMENT_AMT
, PRIM_ON_TIME_PAYMENT_AMT
, PRIM_PAST_DUE_AMT
, PRIM_PAST_DUE_BUCKET1
, PRIM_PAST_DUE_BUCKET2
, PRIM_PAST_DUE_BUCKET3
, PRIM_PAYMENT_AMT
, PRIM_UNPAID_AMT
, SEC_DISCOUNT_LOST
, SEC_DISCOUNT_OFFERED
, SEC_DISCOUNT_REMAINING
, SEC_DISCOUNT_TAKEN
, SEC_DUE_BUCKET1
, SEC_DUE_BUCKET2
, SEC_DUE_BUCKET3
, SEC_LATE_PAYMENT_AMT
, SEC_ON_TIME_PAYMENT_AMT
, SEC_PAST_DUE_AMT
, SEC_PAST_DUE_BUCKET1
, SEC_PAST_DUE_BUCKET2
, SEC_PAST_DUE_BUCKET3
, SEC_PAYMENT_AMT
, SEC_UNPAID_AMT
, SUPPLIER_ID
, TIME_ID
, UNPAID_AMT_B
, UNPAID_COUNT
, 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_B_MV;
APPS.MLOG$_FII_AP_LIA_B_MV does not reference any database object
APPS.MLOG$_FII_AP_LIA_B_MV is not referenced by any database object
|
|
|