SF_DSP_PA_VW

(SQL View)
 Index Back

PA Prompt in Online Disp List

5/18/98 RS (EPNT103-I79KI) : Created

select distinct a.business_unit, a.work_center_code, c.prdn_area_code, c.prdn_area_desc from PS_SF_OP_LIST a, ps_sf_prdnid_headr b, ps_sf_prdn_area c where a.business_unit= c.business_unit and a.business_unit= b.business_unit and b.prdn_area_code=c.prdn_area_code and a.production_id = b.production_id and b.ma_prdn_id_flg = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
3 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
4 PRDN_AREA_DESC Character(30) VARCHAR2(30) NOT NULL Description