DBA Data[Home] [Help]

APPS.MSC_CL_FUNCTION dependencies on FND_LOOKUP_VALUES

Line 82: FROM all_tab_columns atc , fnd_lookup_values flv

78: lv_sql_tmp_stmt varchar2(4000);
79:
80: Cursor c1(lv_msc_schema varchar2) is
81: SELECT flv.attribute2 table_name, atc.COLUMN_NAME column_name
82: FROM all_tab_columns atc , fnd_lookup_values flv
83: WHERE
84: flv.lookup_type='MSC_ODS_TABLE'
85: and flv.enabled_flag = 'Y' AND flv.view_application_id = 700
86: and flv.attribute11 is null and flv.attribute12 is null

Line 94: FROM all_tab_columns atc , fnd_lookup_values flv

90: and flv.language=userenv('lang');
91:
92: Cursor c2(lv_msc_schema varchar2) is
93: SELECT flv.attribute2 table_name, atc.COLUMN_NAME column_name
94: FROM all_tab_columns atc , fnd_lookup_values flv
95: WHERE
96: flv.lookup_type='MSC_ODS_TABLE'
97: and flv.enabled_flag = 'Y' AND flv.view_application_id = 700
98: and flv.attribute11='Y' and flv.attribute12 is null

Line 107: FROM all_tab_columns atc , fnd_lookup_values flv

103:
104:
105: Cursor c3(lv_msc_schema varchar2) is
106: SELECT flv.attribute2 table_name, atc.COLUMN_NAME column_name
107: FROM all_tab_columns atc , fnd_lookup_values flv
108: WHERE
109: flv.lookup_type='MSC_ODS_TABLE'
110: and flv.enabled_flag = 'Y' AND flv.view_application_id = 700
111: and flv.attribute11='Y' and flv.attribute12='Y'