APPS.EDW_GEN_VIEW dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 195: from fnd_id_flex_segments_vl

191: v_segment_list DBMS_SQL.VARCHAR2_TABLE;
192:
193: CURSOR C_Key_Segment_List(p_id_flex_code VARCHAR2, p_struct_num NUMBER, p_trunc_segment VARCHAR2) IS
194: select segment_name
195: from fnd_id_flex_segments_vl
196: where upper(id_flex_code) = p_id_flex_code
197: and id_flex_num = p_struct_num
198: and upper(segment_name) like p_trunc_segment
199: order by creation_date;

Line 1169: ||' b, fnd_id_flex_segments_vl@'||g_source_db_link||

1165: nCount NUMBER := 1;
1166: stmt1 VARCHAR2(1500) := 'select replace(SEGMENT_NAME, '||''' '||
1167: ''','||'''_'||''''||')||'||''''||'_'||''''||'||
1168: a.id_flex_num FROM fnd_id_flex_structures_vl@'||g_source_db_link
1169: ||' b, fnd_id_flex_segments_vl@'||g_source_db_link||
1170: ' a WHERE a.segment_name = :seg_name';
1171:
1172: stmt2 VARCHAR2(500) := ' AND a.id_flex_code = b.id_flex_code '||
1173: ' AND a.id_flex_num = b.id_flex_num';