SF_ISS_ID_VW (SQL View)	Index Back
SF Issue Identifier View 01/06/99 meg CN# SF800-6.0 - Do a view off of sf_iss_tran_hdr instead of sf_iss_transfer where the status of the pick plans is complete.

SF_ISS_ID_VW

(SQL View)

SF Issue Identifier View

01/06/99 meg CN# SF800-6.0 - Do a view off of sf_iss_tran_hdr instead of sf_iss_transfer where the status of the pick plans is complete.

select business_unit, pick_batch_id from PS_SF_ISS_TRAN_HDR where status_complete = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID