[Home] [Help]
| 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
|
SELECT DISTINCT PICK_SLIP_NUMBER
FROM IC_TRAN_PND
WHERE PICK_SLIP_NUMBER > 0
AND DOC_TYPE = 'OMSO'
| Name | ||
|---|---|---|
| PICK_SLIP_NUMBER |
|
|
|
|