DBA Data[Home] [Help]

APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 48: From Fnd_Descr_Flex_Col_Usage_Vl fcu, fnd_flex_value_sets fvs

44:
45: Cursor C1 (p_context_code in varchar2 ,p_source_table in varchar2
46: , p_destination_table in varchar2) IS
47: Select fcu.*,fvs.flex_value_set_name
48: From Fnd_Descr_Flex_Col_Usage_Vl fcu, fnd_flex_value_sets fvs
49: Where fcu.Application_id = 810
50: and fcu.Descriptive_FlexField_Name = p_source_table
51: and fcu.Descriptive_Flex_Context_code = p_context_code
52: and fcu.flex_value_set_id = fvs.flex_value_set_id(+)

Line 54: From Fnd_Descr_Flex_Col_Usage_Vl cat_fcu

50: and fcu.Descriptive_FlexField_Name = p_source_table
51: and fcu.Descriptive_Flex_Context_code = p_context_code
52: and fcu.flex_value_set_id = fvs.flex_value_set_id(+)
53: and Not exists (SELECT 'Y'
54: From Fnd_Descr_Flex_Col_Usage_Vl cat_fcu
55: Where cat_fcu.Application_id = fcu.application_id
56: and cat_fcu.Descriptive_FlexField_Name = p_destination_table
57: and cat_fcu.Descriptive_Flex_Context_code = fcu.Descriptive_Flex_Context_code
58: and cat_fcu.end_user_column_name = fcu.end_user_column_name );