VIEW: APPS.BIM_DIMV_OFFERS

Source

View Text - Preformatted

SELECT TO_CHAR(AAO.ACTIVITY_OFFER_ID) , SUBSTR(QLH.NAME, 1, 80) , AAO.ACTIVITY_OFFER_ID OFFER_ID , AAO.OFFER_TYPE OFFER_TYPE , AAO.OFFER_CODE OFFER_CODE , AAO.PRIMARY_OFFER_FLAG PRIMARY_OFFER_FLAG , QLH.LIST_HEADER_ID LIST_HEADER_ID , QLH.NAME OFFER_NAME , QLH.DESCRIPTION DESCRIPTION FROM AMS_ACT_OFFERS AAO , QP_LIST_HEADERS_VL QLH WHERE AAO.QP_LIST_HEADER_ID = QLH.LIST_HEADER_ID UNION ALL SELECT '-999' , MEANING , -999 , NULL , NULL , NULL , TO_NUMBER(NULL) , MEANING , NULL FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE' AND LOOKUP_CODE = '-999' WITH READ ONLY

View Text - HTML Formatted

SELECT TO_CHAR(AAO.ACTIVITY_OFFER_ID)
, SUBSTR(QLH.NAME
, 1
, 80)
, AAO.ACTIVITY_OFFER_ID OFFER_ID
, AAO.OFFER_TYPE OFFER_TYPE
, AAO.OFFER_CODE OFFER_CODE
, AAO.PRIMARY_OFFER_FLAG PRIMARY_OFFER_FLAG
, QLH.LIST_HEADER_ID LIST_HEADER_ID
, QLH.NAME OFFER_NAME
, QLH.DESCRIPTION DESCRIPTION
FROM AMS_ACT_OFFERS AAO
, QP_LIST_HEADERS_VL QLH
WHERE AAO.QP_LIST_HEADER_ID = QLH.LIST_HEADER_ID UNION ALL SELECT '-999'
, MEANING
, -999
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, MEANING
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY