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.

[Home] [Help]

APPS.EDW_GL_ACCT_M_C dependencies on EDW_LOCAL_SET_OF_BOOKS

Line 91: from edw_local_set_of_books

87: IF DBMS_SQL.fetch_rows(l_cursor_id) > 0 THEN
88: DBMS_SQL.column_value(l_cursor_id,1,p_value_set_id);
89: ELSE
90: select set_of_books_name into l_set_of_books_name
91: from edw_local_set_of_books
92: where lower(p_instance_code)=lower(instance)
93: and set_of_books_id=p_set_of_books_id;
94: VBHDEBUG('No Segment mapped to '|| g_dimension_name||' for '|| l_set_of_books_name);
95: END IF;

Line 289: FROM edw_local_set_of_books

285: b.set_of_books_name, b.chart_of_accounts_id,
286: b.description, c.value_set_id
287: from
288: (SELECT distinct *
289: FROM edw_local_set_of_books
290: WHERE instance IN (
291: select instance_code
292: from edw_local_instance )
293: AND edw_set_of_books_id NOT IN(

Line 564: p_set_of_books edw_local_set_of_books%ROWTYPE,

560:
561: -- replaced by bulk_push_orphans
562: function push_orphans(
563: p_temp_table_name VARCHAR2,
564: p_set_of_books edw_local_set_of_books%ROWTYPE,
565: p_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE
566: ) return number as
567:
568: l_log_timstamp Date:=Null;

Line 798: p_set_of_books edw_local_set_of_books%ROWTYPE,

794:
795: -- replaced by bulk_push_parent_child_pair
796: function push_parent_child_pair(
797: p_temp_table_name VARCHAR2,
798: p_set_of_books edw_local_set_of_books%ROWTYPE,
799: p_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE
800: ) return number as
801:
802: l_log_timstamp Date:=Null;

Line 1152: l_set_of_books edw_local_set_of_books%ROWTYPE;

1148: l_parent_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE;
1149: l_child_edw_set_of_books_id number;
1150: l_parent_value FND_FLEX_VALUE_CHILDREN_V.flex_value%TYPE;
1151: l_parent_desc FND_FLEX_VALUES_VL.description%TYPE;
1152: l_set_of_books edw_local_set_of_books%ROWTYPE;
1153: l_parent_set_of_books edw_local_set_of_books%ROWTYPE;
1154: l_edw_equi_sob edw_local_set_of_books%ROWTYPE;
1155: l_consolidation_id edw_local_cons_set_of_books.consolidation_id%TYPE;
1156: l_coa_mapping_id gl_consolidation.coa_mapping_id%TYPE;

Line 1153: l_parent_set_of_books edw_local_set_of_books%ROWTYPE;

1149: l_child_edw_set_of_books_id number;
1150: l_parent_value FND_FLEX_VALUE_CHILDREN_V.flex_value%TYPE;
1151: l_parent_desc FND_FLEX_VALUES_VL.description%TYPE;
1152: l_set_of_books edw_local_set_of_books%ROWTYPE;
1153: l_parent_set_of_books edw_local_set_of_books%ROWTYPE;
1154: l_edw_equi_sob edw_local_set_of_books%ROWTYPE;
1155: l_consolidation_id edw_local_cons_set_of_books.consolidation_id%TYPE;
1156: l_coa_mapping_id gl_consolidation.coa_mapping_id%TYPE;
1157: l_resurn_msg varchar2(150);

Line 1154: l_edw_equi_sob edw_local_set_of_books%ROWTYPE;

1150: l_parent_value FND_FLEX_VALUE_CHILDREN_V.flex_value%TYPE;
1151: l_parent_desc FND_FLEX_VALUES_VL.description%TYPE;
1152: l_set_of_books edw_local_set_of_books%ROWTYPE;
1153: l_parent_set_of_books edw_local_set_of_books%ROWTYPE;
1154: l_edw_equi_sob edw_local_set_of_books%ROWTYPE;
1155: l_consolidation_id edw_local_cons_set_of_books.consolidation_id%TYPE;
1156: l_coa_mapping_id gl_consolidation.coa_mapping_id%TYPE;
1157: l_resurn_msg varchar2(150);
1158: l_rows_inserted Number:=0;

Line 1178: RETURN edw_local_set_of_books%ROWTYPE;

1174:
1175: cur_coa_mapping_id curType;
1176:
1177: TYPE t_edw_equi_sob IS REF CURSOR
1178: RETURN edw_local_set_of_books%ROWTYPE;
1179: cur_edw_equi_sob t_edw_equi_sob;
1180:
1181:
1182: TYPE t_fnd_flex_value_pair_rec IS RECORD(

Line 1211: FROM edw_local_set_of_books

1207: cur_flex_value_desc curType;
1208:
1209: CURSOR cur_set_of_books IS
1210: SELECT distinct *
1211: FROM edw_local_set_of_books
1212: WHERE instance IN (
1213: select instance_code
1214: from edw_local_instance
1215: )

Line 1349: edw_local_set_of_books p_sob,

1345: , c_sob.set_of_books_id
1346: , c_sob.set_of_books_name
1347: , c_sob.value_set_id
1348: FROM edw_local_cons_set_of_books con,
1349: edw_local_set_of_books p_sob,
1350: ' || g_sob_vset_lookup_table || ' c_sob,
1351: EDW_FLEX_SEG_MAPPINGS_V@' || G_TARGET_LINK || ' lookup
1352: WHERE p_sob.edw_set_of_books_id = con.parent_edw_set_of_books_id
1353: AND c_sob.edw_set_of_books_id = con.child_edw_set_of_books_id

Line 1391: FROM edw_local_set_of_books

1387:
1388: --look up the equi_set_of_books_id for parent set_of_books
1389: OPEN cur_edw_equi_sob FOR
1390: SELECT distinct *
1391: FROM edw_local_set_of_books
1392: WHERE
1393: edw_set_of_books_id=(
1394: SELECT equi_set_of_books_id
1395: FROM edw_local_equi_set_of_books