OMEC_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

OMEC_SRC_CD_VW

(SQL View)

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 FROM ps_ord_source_cd s , PS_OMEC_SRC_CD_EOC eoc WHERE %EffdtCheck(ord_source_cd s2, s, %currentdatein) AND s.eff_status = 'A' AND eoc.source_cd = s.source_cd

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code