APPS.BOM_DIAGUNITTEST_ITMHLCHK dependencies on FND_ID_FLEX_SEGMENTS

Line 231: ' from fnd_id_flex_segments_vl '||

227: /*Fetch Enabled System Items Segments */
228:
229: sqltxt := 'select segment_num "Segment Number", segment_name "Segment Name", '||
230: ' application_column_name "Column Name", required_flag "Required Flag" '||
231: ' from fnd_id_flex_segments_vl '||
232: ' where application_id = 401 '||
233: ' and id_flex_code = ''MSTK'' '||
234: ' and id_flex_num = 101 '||
235: ' and enabled_flag = ''Y'' '||

Line 269: from FND_ID_FLEX_SEGMENTS

265:
266: Select 1 into l_seg_count from dual
267: where not exists (
268: (select APPLICATION_COLUMN_NAME "Column_Name"
269: from FND_ID_FLEX_SEGMENTS
270: where ID_FLEX_CODE = 'MSTK'
271: and enabled_flag = 'Y'
272: MINUS
273: select column_name "Column_Name"

Line 289: from FND_ID_FLEX_SEGMENTS

285: and index_owner=l_oracle_schema
286: and COLUMN_NAME LIKE 'SEGMENT%'
287: MINUS
288: select APPLICATION_COLUMN_NAME "Column_Name"
289: from FND_ID_FLEX_SEGMENTS
290: where ID_FLEX_CODE = 'MSTK'
291: and enabled_flag = 'Y')
292: );
293: