CS_DOC_BUPUR_VW (SQL View)	Index Back
Active BU prompt Date Initials Issue Description ========================================== 05/2007 CEL F-AHAYT-748L7 prompt table for selecting doc to pull wizard answers -- shows available BU's

CS_DOC_BUPUR_VW

(SQL View)

Active BU prompt

Date Initials Issue Description ========================================== 05/2007 CEL F-AHAYT-748L7 prompt table for selecting doc to pull wizard answers -- shows available BU's

SELECT A.BUSINESS_UNIT FROM PS_CS_DOC_PUR_KEYS A , PS_CS_DOC_HDR B WHERE A.CS_DOC_ID = B.CS_DOC_ID AND B.CLOSE_FLAG <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit