VIEW: APPS.OTV_ACTIVITIES

Source

View Text - Preformatted

SELECT OAV.VERSION_NAME , OAV.DESCRIPTION , OAD.NAME , LNG.DESCRIPTION , OAV.DURATION , HR_GENERAL.DECODE_LOOKUP('FREQUENCY',OAV.DURATION_UNITS) , HR_GENERAL.DECODE_LOOKUP('ACTIVITY_USER_STATUS',OAV.USER_STATUS) , OAV.OBJECTIVES , OAV.INTENDED_AUDIENCE , PEO.FULL_NAME , VEN.VENDOR_NAME , OAV.CONTROLLING_PERSON_ID , OAV.ACTIVITY_ID , OAV.ACTIVITY_VERSION_ID , OAD.BUSINESS_GROUP_ID , BGR.NAME FROM OTA_ACTIVITY_VERSIONS OAV , OTA_ACTIVITY_DEFINITIONS OAD , FND_LANGUAGES_VL LNG , PER_PEOPLE_F PEO , PO_VENDORS VEN , HR_ALL_ORGANIZATION_UNITS BGR WHERE OAV.LANGUAGE_ID = LNG.LANGUAGE_ID(+) AND OAV.ACTIVITY_ID = OAD.ACTIVITY_ID AND OAV.CONTROLLING_PERSON_ID = PEO.PERSON_ID(+) AND TRUNC(SYSDATE) BETWEEN NVL(OAV.START_DATE,TRUNC(SYSDATE)) AND NVL(OAV.END_DATE, TRUNC(SYSDATE)) AND OAV.START_DATE BETWEEN PEO.EFFECTIVE_START_DATE(+) AND PEO.EFFECTIVE_END_DATE(+) AND OAV.VENDOR_ID = VEN.VENDOR_ID(+) AND EXISTS ( SELECT NULL FROM OTV_SCHEDULED_EVENTS OSE WHERE OSE.ACTIVITY_VERSION_ID = OAV.ACTIVITY_VERSION_ID) AND OAD.BUSINESS_GROUP_ID =BGR.ORGANIZATION_ID AND OAD.BUSINESS_GROUP_ID =NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID, OAD.BUSINESS_GROUP_ID)

View Text - HTML Formatted

SELECT OAV.VERSION_NAME
, OAV.DESCRIPTION
, OAD.NAME
, LNG.DESCRIPTION
, OAV.DURATION
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, OAV.DURATION_UNITS)
, HR_GENERAL.DECODE_LOOKUP('ACTIVITY_USER_STATUS'
, OAV.USER_STATUS)
, OAV.OBJECTIVES
, OAV.INTENDED_AUDIENCE
, PEO.FULL_NAME
, VEN.VENDOR_NAME
, OAV.CONTROLLING_PERSON_ID
, OAV.ACTIVITY_ID
, OAV.ACTIVITY_VERSION_ID
, OAD.BUSINESS_GROUP_ID
, BGR.NAME
FROM OTA_ACTIVITY_VERSIONS OAV
, OTA_ACTIVITY_DEFINITIONS OAD
, FND_LANGUAGES_VL LNG
, PER_PEOPLE_F PEO
, PO_VENDORS VEN
, HR_ALL_ORGANIZATION_UNITS BGR
WHERE OAV.LANGUAGE_ID = LNG.LANGUAGE_ID(+)
AND OAV.ACTIVITY_ID = OAD.ACTIVITY_ID
AND OAV.CONTROLLING_PERSON_ID = PEO.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN NVL(OAV.START_DATE
, TRUNC(SYSDATE))
AND NVL(OAV.END_DATE
, TRUNC(SYSDATE))
AND OAV.START_DATE BETWEEN PEO.EFFECTIVE_START_DATE(+)
AND PEO.EFFECTIVE_END_DATE(+)
AND OAV.VENDOR_ID = VEN.VENDOR_ID(+)
AND EXISTS ( SELECT NULL
FROM OTV_SCHEDULED_EVENTS OSE
WHERE OSE.ACTIVITY_VERSION_ID = OAV.ACTIVITY_VERSION_ID)
AND OAD.BUSINESS_GROUP_ID =BGR.ORGANIZATION_ID
AND OAD.BUSINESS_GROUP_ID =NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, OAD.BUSINESS_GROUP_ID)