SF_SRH_COMP_VW3 (SQL View)	Index Back
Comp Mtnce: View by ItemID key 02/13/98 :Saritha :Assigned 'SF_SRHCOMP_LVW3' as the Related language record 2/20/98 RS RL View Type C2 7/6/98 lee: (RTNT159-ML3N3) Added business_unit, as a key field. I changed the RL view too. 07/06/99 RT CN#MG800-4.0 Changed prompt table for inv_item_id 06/28/00 meg: Changed viewtext by adding distinct clause and removed 'production_type = 'PR'' from where clause.

SF_SRH_COMP_VW3

(SQL View)

Comp Mtnce: View by ItemID key

02/13/98 :Saritha :Assigned 'SF_SRHCOMP_LVW3' as the Related language record 2/20/98 RS RL View Type C2 7/6/98 lee: (RTNT159-ML3N3) Added business_unit, as a key field. I changed the RL view too. 07/06/99 RT CN#MG800-4.0 Changed prompt table for inv_item_id 06/28/00 meg: Changed viewtext by adding distinct clause and removed 'production_type = 'PR'' from where clause.

SELECT DISTINCT b.business_unit , b.inv_item_id , c.descr FROM PS_SF_PRDNID_HEADR b , PS_MASTER_ITEM_TBL c , PS_SET_CNTRL_REC d WHERE (prod_status = '20' OR prod_status = '30') AND b.ma_prdn_id_flg = 'Y' AND d.recname = 'MASTER_ITEM_TBL' AND d.setcntrlvalue = b.business_unit AND c.setid=d.setid AND c.inv_item_id=b.inv_item_id

Related Language Record: SF_SRHCOMP_LVW3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: BU_ITM_INV_VW7

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: BU_ITM_INV_VW7
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description