eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ASO_I_MKTG_SRC_CODES_V

Product:	ASO - Order Capture
Description:	This view shows the information related to a source code.
Implementation/DBA Data:	APPS.ASO_I_MKTG_SRC_CODES_V

View Text

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

Columns

Name
SOURCE_CODE_ID
SOURCE_CODE
SOURCE_TYPE
SOURCE_TYPE_NAME
OBJECT_ID
NAME
STATUS
START_DATE
END_DATE
INBOUND_URL
INBOUND_EMAIL_ID
INBOUND_PHONE_NO