VIEW: APPS.BIM_DIMV_EVENT_HIER

Source

View Text - Preformatted

SELECT 'EVEH' || TO_CHAR(EVTH.EVENT_HEADER_ID) EVENT_ID , EVTH.EVENT_HEADER_NAME EVENT_NAME , EVTH.DESCRIPTION EVENT_DESCRIPTION , EVTH.EVENT_TYPE_CODE EVENT_TYPE_CODE , LKP.MEANING EVENT_TYPE_NAME , EVTH.EVENT_LEVEL EVENT_LEVEL , EVTH.SYSTEM_STATUS_CODE EVENT_STATUS_CODE , EVTH.LAST_STATUS_DATE EVENT_STATUS_DATE , EVTH.SOURCE_CODE EVENT_SOURCE_CODE , EVTH.EVENT_STANDALONE_FLAG EVENT_STANDALONE_FLAG , EVTH.ACTIVE_FROM_DATE ACTIVE_FROM_DATE , EVTH.ACTIVE_TO_DATE ACTIVE_TO_DATE , EVTH.ACTIVE_FLAG EVENT_ACTIVE_FLAG , EVTH.INVENTORY_ITEM_ID EVENT_ITEM_ID , decode( EVTH.PARENT_EVENT_HEADER_ID , null , null , 'EVEH' || TO_CHAR(EVTH.PARENT_EVENT_HEADER_ID)) PARENT_EVENT_HEADER_ID , null ORG_ID , 'EVEO' || TO_CHAR(EVTO.EVENT_OFFER_ID) EVENT_OFFER_ID , EVTO.EVENT_OFFER_NAME EVENT_OFFER_NAME , EVTO.DESCRIPTION EVENT_OFFER_DESCRIPTION , decode( EVTO.PARENT_EVENT_OFFER_ID , null , null , 'EVEO' || TO_CHAR(EVTO.PARENT_EVENT_OFFER_ID)) PARENT_EVENT_OFFER_ID , EVTO.SOURCE_CODE EVENT_OFFER_SOURCE_CODE , EVTO.SYSTEM_STATUS_CODE EVENT_OFFER_STATUS_CODE , EVTO.LAST_STATUS_DATE EVENT_OFFER_STATUS_DATE , EVTO.ACTIVE_FLAG EVENT_OFFER_ACTIVE_FLAG , EVTO.EVENT_DURATION EVENT_OFFER_DURATION , EVTO.EVENT_START_DATE EVENT_OFFER_START_DATE , EVTO.EVENT_END_DATE EVENT_OFFER_END_DATE , EVTO.REG_START_DATE EVENT_OFFER_REG_START_DATE , EVTO.REG_END_DATE EVENT_OFFER_REG_END_DATE , EVTO.INVENTORY_ITEM_ID EVENT_OFFER_ITEM_ID FROM AMS_LOOKUPS LKP, AMS_EVENT_HEADERS_VL EVTH, AMS_EVENT_OFFERS_VL EVTO WHERE EVTH.EVENT_HEADER_ID = EVTO.EVENT_HEADER_ID AND EVTH.EVENT_TYPE_CODE = LKP.LOOKUP_CODE AND LKP.LOOKUP_TYPE = 'AMS_EVENT_TYPE' UNION ALL SELECT '-999' , MEANING , NULL , '-999' , MEANING , NULL , NULL , TO_DATE(NULL) , NULL , NULL , TO_DATE(NULL) , TO_DATE(NULL) , NULL , TO_NUMBER(NULL) , NULL , NULL , '-999' , MEANING , NULL , NULL , NULL , NULL , TO_DATE(NULL) , NULL , TO_NUMBER(NULL) , TO_DATE(NULL) , TO_DATE(NULL) , TO_DATE(NULL) , TO_DATE(NULL) , TO_NUMBER(NULL) FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE' AND LOOKUP_CODE = '-999' WITH READ ONLY

View Text - HTML Formatted

SELECT 'EVEH' || TO_CHAR(EVTH.EVENT_HEADER_ID) EVENT_ID
, EVTH.EVENT_HEADER_NAME EVENT_NAME
, EVTH.DESCRIPTION EVENT_DESCRIPTION
, EVTH.EVENT_TYPE_CODE EVENT_TYPE_CODE
, LKP.MEANING EVENT_TYPE_NAME
, EVTH.EVENT_LEVEL EVENT_LEVEL
, EVTH.SYSTEM_STATUS_CODE EVENT_STATUS_CODE
, EVTH.LAST_STATUS_DATE EVENT_STATUS_DATE
, EVTH.SOURCE_CODE EVENT_SOURCE_CODE
, EVTH.EVENT_STANDALONE_FLAG EVENT_STANDALONE_FLAG
, EVTH.ACTIVE_FROM_DATE ACTIVE_FROM_DATE
, EVTH.ACTIVE_TO_DATE ACTIVE_TO_DATE
, EVTH.ACTIVE_FLAG EVENT_ACTIVE_FLAG
, EVTH.INVENTORY_ITEM_ID EVENT_ITEM_ID
, DECODE( EVTH.PARENT_EVENT_HEADER_ID
, NULL
, NULL
, 'EVEH' || TO_CHAR(EVTH.PARENT_EVENT_HEADER_ID)) PARENT_EVENT_HEADER_ID
, NULL ORG_ID
, 'EVEO' || TO_CHAR(EVTO.EVENT_OFFER_ID) EVENT_OFFER_ID
, EVTO.EVENT_OFFER_NAME EVENT_OFFER_NAME
, EVTO.DESCRIPTION EVENT_OFFER_DESCRIPTION
, DECODE( EVTO.PARENT_EVENT_OFFER_ID
, NULL
, NULL
, 'EVEO' || TO_CHAR(EVTO.PARENT_EVENT_OFFER_ID)) PARENT_EVENT_OFFER_ID
, EVTO.SOURCE_CODE EVENT_OFFER_SOURCE_CODE
, EVTO.SYSTEM_STATUS_CODE EVENT_OFFER_STATUS_CODE
, EVTO.LAST_STATUS_DATE EVENT_OFFER_STATUS_DATE
, EVTO.ACTIVE_FLAG EVENT_OFFER_ACTIVE_FLAG
, EVTO.EVENT_DURATION EVENT_OFFER_DURATION
, EVTO.EVENT_START_DATE EVENT_OFFER_START_DATE
, EVTO.EVENT_END_DATE EVENT_OFFER_END_DATE
, EVTO.REG_START_DATE EVENT_OFFER_REG_START_DATE
, EVTO.REG_END_DATE EVENT_OFFER_REG_END_DATE
, EVTO.INVENTORY_ITEM_ID EVENT_OFFER_ITEM_ID
FROM AMS_LOOKUPS LKP
, AMS_EVENT_HEADERS_VL EVTH
, AMS_EVENT_OFFERS_VL EVTO
WHERE EVTH.EVENT_HEADER_ID = EVTO.EVENT_HEADER_ID
AND EVTH.EVENT_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'AMS_EVENT_TYPE' UNION ALL SELECT '-999'
, MEANING
, NULL
, '-999'
, MEANING
, NULL
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, '-999'
, MEANING
, NULL
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY