Product: | OTA - Learning Management |
---|---|
Description: | View to list Categories for particular Activity Version. |
Implementation/DBA Data: | APPS.OTA_ACT_CAT_INCLUSIONS_V |
SELECT ACI.ROWID
, TAD.BUSINESS_GROUP_ID
, ACI.ACTIVITY_VERSION_ID
, AVT.VERSION_NAME
, ACI.ACTIVITY_CATEGORY
, ACI.COMMENTS
, ACI.OBJECT_VERSION_NUMBER
, CUT.CATEGORY
, ACI_INFORMATION_CATEGORY
, ACI_INFORMATION1
, ACI_INFORMATION2
, ACI_INFORMATION3
, ACI_INFORMATION4
, ACI_INFORMATION5
, ACI_INFORMATION6
, ACI_INFORMATION7
, ACI_INFORMATION8
, ACI_INFORMATION9
, ACI_INFORMATION10
, ACI_INFORMATION11
, ACI_INFORMATION12
, ACI_INFORMATION13
, ACI_INFORMATION14
, ACI_INFORMATION15
, ACI_INFORMATION16
, ACI_INFORMATION17
, ACI_INFORMATION18
, ACI_INFORMATION19
, ACI_INFORMATION20
, ACI.START_DATE_ACTIVE
, ACI.END_DATE_ACTIVE
, ACI.PRIMARY_FLAG
, ADT.NAME
, TAD.ACTIVITY_ID
, ACI.CATEGORY_USAGE_ID
, TCU.TYPE
, CUT.CATEGORY
, ACI.LAST_UPDATE_DATE
, ACI.LAST_UPDATED_BY
, ACI.LAST_UPDATE_LOGIN
, ACI.CREATED_BY
, ACI.CREATION_DATE
FROM OTA_ACT_CAT_INCLUSIONS ACI
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL AVT
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_DEFINITIONS_TL ADT
, OTA_CATEGORY_USAGES TCU
, OTA_CATEGORY_USAGES_TL CUT
WHERE TAV.ACTIVITY_VERSION_ID = ACI.ACTIVITY_VERSION_ID
AND AVT.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID
AND AVT.LANGUAGE= USERENV('LANG')
AND TAD.ACTIVITY_ID = TAV.ACTIVITY_ID
AND ADT.ACTIVITY_ID = TAD.ACTIVITY_ID
AND ADT.LANGUAGE=USERENV('LANG')
AND ACI.CATEGORY_USAGE_ID = TCU.CATEGORY_USAGE_ID
AND TCU.CATEGORY_USAGE_ID = CUT.CATEGORY_USAGE_ID
AND CUT.LANGUAGE=USERENV('LANG')