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]

VIEW: APPS.MTL_ADJUSTMENT_TXN_SYNC_V

Object Details

Object Name:	MTL_ADJUSTMENT_TXN_SYNC_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_NUMBER	NUMBER			Transaction Number
TRANSACTION_DATE	DATE			Transaction Date
CATEGORY	VARCHAR2	(163)		Name of the host/client
CATEGORY_ID	NUMBER		Yes	Category ID
WAREHOUSE	VARCHAR2	(240)	Yes	Organization Name
ORGANIZATION_ID	NUMBER			Organization ID
ITEM	VARCHAR2	(40)		Item
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
INVENTORY_ITEM_ID	NUMBER			Inventory Item ID
REVISION	VARCHAR2	(3)		Revision
SUBINVENTORY	VARCHAR2	(10)		Subinventory Code
LOCATOR	CHAR	(1)		Locator
LOT	VARCHAR2	(80)		Lot Number
SERIAL	VARCHAR2	(30)		Serial Number
TRANSFER_WAREHOUSE	VARCHAR2	(240)		Transfer Organization Name
TRANSFER_SUBINVENTORY	VARCHAR2	(10)		Transfer Subinventory Code
TRANSFER_LOCATOR	CHAR	(1)		Transfer Locator
LPN	VARCHAR2	(30)		License Plate Number
TRANSFER_LPN	VARCHAR2	(30)		Transfer License Plate Number
CONTENT_LPN	VARCHAR2	(30)		Content License Plate Number
TRANSACTION_QUANTITY	NUMBER			Transaction Quantity
TRANSACTION_UOM	VARCHAR2	(25)	Yes	Transaction Unit Of Measure
PRIMARY_QUANTITY	NUMBER			Primary Quantity
PRIMARY_UOM	VARCHAR2	(25)	Yes	Primary Unit Of Measure
SECONDARY_QUANTITY	NUMBER			Secondary Quantity
SECONDARY_UOM	VARCHAR2	(25)		Secondary Unit Of Measure
TRANSACTION_TYPE	VARCHAR2	(80)	Yes	Transaction Type
TRANSACTION_TYPE_ID	NUMBER		Yes	Transaction Type ID
TRANSACTION_SOURCE_TYPE_ID	NUMBER			Transaction Source Type ID
TRANSACTION_ACTION_ID	NUMBER			Transaction Action ID
TRANSACTION_SOURCE	VARCHAR2	(240)		Transaction Source
CREATION_DATE	DATE			Creation Date
TRANSACTION_EXTRACTED	VARCHAR2	(1)		Transaction Sync Status
XML_DOCUMENT_ID	NUMBER			XML document ID

Query Text

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


SELECT TRANSACTION_NUMBER
,      TRANSACTION_DATE
,      CATEGORY
,      CATEGORY_ID
,      WAREHOUSE
,      ORGANIZATION_ID
,      ITEM
,      ITEM_DESCRIPTION
,      INVENTORY_ITEM_ID
,      REVISION
,      SUBINVENTORY
,      LOCATOR
,      LOT
,      SERIAL
,      TRANSFER_WAREHOUSE
,      TRANSFER_SUBINVENTORY
,      TRANSFER_LOCATOR
,      LPN
,      TRANSFER_LPN
,      CONTENT_LPN
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      TRANSACTION_TYPE
,      TRANSACTION_TYPE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE
,      CREATION_DATE
,      TRANSACTION_EXTRACTED
,      XML_DOCUMENT_ID
FROM APPS.MTL_ADJUSTMENT_TXN_SYNC_V;