FND Design Data [Home] [Help]

View: GMI_PICK_SLIP_NUMBER_V

Product: GMI - Process Manufacturing Inventory
Description: This is used in the definition of the Value Set GMI_PICK_SLIP_NUMBERS in order to get the list of the existing OPM Pick Slip Numbers.
Implementation/DBA Data: ViewAPPS.GMI_PICK_SLIP_NUMBER_V
View Text

SELECT DISTINCT PICK_SLIP_NUMBER
FROM IC_TRAN_PND
WHERE PICK_SLIP_NUMBER > 0
AND DOC_TYPE = 'OMSO'

Columns

Name
PICK_SLIP_NUMBER