[Home] [Help]
View: AST_OFFER_ONLY_V
View Text
SELECT SOC.SOURCE_CODE_ID
, SOC.SOURCE_CODE
, SOC.ARC_SOURCE_CODE_FOR SOURCE_TYPE
, SOC.SOURCE_CODE_FOR_ID OBJECT_ID
, QPLV.DESCRIPTION
, OFFR.STATUS_CODE
, QPLV.START_DATE_ACTIVE
, QPLV.END_DATE_ACTIVE
, NULL
, NULL
, NULL
, SOC.RELATED_SOURCE_CODE
, SOC.RELATED_SOURCE_OBJECT
, SOC.RELATED_SOURCE_ID
FROM AMS_SOURCE_CODES SOC
, AMS_OFFERS OFFR
, QP_LIST_HEADERS_VL QPLV
WHERE SOC.ARC_SOURCE_CODE_FOR = 'OFFR'
AND SOC.ACTIVE_FLAG = 'Y'
AND SOC.SOURCE_CODE_FOR_ID = OFFR.QP_LIST_HEADER_ID
AND OFFR.QP_LIST_HEADER_ID = QPLV.LIST_HEADER_ID
Columns
Name |
SOURCE_CODE_ID |
SOURCE_CODE |
SOURCE_TYPE |
OBJECT_ID |
NAME |
STATUS |
START_DATE |
END_DATE |
INBOUND_URL |
INBOUND_EMAIL_ID |
INBOUND_PHONE_NO |
RELATED_SOURCE_CODE |
RELATED_SOURCE_OBJECT |
RELATED_SOURCE_ID |