VIEW: APPS.AST_OFFER_ONLY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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