[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: |
APPS.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