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: POA.MLOG$_POA_DBI_RTX_F

Object Details

Object Name:	MLOG$_POA_DBI_RTX_F
Object Type:	TABLE
Owner:	POA
Subobject Name:
Status:	VALID

snapshot log for master table POA.POA_DBI_RTX_F

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Columns

Name	Datatype	Length
CREATION_OPERATING_UNIT_ID	NUMBER
CURRENCY_CONVERSION_RATE	NUMBER
DROPSHIP_TYPE_CODE	NUMBER
GLOBAL_CUR_CONV_RATE	NUMBER
GRP_TXN_DATE	DATE
INVENTORY_ITEM_ID	NUMBER
INV_TRANSACTION_ID	NUMBER
LINE_LOCATION_ID	NUMBER
PARENT_TRANSACTION_TYPE	VARCHAR2	(25)
PRIMARY_QUANTITY	NUMBER
PRIMARY_UOM_CODE	VARCHAR2	(3)
QUANTITY	NUMBER
REASON_ID	NUMBER
RECEIPT_EXISTS	VARCHAR2	(1)
RECEIVE_TXN_DATE	DATE
RECEIVING_ORG_ID	NUMBER
ROUTING_HEADER_ID	NUMBER
SGLOBAL_CUR_CONV_RATE	NUMBER
SHIPPING_CONTROL	VARCHAR2	(30)
SOURCE_DOCUMENT_CODE	VARCHAR2	(25)
SOURCE_DOC_QUANTITY	NUMBER
SUPPLIER_ID	NUMBER
SUPPLIER_SITE_ID	NUMBER
TRANSACTION_TYPE	VARCHAR2	(25)
WMS_ENABLED_FLAG	VARCHAR2	(1)
WMS_GRP_TXN_DATE	DATE
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 CREATION_OPERATING_UNIT_ID
,      CURRENCY_CONVERSION_RATE
,      DROPSHIP_TYPE_CODE
,      GLOBAL_CUR_CONV_RATE
,      GRP_TXN_DATE
,      INVENTORY_ITEM_ID
,      INV_TRANSACTION_ID
,      LINE_LOCATION_ID
,      PARENT_TRANSACTION_TYPE
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      QUANTITY
,      REASON_ID
,      RECEIPT_EXISTS
,      RECEIVE_TXN_DATE
,      RECEIVING_ORG_ID
,      ROUTING_HEADER_ID
,      SGLOBAL_CUR_CONV_RATE
,      SHIPPING_CONTROL
,      SOURCE_DOCUMENT_CODE
,      SOURCE_DOC_QUANTITY
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      TRANSACTION_TYPE
,      WMS_ENABLED_FLAG
,      WMS_GRP_TXN_DATE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM POA.MLOG$_POA_DBI_RTX_F;

Dependencies

[top of page]

POA.MLOG$_POA_DBI_RTX_F does not reference any database object

POA.MLOG$_POA_DBI_RTX_F is referenced by following:

APPS: MLOG$_POA_DBI_RTX_F