[Home] [Help] [Dependency Information]
Object Name: | MLOG$_FII_AP_INV_B |
---|---|
Object Type: | TABLE |
Owner: | FII |
Subobject Name: | |
Status: | VALID |
snapshot log for master table FII.FII_AP_INV_B
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_DATE | DATE | |||
ACCOUNT_DATE_ID | NUMBER | |||
AMOUNT_B | NUMBER | |||
AMOUNT_T | NUMBER | |||
APPROVED_FLAG | VARCHAR2 | (1) | ||
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | ||
COST_CENTER_ORG_ID | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
DIST_COUNT | NUMBER | |||
FIN_CATEGORY_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 | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
POSTED_FLAG | VARCHAR2 | (1) | ||
PO_MATCHED_FLAG | VARCHAR2 | (1) | ||
PRIM_AMOUNT_G | NUMBER | |||
SEC_AMOUNT_G | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
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) | ||
LEDGER_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_DATE
, ACCOUNT_DATE_ID
, AMOUNT_B
, AMOUNT_T
, APPROVED_FLAG
, CHART_OF_ACCOUNTS_ID
, COST_CENTER_ORG_ID
, CREATED_BY
, CREATION_DATE
, DIST_COUNT
, FIN_CATEGORY_ID
, INVOICE_ID
, INVOICE_TYPE
, INV_CURRENCY_CODE
, INV_DIST_CREATED_BY
, INV_DIST_CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, POSTED_FLAG
, PO_MATCHED_FLAG
, PRIM_AMOUNT_G
, SEC_AMOUNT_G
, SET_OF_BOOKS_ID
, SOURCE
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, UPDATE_SEQUENCE
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
, LEDGER_ID
FROM FII.MLOG$_FII_AP_INV_B;
FII.MLOG$_FII_AP_INV_B does not reference any database object
FII.MLOG$_FII_AP_INV_B is referenced by following:
|
|
|