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

Object Details

Object Name:	GML_LN_RCV_ERV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GML.GML_LN_RCV_ERV
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

View of Line level information of a receipt for ERES

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ID	NUMBER			Group Id uniquely identifying a Receipt Group Transaction.
INTERFACE_TRANSACTION_ID	NUMBER		Yes	Interface Transaction Id uniquely identifying a Receipt Line Transaction.
RECEIPT_NUM	VARCHAR2	(30)		Receipt Number of the Receipt created.
LINE_NUM	VARCHAR2	(0)
ITEM_NO	VARCHAR2	(40)		Item Number of the receipt line.
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description of the receipt line.
TRANSACTION_DATE	DATE		Yes	Receipt Transaction Date.
VENDOR_NAME	VARCHAR2	(240)		Vendor Name form which goods received.
VENDOR_ID	NUMBER			Vendor Id form which goods received.
VENDOR_NO	VARCHAR2	(30)		Vendor Number form which goods received.
SUBINVENTORY	VARCHAR2	(10)		Subinventory in which goods are received.
LOCATOR_DESC	VARCHAR2	(50)		Locator Description in which goods are received.
LOCATOR_ID	NUMBER			Locator Id in which goods are received.
QUANTITY	NUMBER			Secondary Quantity received.
UOM	VARCHAR2	(25)		Secondary Unit of Measure in which Item is received.
SECONDARY_QUANTITY	NUMBER
SECONDARY_UOM	VARCHAR2	(25)
ORGANIZATION_CODE	VARCHAR2	(3)		Organization Code in which Receipt is created.
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization Name in which Receipt is created.
VENDOR_LOT_NUM	VARCHAR2	(30)		Vendor Lot Number on the Receipt.

Query Text

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


SELECT GROUP_ID
,      INTERFACE_TRANSACTION_ID
,      RECEIPT_NUM
,      LINE_NUM
,      ITEM_NO
,      ITEM_DESCRIPTION
,      TRANSACTION_DATE
,      VENDOR_NAME
,      VENDOR_ID
,      VENDOR_NO
,      SUBINVENTORY
,      LOCATOR_DESC
,      LOCATOR_ID
,      QUANTITY
,      UOM
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      VENDOR_LOT_NUM
FROM APPS.GML_LN_RCV_ERV;

Dependencies

[top of page]

APPS.GML_LN_RCV_ERV references the following:

APPS: GML_LOT_ERES_TEMP; HR_ALL_ORGANIZATION_UNITS; MTL_ITEM_LOCATIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; PO_VENDORS; RCV_SHIPMENT_HEADERS; RCV_TRANSACTIONS_INTERFACE

APPS.GML_LN_RCV_ERV is not referenced by any database object