[Home] [Help]
View: BIS_ACTIVITY_VERSIONS_V
View Text
SELECT TO_CHAR(AVR.ACTIVITY_VERSION_ID) ID
, AVR.VERSION_NAME VALUE
, AVR.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, AVR.VERSION_NAME ACTIVITY_VERSION
, BGR.NAME BUSINESS_GROUP_NAME
, BGR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_BUSINESS_GROUPS BGR
, OTA_ACTIVITY_DEFINITIONS ADF
, OTA_ACTIVITY_VERSIONS AVR
WHERE ADF.BUSINESS_GROUP_ID = BGR.BUSINESS_GROUP_ID
AND AVR.ACTIVITY_ID = ADF.ACTIVITY_ID
AND NVL(AVR.END_DATE
, SYSDATE) > TRUNC(ADD_MONTHS(SYSDATE
, -12))
Columns
Name |
ID |
VALUE |
ACTIVITY_VERSION_ID |
ACTIVITY_VERSION |
BUSINESS_GROUP_NAME |
BUSINESS_GROUP_ID |