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.JTF_RS_DBI_8I_CONC_PUB dependencies on JTF_RS_DBI_MGR_GROUPS

Line 6: This is a concurrent program to populate the data in JTF_RS_DBI_MGR_GROUPS

2: /* $Header: jtfrsdab.pls 115.5 2004/06/09 17:31:17 nsinghai noship $ */
3:
4: /****************************************************************************
5: This is 8i compatible concurrent program
6: This is a concurrent program to populate the data in JTF_RS_DBI_MGR_GROUPS
7: and JTF_RS_DBI_DENORM_RES_GROUPS
8: table so that it can be accessed via view JTF_RS_DBI_RES_GRP_VL for Sales
9: Group Hierarchy in DBI product. This program is exclusively built for DBI
10: product and is NOT included in mainline code of ATG Resource Manager.

Line 117: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS';

113: BIS_COLLECTION_UTILITIES.debug('Index Information: l_index_owner='||l_index_owner
114: ||': l_table_owner='||l_table_owner||': l_index_tblspace='||l_index_tblspace
115: ||': Degree of parallelism='||bis_common_parameters.get_degree_of_parallelism);
116:
117: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS';
118:
119: l_stage := 'Stage = jtf_rs_dbi_mgr_groups : ' ;
120:
121: -- INSERT top manager groups in intermediate table

Line 119: l_stage := 'Stage = jtf_rs_dbi_mgr_groups : ' ;

115: ||': Degree of parallelism='||bis_common_parameters.get_degree_of_parallelism);
116:
117: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.JTF_RS_DBI_MGR_GROUPS';
118:
119: l_stage := 'Stage = jtf_rs_dbi_mgr_groups : ' ;
120:
121: -- INSERT top manager groups in intermediate table
122: INSERT /*+ APPEND PARALLEL(jtf_rs_dbi_mgr_groups) NOLOGGING */
123: INTO jtf_rs_dbi_mgr_groups

Line 122: INSERT /+ APPEND PARALLEL(jtf_rs_dbi_mgr_groups) NOLOGGING /

118:
119: l_stage := 'Stage = jtf_rs_dbi_mgr_groups : ' ;
120:
121: -- INSERT top manager groups in intermediate table
122: INSERT /*+ APPEND PARALLEL(jtf_rs_dbi_mgr_groups) NOLOGGING */
123: INTO jtf_rs_dbi_mgr_groups
124: (dbi_mgr_id, resource_id, user_id, group_id,
125: creation_date, created_by )
126: SELECT /*+ use_hash(x) parallel(x) */

Line 123: INTO jtf_rs_dbi_mgr_groups

119: l_stage := 'Stage = jtf_rs_dbi_mgr_groups : ' ;
120:
121: -- INSERT top manager groups in intermediate table
122: INSERT /*+ APPEND PARALLEL(jtf_rs_dbi_mgr_groups) NOLOGGING */
123: INTO jtf_rs_dbi_mgr_groups
124: (dbi_mgr_id, resource_id, user_id, group_id,
125: creation_date, created_by )
126: SELECT /*+ use_hash(x) parallel(x) */
127: jtf_rs_dbi_mgr_groups_s.nextval, x.resource_id, x.user_id, x.group_id

Line 127: jtf_rs_dbi_mgr_groups_s.nextval, x.resource_id, x.user_id, x.group_id

123: INTO jtf_rs_dbi_mgr_groups
124: (dbi_mgr_id, resource_id, user_id, group_id,
125: creation_date, created_by )
126: SELECT /*+ use_hash(x) parallel(x) */
127: jtf_rs_dbi_mgr_groups_s.nextval, x.resource_id, x.user_id, x.group_id
128: , l_sysdate, l_user_id
129: FROM (
130: SELECT /*+ use_hash(res mgr) parallel(res) parallel(mgr) */
131: DISTINCT mgr.resource_id, res.user_id, mgr.group_id

Line 143: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_MGR_GROUPS',

139: ;
140:
141: COMMIT;
142:
143: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_MGR_GROUPS',
144: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism ,granularity=>'GLOBAL',cascade=>TRUE);
145:
146: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS' ;
147:

Line 219: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1

215: '0-FIRST-TIME-GROUPS' debug_column, jtf_rs_dbi_denorm_res_groups_s.nextval
216: ,'N' mem_flag , 'A' mem_status
217: ,l_sysdate, l_user_id
218: ,DECODE(d1.active_flag,'Y','Y','N')
219: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1
220: WHERE n1.group_id = d1.actual_parent_id
221: AND d1.denorm_level < 2
222: AND d1.latest_relationship_flag = 'Y'
223: ;

Line 258: jtf_rs_dbi_mgr_groups n1

254: ,'N' mem_flag , 'A' mem_status
255: ,l_sysdate, l_user_id
256: ,DECODE(d1.active_flag,'Y','Y','N')
257: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,
258: jtf_rs_dbi_mgr_groups n1
259: WHERE n1.group_id = d1.parent_group_id
260: AND d1.group_id = d2.actual_parent_id
261: AND n1.group_id = d2.parent_group_id
262: AND d1.group_id <> d2.group_id

Line 299: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

295: jtf_rs_dbi_denorm_res_groups_s.nextval
296: ,'N' mem_flag , 'A' mem_status
297: ,l_sysdate, l_user_id
298: ,DECODE(d1.active_flag,'Y','Y','N')
299: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
300: WHERE n1.group_id = d1.parent_group_id
301: AND d1.latest_relationship_flag = 'Y'
302: ;
303:

Line 336: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1

332: , jtf_rs_dbi_denorm_res_groups_s.nextval
333: ,'N' mem_flag , 'A' mem_status
334: ,l_sysdate, l_user_id
335: ,DECODE(d1.active_flag,'Y','Y','N')
336: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
337: WHERE n1.group_id = d1.parent_group_id
338: AND d1.denorm_level > 0
339: AND d1.latest_relationship_flag = 'Y'
340: ;