APPS.BIM_LEAD_RG_PKG dependencies on BIM_R_LEAD_GRP_MGR

Line 35: l_table_name := 'BIM_R_LEAD_GRP_MGR';

31: --get the schema name
32:
33: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
34:
35: l_table_name := 'BIM_R_LEAD_GRP_MGR';
36: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
37: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
38: fnd_file.put_line(fnd_file.log,fnd_message.get);
39:

Line 40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';

36: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
37: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
38: fnd_file.put_line(fnd_file.log,fnd_message.get);
39:
40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';
41:
42: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
43: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
44: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

Line 56: l_table_name := 'BIM_R_LEAD_GRP_MGR';

52: fnd_file.put_line(fnd_file.log,fnd_message.get);
53:
54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
55:
56: l_table_name := 'BIM_R_LEAD_GRP_MGR';
57: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
58: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
59: fnd_file.put_line(fnd_file.log,fnd_message.get);
60:

Line 63: INTO bim_r_lead_grp_mgr(

59: fnd_file.put_line(fnd_file.log,fnd_message.get);
60:
61:
62: INSERT
63: INTO bim_r_lead_grp_mgr(
64: creation_date
65: ,created_by
66: ,last_update_date
67: ,last_updated_by

Line 247: bim_r_lead_grp_mgr

243: ,0 squotes_open
244: ,0 sorders
245: FROM
246: (select group_id from
247: bim_r_lead_grp_mgr
248: group by group_id) RGRP
249: ,bim_r_lead_daily_facts a
250: ,jtf_rs_groups_denorm GDN
251: WHERE

Line 314: bim_r_lead_grp_mgr

310: ,sum(a.quotes_open) squotes_open
311: ,sum(a.orders) sorders
312: FROM
313: (select group_id from
314: bim_r_lead_grp_mgr
315: group by group_id) RGRP
316: ,bim_r_lead_daily_facts a
317: WHERE
318: rgrp.group_id = a.group_id

Line 393: bim_r_lead_grp_mgr a

389: b.parent_group_id group_id,
390: b.group_id child_group_id,
391: 'N' owner_flag
392: FROM
393: bim_r_lead_grp_mgr a
394: ,jtf_rs_groups_denorm b
395: WHERE
396: a.group_id = b.parent_group_id
397: AND b.immediate_parent_flag = 'Y'

Line 412: bim_r_lead_grp_mgr a

408: b.parent_group_id group_id,
409: b.group_id child_group_id,
410: 'Y' owner_flag
411: FROM
412: bim_r_lead_grp_mgr a
413: ,jtf_rs_groups_denorm b
414: WHERE
415: a.group_id = b.parent_group_id
416: AND b.parent_group_id = b.group_id