View: BIS_ACTIVITY_VERSIONS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.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