DBA Data[Home] [Help]

APPS.BIM_LEAD_RG_PKG dependencies on JTF_RS_GROUPS_DENORM

Line 250: ,jtf_rs_groups_denorm GDN

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
252: rgrp.group_id = gdn.parent_group_id
253: AND gdn.group_id = a.group_id
254: AND gdn.end_date_active is null

Line 394: ,jtf_rs_groups_denorm b

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'
398: AND b.end_date_active is null

Line 413: ,jtf_rs_groups_denorm b

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
417: AND b.immediate_parent_flag = 'N'