View: AST_OFFER_ONLY_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.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