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.GMF_XLA_INVENTORY_TXNS_V

Object Details

Object Name:	GMF_XLA_INVENTORY_TXNS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GMF_XLA_INVENTORY_TXNS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View for SLA ADR sources from inventory transactions

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Transaction identifier
TRANSACTION_DATE	DATE		Yes	Transaction date
TRANSACTION_TYPE	VARCHAR2	(80)	Yes	Transaction Type
ORGANIZATION_CODE	VARCHAR2	(3)		Inventory Organization
TRANSFER_ORGANIZATION_CODE	VARCHAR2	(3)		Transfer Inventory Organization
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory
TRANSFER_SUBINVENTORY	VARCHAR2	(10)		Transfer Subinventory
ITEM_NAME	VARCHAR2	(40)		Item
PRIMARY_QUANTITY	VARCHAR2	(44)		Primary Quantity
PRIMARY_UOM_CODE	VARCHAR2	(3)		Primary Unit of Measure Code
SECONDARY_UOM_CODE	VARCHAR2	(3)		Secondary Unit of Measure Code
TRANSACTION_SOURCE_ID	NUMBER			Transaction Source identifier
TRANSACTION_REFERENCE	VARCHAR2	(240)		Transaction Reference
REASON_NAME	VARCHAR2	(30)		Transaction Reason
DOCUMENT_NUMBER	VARCHAR2	(40)		Document Number
LEDGER_ID	NUMBER	(15)	Yes	Ledger identifier
LEDGER_NAME	VARCHAR2	(30)	Yes	Ledger Name
VALUATION_COST_TYPE_ID	NUMBER		Yes	Valuation Cost Type identifier
VALUATION_COST_TYPE	VARCHAR2	(50)		Valuation Cost Type
EVENT_CLASS_CODE	VARCHAR2	(50)	Yes	Event Class Code

Query Text

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


SELECT TRANSACTION_ID
,      TRANSACTION_DATE
,      TRANSACTION_TYPE
,      ORGANIZATION_CODE
,      TRANSFER_ORGANIZATION_CODE
,      SUBINVENTORY_CODE
,      TRANSFER_SUBINVENTORY
,      ITEM_NAME
,      PRIMARY_QUANTITY
,      PRIMARY_UOM_CODE
,      SECONDARY_UOM_CODE
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_REFERENCE
,      REASON_NAME
,      DOCUMENT_NUMBER
,      LEDGER_ID
,      LEDGER_NAME
,      VALUATION_COST_TYPE_ID
,      VALUATION_COST_TYPE
,      EVENT_CLASS_CODE
FROM APPS.GMF_XLA_INVENTORY_TXNS_V;

Dependencies

[top of page]

APPS.GMF_XLA_INVENTORY_TXNS_V references the following:

APPS: GL_LEDGERS; GMF_XLA_EXTRACT_HEADERS; MTL_MATERIAL_TRANSACTIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_B_KFV; MTL_TRANSACTION_REASONS; MTL_TRANSACTION_TYPES; RCV_SHIPMENT_HEADERS; RCV_TRANSACTIONS

APPS.GMF_XLA_INVENTORY_TXNS_V is not referenced by any database object