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

Object Details

Object Name:	GMI_PICK_SLIP_VW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMI.GMI_PICK_SLIP_VW
Subobject Name:
Status:	VALID

View Type

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

This view is the basis of the OPM Pick Slip report (GMIRDPIK.rdf).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FROM_SUBINVENTORY	VARCHAR2	(10)		From subinventory code
FROM_LOCATOR_ID	NUMBER			From locator identifier
TO_SUBINVENTORY	VARCHAR2	(10)		To subinventory code
TO_LOCATOR_ID	NUMBER			To locator identifier
ITEM_NO	VARCHAR2	(32)	Yes	Item Number
ITEM_ID	NUMBER	(10)	Yes	Item Id
ORGANIZATION_ID	NUMBER		Yes	Organization Id
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Id
ITEM_DESC	VARCHAR2	(240)		Item Description
LOT_ID	NUMBER	(10)	Yes	Lot Id
LOT_NO	VARCHAR2	(32)	Yes	Lot Number
SUBLOT_NO	VARCHAR2	(32)		Sublot Number
LOCATION	VARCHAR2	(16)	Yes	Location
PRIMARY_QTY	NUMBER			Primary Quantity
TRANS_UM1	VARCHAR2	(4)	Yes	Trans UM1
SECONDARY_QTY	NUMBER			Secondary Quantity
TRANS_UM2	VARCHAR2	(4)		Trans UM2
PICK_SLIP_NUMBER	NUMBER			Pick Slip Number
QC_GRADE	VARCHAR2	(4)		QC Grade
DETAILING_DATE	DATE		Yes	Detailing Date
MO_NUMBER	VARCHAR2	(30)	Yes	MO Number
MOVE_ORDER_LINE_ID	NUMBER		Yes	Move Order Line ID
MOVE_ORDER_LINE_NO	NUMBER		Yes	Move Order Line Number
LINE_STATUS	VARCHAR2	(8)		Line Status
TRANSACTION_ID	NUMBER	(10)	Yes	Transaction Id

Query Text

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


SELECT FROM_SUBINVENTORY
,      FROM_LOCATOR_ID
,      TO_SUBINVENTORY
,      TO_LOCATOR_ID
,      ITEM_NO
,      ITEM_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_DESC
,      LOT_ID
,      LOT_NO
,      SUBLOT_NO
,      LOCATION
,      PRIMARY_QTY
,      TRANS_UM1
,      SECONDARY_QTY
,      TRANS_UM2
,      PICK_SLIP_NUMBER
,      QC_GRADE
,      DETAILING_DATE
,      MO_NUMBER
,      MOVE_ORDER_LINE_ID
,      MOVE_ORDER_LINE_NO
,      LINE_STATUS
,      TRANSACTION_ID
FROM APPS.GMI_PICK_SLIP_VW;

Dependencies

[top of page]

APPS.GMI_PICK_SLIP_VW references the following:

APPS: IC_ITEM_MST; IC_LOTS_MST; IC_TRAN_PND; IC_TXN_REQUEST_HEADERS; IC_TXN_REQUEST_LINES; MTL_SYSTEM_ITEMS; WSH_DELIVERY_DETAILS

APPS.GMI_PICK_SLIP_VW is not referenced by any database object