eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: FII.MLOG$_FII_AP_INVOICE_B

Object Details

Object Name:	MLOG$_FII_AP_INVOICE_B
Object Type:	TABLE
Owner:	FII
Subobject Name:
Status:	VALID

snapshot log for master table FII.FII_AP_INVOICE_B

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
BASE_AMOUNT	NUMBER
CANCEL_FLAG	VARCHAR2	(1)
DIST_COUNT	NUMBER	(15)
ENTERED_DATE	DATE
E_INVOICES_FLAG	VARCHAR2	(1)
FULLY_PAID_DATE	DATE
INVOICE_TYPE	VARCHAR2	(25)
ORG_ID	NUMBER	(15)
PRIM_AMOUNT	NUMBER
SEC_AMOUNT	NUMBER
SOURCE	VARCHAR2	(25)
SUPPLIER_ID	NUMBER	(15)
M_ROW$$	VARCHAR2	(255)
SEQUENCE$$	NUMBER
SNAPTIME$$	DATE
DMLTYPE$$	VARCHAR2	(1)
OLD_NEW$$	VARCHAR2	(1)
CHANGE_VECTOR$$	RAW	(255)
FULLY_PAID_AMOUNT	NUMBER
FULLY_PAID_AMOUNT_B	NUMBER
INVOICE_ID	NUMBER	(15)
INVOICE_NUMBER	VARCHAR2	(50)
PAYMENT_STATUS_FLAG	VARCHAR2	(1)
PRIM_FULLY_PAID_AMOUNT	NUMBER
SEC_FULLY_PAID_AMOUNT	NUMBER
INVOICE_CURRENCY_CODE	VARCHAR2	(25)
PAYMENT_CURRENCY_CODE	VARCHAR2	(25)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BASE_AMOUNT
,      CANCEL_FLAG
,      DIST_COUNT
,      ENTERED_DATE
,      E_INVOICES_FLAG
,      FULLY_PAID_DATE
,      INVOICE_TYPE
,      ORG_ID
,      PRIM_AMOUNT
,      SEC_AMOUNT
,      SOURCE
,      SUPPLIER_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
,      FULLY_PAID_AMOUNT
,      FULLY_PAID_AMOUNT_B
,      INVOICE_ID
,      INVOICE_NUMBER
,      PAYMENT_STATUS_FLAG
,      PRIM_FULLY_PAID_AMOUNT
,      SEC_FULLY_PAID_AMOUNT
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
FROM FII.MLOG$_FII_AP_INVOICE_B;

Dependencies

[top of page]

FII.MLOG$_FII_AP_INVOICE_B does not reference any database object

FII.MLOG$_FII_AP_INVOICE_B is referenced by following:

APPS: MLOG$_FII_AP_INVOICE_B