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_AR_TRANSACTIONS_

Object Details

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

snapshot log for master table FII.FII_AR_TRANSACTIONS_F

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
AMOUNT_DUE_ORIGINAL_FUNC	NUMBER
AMOUNT_DUE_ORIGINAL_PRIM	NUMBER
AMOUNT_DUE_ORIGINAL_SEC	NUMBER
AMOUNT_DUE_ORIGINAL_TRX	NUMBER
AR_CREATION_DATE	DATE
BATCH_SOURCE_ID	NUMBER	(15)
BILL_TO_CUSTOMER_ID	NUMBER	(15)
BILL_TO_SITE_USE_ID	NUMBER	(15)
BR_BA_AMOUNT_FUNC	NUMBER
BR_BA_AMOUNT_PRIM	NUMBER
BR_BA_AMOUNT_SEC	NUMBER
BR_BA_COUNT	NUMBER
CB_BA_AMOUNT_FUNC	NUMBER
CB_BA_AMOUNT_PRIM	NUMBER
CB_BA_AMOUNT_SEC	NUMBER
CB_BA_COUNT	NUMBER
CLASS	VARCHAR2	(20)
CM_BA_AMOUNT_FUNC	NUMBER
CM_BA_AMOUNT_PRIM	NUMBER
CM_BA_AMOUNT_SEC	NUMBER
CM_BA_COUNT	NUMBER
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
CUSTOMER_TRX_ID	NUMBER	(15)
CUST_TRX_TYPE_ID	NUMBER	(15)
DEP_BA_AMOUNT_FUNC	NUMBER
DEP_BA_AMOUNT_PRIM	NUMBER
DEP_BA_AMOUNT_SEC	NUMBER
DEP_BA_COUNT	NUMBER
DM_BA_AMOUNT_FUNC	NUMBER
DM_BA_AMOUNT_PRIM	NUMBER
DM_BA_AMOUNT_SEC	NUMBER
DM_BA_COUNT	NUMBER
EXCHANGE_DATE	DATE
EXCHANGE_RATE	NUMBER
FILTER_DATE	DATE
GL_DATE	DATE
INITIAL_CUSTOMER_TRX_ID	NUMBER	(15)
INVOICE_CURRENCY_CODE	VARCHAR2	(15)
INV_BA_AMOUNT_FUNC	NUMBER
INV_BA_AMOUNT_PRIM	NUMBER
INV_BA_AMOUNT_SEC	NUMBER
INV_BA_COUNT	NUMBER
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
ORDER_REF_NUMBER	VARCHAR2	(30)
ORG_ID	NUMBER	(15)
PREVIOUS_CUSTOMER_TRX_ID	NUMBER	(15)
TERM_ID	NUMBER	(15)
TIME_ID	NUMBER	(15)
TRANSACTION_NUMBER	VARCHAR2	(20)
TRX_DATE	DATE
USER_ID	NUMBER	(15)
M_ROW$$	VARCHAR2	(255)
SEQUENCE$$	NUMBER
SNAPTIME$$	DATE
DMLTYPE$$	VARCHAR2	(1)
OLD_NEW$$	VARCHAR2	(1)
CHANGE_VECTOR$$	RAW	(255)

Query Text

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


SELECT AMOUNT_DUE_ORIGINAL_FUNC
,      AMOUNT_DUE_ORIGINAL_PRIM
,      AMOUNT_DUE_ORIGINAL_SEC
,      AMOUNT_DUE_ORIGINAL_TRX
,      AR_CREATION_DATE
,      BATCH_SOURCE_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      BR_BA_AMOUNT_FUNC
,      BR_BA_AMOUNT_PRIM
,      BR_BA_AMOUNT_SEC
,      BR_BA_COUNT
,      CB_BA_AMOUNT_FUNC
,      CB_BA_AMOUNT_PRIM
,      CB_BA_AMOUNT_SEC
,      CB_BA_COUNT
,      CLASS
,      CM_BA_AMOUNT_FUNC
,      CM_BA_AMOUNT_PRIM
,      CM_BA_AMOUNT_SEC
,      CM_BA_COUNT
,      CREATED_BY
,      CREATION_DATE
,      CUSTOMER_TRX_ID
,      CUST_TRX_TYPE_ID
,      DEP_BA_AMOUNT_FUNC
,      DEP_BA_AMOUNT_PRIM
,      DEP_BA_AMOUNT_SEC
,      DEP_BA_COUNT
,      DM_BA_AMOUNT_FUNC
,      DM_BA_AMOUNT_PRIM
,      DM_BA_AMOUNT_SEC
,      DM_BA_COUNT
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      FILTER_DATE
,      GL_DATE
,      INITIAL_CUSTOMER_TRX_ID
,      INVOICE_CURRENCY_CODE
,      INV_BA_AMOUNT_FUNC
,      INV_BA_AMOUNT_PRIM
,      INV_BA_AMOUNT_SEC
,      INV_BA_COUNT
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORDER_REF_NUMBER
,      ORG_ID
,      PREVIOUS_CUSTOMER_TRX_ID
,      TERM_ID
,      TIME_ID
,      TRANSACTION_NUMBER
,      TRX_DATE
,      USER_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM FII.MLOG$_FII_AR_TRANSACTIONS_;

Dependencies

[top of page]

FII.MLOG$_FII_AR_TRANSACTIONS_ does not reference any database object

FII.MLOG$_FII_AR_TRANSACTIONS_ is referenced by following:

APPS: MLOG$_FII_AR_TRANSACTIONS_