VIEW: APPS.ASO_I_MKTG_SRC_CODES_V

Source

View Text - Preformatted

SELECT sc.source_code_id ,sc.source_code ,sc.source_type ,lk.meaning ,sc.object_id ,sc.name ,sc.status ,sc.start_date ,sc.end_date ,sc.inbound_url ,sc.inbound_email_id ,sc.inbound_phone_no from AMS_LOOKUPS LK, AMS_P_SOURCE_CODES_V SC WHERE lk.lookup_type = 'AMS_SYS_ARC_QUALIFIER' and lk.lookup_code = sc.source_type

View Text - HTML Formatted

SELECT SC.SOURCE_CODE_ID
, SC.SOURCE_CODE
, SC.SOURCE_TYPE
, LK.MEANING
, SC.OBJECT_ID
, SC.NAME
, SC.STATUS
, SC.START_DATE
, SC.END_DATE
, SC.INBOUND_URL
, SC.INBOUND_EMAIL_ID
, SC.INBOUND_PHONE_NO
FROM AMS_LOOKUPS LK
, AMS_P_SOURCE_CODES_V SC
WHERE LK.LOOKUP_TYPE = 'AMS_SYS_ARC_QUALIFIER'
AND LK.LOOKUP_CODE = SC.SOURCE_TYPE