SCR_LOGO_MST_VW

(SQL View)
Index Back

SCR Logo Adjustment View


SELECT SCR_ID ,PSIMAGEVER ,VENDOR_LOGO FROM PS_SCR_LOGO_MST M WHERE SCR_SEQ_NUM=(SELECT MAX(SCR_SEQ_NUM) FROM PS_SCR_LOGO_MST WHERE SCR_ID=M.SCR_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID
2 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version
3 PROD_IMAGE Image / Attachment(70) VARCHAR2(70) Product Image