SELECT SC.source_code_id, SC.SOURCE_CODE, SC.NAME, SC.OBJECT_ID, SC.STATUS, SC.SOURCE_TYPE FROM ams_p_source_codes_v SC WHERE SC.STATUS IN ('ACTIVE','ONHOLD','COMPLETED','ON_HOLD') AND SC.SOURCE_TYPE IN ('EVEH','EVEO','CAMP','CSCH','OFFR','EONE')
SELECT SC.SOURCE_CODE_ID
, SC.SOURCE_CODE
, SC.NAME
, SC.OBJECT_ID
, SC.STATUS
, SC.SOURCE_TYPE
FROM AMS_P_SOURCE_CODES_V SC
WHERE SC.STATUS IN ('ACTIVE'
, 'ONHOLD'
, 'COMPLETED'
, 'ON_HOLD')
AND SC.SOURCE_TYPE IN ('EVEH'
, 'EVEO'
, 'CAMP'
, 'CSCH'
, 'OFFR'
, 'EONE')
|
|
|