OCD_DISTHOLD_VW (SQL View)	Index Back
Hold distribution This record shows all of the holds that are in the system.

OCD_DISTHOLD_VW

(SQL View)

Hold distribution

This record shows all of the holds that are in the system.

SELECT DISTINCT(HOLD_CD) FROM PS_RO_HOLD WHERE (HOLD_STATUS = 'REMV' OR HOLD_STATUS = 'PASS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HOLD_CD Character(6) VARCHAR2(6) NOT NULL This field determine the hold code of an item.