[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 |