[Home] [Help] [Dependency Information]
Object Name: | MLOG$_FII_AP_INV_DIST_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
Subobject Name: | |
Status: | VALID |
snapshot log for master table FII.FII_AP_INV_DIST_F
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_DATE | DATE | |||
AMOUNT_B | NUMBER | |||
APPROVED_FLAG | VARCHAR2 | (1) | ||
COMPANY_ID | NUMBER | (15) | ||
COST_CENTER_ID | NUMBER | (15) | ||
DIST_COUNT | NUMBER | |||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | ||
INVOICE_ID | NUMBER | (15) | ||
INVOICE_TYPE | VARCHAR2 | (25) | ||
INV_CURRENCY_CODE | VARCHAR2 | (15) | ||
INV_DIST_CREATED_BY | NUMBER | (15) | ||
INV_DIST_CREATION_DATE | DATE | |||
LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | ||
ORG_ID | NUMBER | (15) | ||
POSTED_FLAG | VARCHAR2 | (1) | ||
PO_DISTRIBUTION_ID | NUMBER | (15) | ||
PO_MATCHED_FLAG | VARCHAR2 | (1) | ||
PRIM_AMOUNT_G | NUMBER | |||
SEC_AMOUNT_G | NUMBER | |||
SOURCE | VARCHAR2 | (25) | ||
SUPPLIER_ID | NUMBER | (15) | ||
SUPPLIER_SITE_ID | NUMBER | |||
UPDATE_SEQUENCE | 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 ACCOUNT_DATE
, AMOUNT_B
, APPROVED_FLAG
, COMPANY_ID
, COST_CENTER_ID
, DIST_COUNT
, INVOICE_DISTRIBUTION_ID
, INVOICE_ID
, INVOICE_TYPE
, INV_CURRENCY_CODE
, INV_DIST_CREATED_BY
, INV_DIST_CREATION_DATE
, LINE_TYPE_LOOKUP_CODE
, ORG_ID
, POSTED_FLAG
, PO_DISTRIBUTION_ID
, PO_MATCHED_FLAG
, PRIM_AMOUNT_G
, SEC_AMOUNT_G
, SOURCE
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, UPDATE_SEQUENCE
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM FII.MLOG$_FII_AP_INV_DIST_F;
FII.MLOG$_FII_AP_INV_DIST_F does not reference any database object
FII.MLOG$_FII_AP_INV_DIST_F is referenced by following:
|
|
|