VIEW: APPS.OTA_ACT_CAT_INCLUSIONS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')