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

Object Details

Object Name:	GME_INV_TXN_LOTS_ERES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GME.GME_INV_TXN_LOTS_ERES_V
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	Comments
TRANSACTION_TEMP_ID	NUMBER		Transaction line identifier used to join to lot or serial table when under these controls
TRANSACTION_ID	NUMBER		Transaction line identifier used to join to lot or serial table when under these controls
LOT_NUMBER	VARCHAR2	(80)	Lot Number
PARENT_LOT_NUMBER	VARCHAR2	(80)	Parent lot Number
GRADE_CODE	VARCHAR2	(150)	Grade code
LOT_STATUS_ID	NUMBER		Lot status identifier
LOT_STATUS	VARCHAR2	(80)	Lot status
TRANSACTION_QUANTITY	NUMBER		Quantity entered at transaction time
LOT_EXPIRATION_DATE	DATE		Lot expiration date
LOT_EXPIRATION_DISPLAY_DATE	VARCHAR2	(4000)	Lot expiration date
SECONDARY_TRANSACTION_QUANTITY	NUMBER		Secondary quantity
PRIMARY_QUANTITY	NUMBER		Transaction quantity in terms of the primary uom of the item

Query Text

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


SELECT TRANSACTION_TEMP_ID
,      TRANSACTION_ID
,      LOT_NUMBER
,      PARENT_LOT_NUMBER
,      GRADE_CODE
,      LOT_STATUS_ID
,      LOT_STATUS
,      TRANSACTION_QUANTITY
,      LOT_EXPIRATION_DATE
,      LOT_EXPIRATION_DISPLAY_DATE
,      SECONDARY_TRANSACTION_QUANTITY
,      PRIMARY_QUANTITY
FROM APPS.GME_INV_TXN_LOTS_ERES_V;

Dependencies

[top of page]

APPS.GME_INV_TXN_LOTS_ERES_V references the following:

APPS: FND_DATE - show dependent code; MTL_LOT_NUMBERS; MTL_MATERIAL_STATUSES_TL; MTL_MATERIAL_TRANSACTIONS; MTL_MATERIAL_TRANSACTIONS_TEMP; MTL_TRANSACTION_LOTS_TEMP; MTL_TRANSACTION_LOT_NUMBERS

APPS.GME_INV_TXN_LOTS_ERES_V is not referenced by any database object