VIEW: APPS.AMS_P_OFFER_PRODUCTS_V

Source

View Text - Preformatted

SELECT AAP.ACTIVITY_PRODUCT_ID , AAP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AAP.MASTER_OBJECT_ID CAMPAIGN_ID, QPL.DESCRIPTION , OFF.STATUS_CODE , OFF.STATUS_DATE , OFF.OFFER_CODE , OFF.START_DATE, OFF.END_DATE, OFF.OFFER_TYPE, AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_OFFER_TYPE',OFF.OFFER_TYPE), AAP.LEVEL_TYPE_CODE , AAP.LEVEL_TYPE , AAP.CATEGORY_ID , AAP.CATEGORY_NAME , AAP.CATEGORY_SET_ID , AAP.CATEGORY_SET_NAME , AAP.ORGANIZATION_ID , AAP.INVENTORY_ITEM_ID , AAP.INVENTORY_ITEM_NUMBER , AAP.INVENTORY_ITEM_DESCRIPTION, AAP.EXCLUDED_FLAG FROM AMS_ACT_OFFERS OFF, QP_LIST_HEADERS_VL QPL, AMS_ACT_PRODUCTS_V AAP WHERE OFF.ACTIVITY_OFFER_ID = AAP.MASTER_OBJECT_ID AND AAP.MASTER_OBJECT_TYPE = 'OFFR' AND OFF.QP_LIST_HEADER_ID = QPL.LIST_HEADER_ID AND ( OFF.END_DATE IS NULL OR OFF.END_DATE > SYSDATE )

View Text - HTML Formatted

SELECT AAP.ACTIVITY_PRODUCT_ID
, AAP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AAP.MASTER_OBJECT_ID CAMPAIGN_ID
, QPL.DESCRIPTION
, OFF.STATUS_CODE
, OFF.STATUS_DATE
, OFF.OFFER_CODE
, OFF.START_DATE
, OFF.END_DATE
, OFF.OFFER_TYPE
, AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_OFFER_TYPE'
, OFF.OFFER_TYPE)
, AAP.LEVEL_TYPE_CODE
, AAP.LEVEL_TYPE
, AAP.CATEGORY_ID
, AAP.CATEGORY_NAME
, AAP.CATEGORY_SET_ID
, AAP.CATEGORY_SET_NAME
, AAP.ORGANIZATION_ID
, AAP.INVENTORY_ITEM_ID
, AAP.INVENTORY_ITEM_NUMBER
, AAP.INVENTORY_ITEM_DESCRIPTION
, AAP.EXCLUDED_FLAG
FROM AMS_ACT_OFFERS OFF
, QP_LIST_HEADERS_VL QPL
, AMS_ACT_PRODUCTS_V AAP
WHERE OFF.ACTIVITY_OFFER_ID = AAP.MASTER_OBJECT_ID
AND AAP.MASTER_OBJECT_TYPE = 'OFFR'
AND OFF.QP_LIST_HEADER_ID = QPL.LIST_HEADER_ID
AND ( OFF.END_DATE IS NULL OR OFF.END_DATE > SYSDATE )