APPS.JTF_RS_ACTIVE_REC_CONC_PUB dependencies on JTF_RS_GRP_DEN_LTST_REL_1_TMP

Line 27: jtf_rs_grp_den_ltst_rel_1_tmp Table to Improve

23: JTF_RS_GRP_DEN_LTST_REL_2_TMP table because
24: of ORA-08176 error in GSI env. Doing it after
25: confirming with APPS PERF team (29-SEP-2005)
26: RGOKAVAR 13-AUG-2008 Bug 6800249: Changing Insert statement into
27: jtf_rs_grp_den_ltst_rel_1_tmp Table to Improve
28: Performance.
29: RGOKAVAR 06-FEB-2009 Bug 8220580: Revert the changes in
30: FND_STATS.GATHER_COLUMN_STATS, which are added
31: in Bug7587760.

Line 151: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_jtfu||'.JTF_RS_GRP_DEN_LTST_REL_1_TMP';

147: -- this query gives all those groups (and their last parent group)
148: -- who do not have active parent groups now. But had it in past.
149:
150: -- before that truncate the table since it has unique index
151: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_jtfu||'.JTF_RS_GRP_DEN_LTST_REL_1_TMP';
152: --DELETE FROM JTF_RS_GRP_DEN_LTST_REL_1_TMP;
153:
154: -- Insert data into 1st temporary table (session based)
155: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_grp_den_ltst_rel_1_tmp a

Line 152: --DELETE FROM JTF_RS_GRP_DEN_LTST_REL_1_TMP;

148: -- who do not have active parent groups now. But had it in past.
149:
150: -- before that truncate the table since it has unique index
151: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_jtfu||'.JTF_RS_GRP_DEN_LTST_REL_1_TMP';
152: --DELETE FROM JTF_RS_GRP_DEN_LTST_REL_1_TMP;
153:
154: -- Insert data into 1st temporary table (session based)
155: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_grp_den_ltst_rel_1_tmp a
156: (child_group_id, parent_group_id, start_date_active, end_date_active)

Line 155: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_grp_den_ltst_rel_1_tmp a

151: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_jtfu||'.JTF_RS_GRP_DEN_LTST_REL_1_TMP';
152: --DELETE FROM JTF_RS_GRP_DEN_LTST_REL_1_TMP;
153:
154: -- Insert data into 1st temporary table (session based)
155: INSERT /*+ APPEND PARALLEL(a) NOLOGGING */ INTO jtf_rs_grp_den_ltst_rel_1_tmp a
156: (child_group_id, parent_group_id, start_date_active, end_date_active)
157: select child_group_id, parent_group_id, start_date_active, end_date_active from (
158: SELECT /*+ parallel(grp1) */
159: grp1.group_id child_group_id, grp1.related_group_id parent_group_id,

Line 191: jtf_rs_grp_den_ltst_rel_1_tmp x

187: (denorm_grp_id)
188: SELECT /*+ use_hash(x den2 den3) PARALLEL(x) PARALLEL(den2) PARALLEL(den3)*/
189: distinct den3.denorm_grp_id
190: FROM
191: jtf_rs_grp_den_ltst_rel_1_tmp x
192: ,jtf_rs_groups_denorm den2 -- fetch all children of x.child_group_id
193: ,jtf_rs_groups_denorm den3 -- fetch all parent of den2.group_id
194: WHERE den2.parent_group_id = x.child_group_id
195: AND (