eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_GL_ACCT_M_T dependencies on EDW_SET_OF_BOOKS

Line 146: from edw_segment_classes t1, edw_set_of_books t2

142: begin
143: open cur_edw_account_class for
144: select t1.value||'-'||t2.set_of_books_id||'-'||t2.instance,
145: t1.type
146: from edw_segment_classes t1, edw_set_of_books t2
147: where t1.edw_set_of_books_id = t2.edw_set_of_books_id
148: and (t1.segment_name,t2.chart_of_accounts_id,lower(t2.instance)) in
149: (select segment_name,structure_num,lower(instance_code)
150: FROM EDW_FLEX_SEG_MAPPINGS_V

Line 147: where t1.edw_set_of_books_id = t2.edw_set_of_books_id

143: open cur_edw_account_class for
144: select t1.value||'-'||t2.set_of_books_id||'-'||t2.instance,
145: t1.type
146: from edw_segment_classes t1, edw_set_of_books t2
147: where t1.edw_set_of_books_id = t2.edw_set_of_books_id
148: and (t1.segment_name,t2.chart_of_accounts_id,lower(t2.instance)) in
149: (select segment_name,structure_num,lower(instance_code)
150: FROM EDW_FLEX_SEG_MAPPINGS_V
151: WHERE DIMENSION_SHORT_NAME=g_dimension_name);

Line 898: l_set_of_books EDW_SET_OF_BOOKS%ROWTYPE;

894: end;
895:
896:
897: procedure check_root_set_up as
898: l_set_of_books EDW_SET_OF_BOOKS%ROWTYPE;
899: l_status_flag varchar2(1):='Y';
900:
901: cursor cur_set_of_books is
902: select *

Line 903: from edw_set_of_books

899: l_status_flag varchar2(1):='Y';
900:
901: cursor cur_set_of_books is
902: select *
903: from edw_set_of_books
904: where edw_set_of_books_id not in (
905: select edw_set_of_books_id
906: from edw_vbh_roots)
907: and edw_set_of_books_id not in (

Line 904: where edw_set_of_books_id not in (

900:
901: cursor cur_set_of_books is
902: select *
903: from edw_set_of_books
904: where edw_set_of_books_id not in (
905: select edw_set_of_books_id
906: from edw_vbh_roots)
907: and edw_set_of_books_id not in (
908: select edw_set_of_books_id

Line 905: select edw_set_of_books_id

901: cursor cur_set_of_books is
902: select *
903: from edw_set_of_books
904: where edw_set_of_books_id not in (
905: select edw_set_of_books_id
906: from edw_vbh_roots)
907: and edw_set_of_books_id not in (
908: select edw_set_of_books_id
909: from edw_equi_set_of_books)

Line 907: and edw_set_of_books_id not in (

903: from edw_set_of_books
904: where edw_set_of_books_id not in (
905: select edw_set_of_books_id
906: from edw_vbh_roots)
907: and edw_set_of_books_id not in (
908: select edw_set_of_books_id
909: from edw_equi_set_of_books)
910: and edw_set_of_books_id not in (
911: select child_edw_set_of_books_id

Line 908: select edw_set_of_books_id

904: where edw_set_of_books_id not in (
905: select edw_set_of_books_id
906: from edw_vbh_roots)
907: and edw_set_of_books_id not in (
908: select edw_set_of_books_id
909: from edw_equi_set_of_books)
910: and edw_set_of_books_id not in (
911: select child_edw_set_of_books_id
912: from edw_cons_set_of_books) ;

Line 910: and edw_set_of_books_id not in (

906: from edw_vbh_roots)
907: and edw_set_of_books_id not in (
908: select edw_set_of_books_id
909: from edw_equi_set_of_books)
910: and edw_set_of_books_id not in (
911: select child_edw_set_of_books_id
912: from edw_cons_set_of_books) ;
913: begin
914: open cur_set_of_books;

Line 911: select child_edw_set_of_books_id

907: and edw_set_of_books_id not in (
908: select edw_set_of_books_id
909: from edw_equi_set_of_books)
910: and edw_set_of_books_id not in (
911: select child_edw_set_of_books_id
912: from edw_cons_set_of_books) ;
913: begin
914: open cur_set_of_books;
915: loop

Line 1025: FROM edw_set_of_books

1021: l_root_value varchar2(200);
1022: BEGIN
1023: SELECT p_root ||'-'||set_of_books_id||'-'||instance
1024: INTO l_root_value
1025: FROM edw_set_of_books
1026: WHERE edw_set_of_books_id = p_root_sob_id;
1027: VBHDEBUG('l_root_value: '||l_root_value);
1028:
1029: return l_root_value;

Line 1026: WHERE edw_set_of_books_id = p_root_sob_id;

1022: BEGIN
1023: SELECT p_root ||'-'||set_of_books_id||'-'||instance
1024: INTO l_root_value
1025: FROM edw_set_of_books
1026: WHERE edw_set_of_books_id = p_root_sob_id;
1027: VBHDEBUG('l_root_value: '||l_root_value);
1028:
1029: return l_root_value;
1030:

Line 1334: l_vbh_root_sob_id edw_vbh_roots.edw_set_of_books_id%TYPE ;

1330: index by binary_integer;
1331: l_vbh_root_table t_vbh_root_table;
1332:
1333:
1334: l_vbh_root_sob_id edw_vbh_roots.edw_set_of_books_id%TYPE ;
1335:
1336: TYPE t_cur_vbh_root_ref IS REF CURSOR;
1337: cur_vbh_roots t_cur_vbh_root_ref;
1338:

Line 1531: SELECT distinct e1.edw_set_of_books_id,e1.root_value1,e1.root_value2,

1527: l_element_id);
1528:
1529: setTimer(l_roots_timestamp);
1530: OPEN cur_vbh_roots for
1531: SELECT distinct e1.edw_set_of_books_id,e1.root_value1,e1.root_value2,
1532: e1.root_value3,e1.root_value4
1533: FROM edw_vbh_roots e1, edw_set_of_books e2
1534: WHERE e1.edw_set_of_books_id=e2.edw_set_of_books_id
1535: and e1.segment_name =(

Line 1533: FROM edw_vbh_roots e1, edw_set_of_books e2

1529: setTimer(l_roots_timestamp);
1530: OPEN cur_vbh_roots for
1531: SELECT distinct e1.edw_set_of_books_id,e1.root_value1,e1.root_value2,
1532: e1.root_value3,e1.root_value4
1533: FROM edw_vbh_roots e1, edw_set_of_books e2
1534: WHERE e1.edw_set_of_books_id=e2.edw_set_of_books_id
1535: and e1.segment_name =(
1536: select segment_name
1537: FROM EDW_FLEX_SEG_MAPPINGS_V

Line 1534: WHERE e1.edw_set_of_books_id=e2.edw_set_of_books_id

1530: OPEN cur_vbh_roots for
1531: SELECT distinct e1.edw_set_of_books_id,e1.root_value1,e1.root_value2,
1532: e1.root_value3,e1.root_value4
1533: FROM edw_vbh_roots e1, edw_set_of_books e2
1534: WHERE e1.edw_set_of_books_id=e2.edw_set_of_books_id
1535: and e1.segment_name =(
1536: select segment_name
1537: FROM EDW_FLEX_SEG_MAPPINGS_V
1538: WHERE DIMENSION_SHORT_NAME=g_dimension_name