DBA Data[Home] [Help]

APPS.BIL_OBI_GROUPS_DENORM_PKG dependencies on JTF_RS_GROUP_USAGES

Line 80: from jtf_rs_groups_denorm j, jtf_rs_group_usages u

76: from
77: (select j.denorm_grp_id, j.group_id, j.parent_group_id, j.created_by, j.creation_date,j.last_updated_by,
78: j.last_update_date,j.last_update_login, j.immediate_parent_flag, j.start_date_active, j.end_date_active,
79: j.active_flag, j.denorm_level
80: from jtf_rs_groups_denorm j, jtf_rs_group_usages u
81: where j.group_id = u.group_id
82: and u.usage = 'SALES'
83: and latest_relationship_flag = 'Y'
84: order by group_id, denorm_level))))));