VIEW: APPS.OTFV_ACTIVITY_CATEGORIES

Source

View Text - Preformatted

SELECT tct.category category_name ,aci.start_date_active act_cat_inclusion_from ,aci.end_date_active act_cat_inclusion_to ,DECODE(aci.primary_flag,NULL,NULL, hr_bis.bis_decode_lookup('YES_NO',aci.primary_flag)) primary_flag ,hr_bis.bis_decode_lookup('CATEGORY_TYPE',tcu.type) category_type ,tdt.name activity_type ,tvt.version_name activity_name ,tvt.description activity_description ,ett.title evetn_title ,evt.timezone time_zone ,'_DF:OTA:OTA_ACT_CAT_INCLUSIONS:aci' ,tcu.category_usage_id category_usage_id ,tav.activity_id activity_id ,tav.activity_version_id activity_version_id ,evt.event_id event_id ,tav.rco_id rco_id ,ofr.offering_id offering_id FROM ota_act_cat_inclusions aci ,ota_category_usages tcu ,ota_category_usages_tl tct ,ota_events evt ,ota_events_tl ett ,ota_offerings ofr ,ota_activity_versions tav ,ota_activity_versions_tl tvt ,ota_activity_definitions tad ,ota_activity_definitions_tl tdt WHERE tav.activity_version_id = aci.activity_version_id AND tav.activity_version_id = tvt.activity_version_id AND tvt.language = USERENV('LANG') AND tav.activity_id = tad.activity_id AND tdt.activity_id = tad.activity_id AND tdt.language = USERENV('LANG') AND aci.category_usage_id = tcu.category_usage_id (+) AND aci.category_usage_id = tct.category_usage_id (+) AND tct.language (+) = USERENV('LANG') AND aci.activity_version_id = ofr.activity_version_id (+) AND ofr.offering_id = evt.parent_offering_id (+) AND evt.event_id = ett.event_id (+) AND ett.language (+) = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT TCT.CATEGORY CATEGORY_NAME
, ACI.START_DATE_ACTIVE ACT_CAT_INCLUSION_FROM
, ACI.END_DATE_ACTIVE ACT_CAT_INCLUSION_TO
, DECODE(ACI.PRIMARY_FLAG
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ACI.PRIMARY_FLAG)) PRIMARY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('CATEGORY_TYPE'
, TCU.TYPE) CATEGORY_TYPE
, TDT.NAME ACTIVITY_TYPE
, TVT.VERSION_NAME ACTIVITY_NAME
, TVT.DESCRIPTION ACTIVITY_DESCRIPTION
, ETT.TITLE EVETN_TITLE
, EVT.TIMEZONE TIME_ZONE
, '_DF:OTA:OTA_ACT_CAT_INCLUSIONS:ACI'
, TCU.CATEGORY_USAGE_ID CATEGORY_USAGE_ID
, TAV.ACTIVITY_ID ACTIVITY_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, EVT.EVENT_ID EVENT_ID
, TAV.RCO_ID RCO_ID
, OFR.OFFERING_ID OFFERING_ID
FROM OTA_ACT_CAT_INCLUSIONS ACI
, OTA_CATEGORY_USAGES TCU
, OTA_CATEGORY_USAGES_TL TCT
, OTA_EVENTS EVT
, OTA_EVENTS_TL ETT
, OTA_OFFERINGS OFR
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL TVT
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_DEFINITIONS_TL TDT
WHERE TAV.ACTIVITY_VERSION_ID = ACI.ACTIVITY_VERSION_ID
AND TAV.ACTIVITY_VERSION_ID = TVT.ACTIVITY_VERSION_ID
AND TVT.LANGUAGE = USERENV('LANG')
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID
AND TDT.ACTIVITY_ID = TAD.ACTIVITY_ID
AND TDT.LANGUAGE = USERENV('LANG')
AND ACI.CATEGORY_USAGE_ID = TCU.CATEGORY_USAGE_ID (+)
AND ACI.CATEGORY_USAGE_ID = TCT.CATEGORY_USAGE_ID (+)
AND TCT.LANGUAGE (+) = USERENV('LANG')
AND ACI.ACTIVITY_VERSION_ID = OFR.ACTIVITY_VERSION_ID (+)
AND OFR.OFFERING_ID = EVT.PARENT_OFFERING_ID (+)
AND EVT.EVENT_ID = ETT.EVENT_ID (+)
AND ETT.LANGUAGE (+) = USERENV('LANG') WITH READ ONLY