DBA Data[Home] [Help]

APPS.OTA_FR_PLAN_DFORM dependencies on OTA_ACTIVITY_DEFINITIONS

Line 71: from ota_activity_definitions category,

67: select category_tl.name member_name
68: ,category.activity_id member_id
69: ,category_tl.description member_description
70: ,'ACTIVITY_DEFINITION' member_level
71: from ota_activity_definitions category,
72: ota_activity_definitions_tl category_tl
73: where category.activity_id = category_tl.activity_id(+)
74: and category_tl.language(+) = userenv('LANG')
75: and exists

Line 72: ota_activity_definitions_tl category_tl

68: ,category.activity_id member_id
69: ,category_tl.description member_description
70: ,'ACTIVITY_DEFINITION' member_level
71: from ota_activity_definitions category,
72: ota_activity_definitions_tl category_tl
73: where category.activity_id = category_tl.activity_id(+)
74: and category_tl.language(+) = userenv('LANG')
75: and exists
76: (select null