SRC_CD_VW

(SQL View)
 Index Back

OMEC Source Code

Source codes used for OMEC Date Initials Issue Description 031501 mv SP2 (DI-EDWONG-14) CRM Integration

SELECT DISTINCT s.source_cd , s.descr FROM PS_ORD_SOURCE_CD s WHERE %EffdtCheck(ord_source_cd s2, s, %currentdatein) AND s.eff_status = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description