APPS.EDW_VBH_SETUP dependencies on EDW_FLEX_SEG_MAPPINGS_V

Line 72: ||' where CHART_OF_ACCOUNTS_ID in (select distinct STRUCTURE_NUM from edw_flex_seg_mappings_v where instance_code=:b_instance_code)';

68: sysdate,
69: fnd_global.user_id,
70: fnd_global.login_id
71: from gl_sets_of_books@'||l_instance_link
72: ||' where CHART_OF_ACCOUNTS_ID in (select distinct STRUCTURE_NUM from edw_flex_seg_mappings_v where instance_code=:b_instance_code)';
73: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
74: DBMS_SQL.bind_variable(l_cursor_id,':b_instance_code',l_instance_code);
75: l_rows_inserted:=DBMS_SQL.execute(l_cursor_id);
76: DBMS_SQL.close_cursor(l_cursor_id);

Line 352: from edw_flex_seg_mappings_v

348: into p_wh_dimension_name
349: from edw_dimensions_md_v
350: where dim_name =(
351: select DIMENSION_SHORT_NAME
352: from edw_flex_seg_mappings_v
353: where lower(instance_code)=lower(p_instance)
354: and segment_name =p_segment_name
355: and structure_num=p_coa_id);
356: p_status:=true;

Line 661: from edw_flex_seg_mappings_v from_f,edw_set_of_books from_b

657: exit when l_cur_edw_cons%NOTFOUND;
658:
659: select from_f.value_set_id
660: into l_from_value_set_id
661: from edw_flex_seg_mappings_v from_f,edw_set_of_books from_b
662: where from_b.edw_set_of_books_id=l_child_edw_sob_id
663: and from_b.chart_of_accounts_id=from_f.structure_num
664: and from_f.instance_code=p_instance
665: and from_f.segment_name=p_segment_name;

Line 669: from edw_flex_seg_mappings_v to_f,edw_set_of_books to_b

665: and from_f.segment_name=p_segment_name;
666:
667: select to_f.value_set_id
668: into l_to_value_set_id
669: from edw_flex_seg_mappings_v to_f,edw_set_of_books to_b
670: where to_b.edw_set_of_books_id=l_parent_edw_sob_id
671: and to_b.chart_of_accounts_id=to_f.structure_num
672: and to_f.instance_code=p_instance
673: and to_f.segment_name=p_segment_name;

Line 723: from edw_flex_seg_mappings_v from_f,edw_set_of_books from_b

719: fetch l_cur_edw_cons into l_parent_edw_sob_id,l_child_edw_sob_id,l_consolidation_id;
720: exit when l_cur_edw_cons%NOTFOUND;
721: select from_f.value_set_id
722: into l_from_value_set_id
723: from edw_flex_seg_mappings_v from_f,edw_set_of_books from_b
724: where from_b.edw_set_of_books_id=l_child_edw_sob_id
725: and from_b.chart_of_accounts_id=from_f.structure_num
726: and from_f.instance_code=p_instance
727: and from_f.segment_name=p_segment_name;

Line 731: from edw_flex_seg_mappings_v to_f,edw_set_of_books to_b

727: and from_f.segment_name=p_segment_name;
728:
729: select to_f.value_set_id
730: into l_to_value_set_id
731: from edw_flex_seg_mappings_v to_f,edw_set_of_books to_b
732: where to_b.edw_set_of_books_id=l_parent_edw_sob_id
733: and to_b.chart_of_accounts_id=to_f.structure_num
734: and to_f.instance_code=p_instance
735: and to_f.segment_name=p_segment_name;