DBA Data[Home] [Help]

APPS.RRS_HIERARCHY_INFO dependencies on RRS_SITE_GROUP_NODES_VL

Line 281: RRS_SITE_GROUP_NODES_VL SiteGroupNodes1,

277: )
278: BULK COLLECT
279: INTO x_hier_members_tab
280: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMembers,
281: RRS_SITE_GROUP_NODES_VL SiteGroupNodes1,
282: RRS_SITE_GROUP_NODES_VL SiteGroupNodes2,
283: RRS_SITES_VL Sites1,
284: RRS_SITES_VL Sites2
285: WHERE SiteGroupMembers.CHILD_MEMBER_ID = SiteGroupNodes1.SITE_GROUP_NODE_ID(+)

Line 282: RRS_SITE_GROUP_NODES_VL SiteGroupNodes2,

278: BULK COLLECT
279: INTO x_hier_members_tab
280: FROM RRS_SITE_GROUP_MEMBERS SiteGroupMembers,
281: RRS_SITE_GROUP_NODES_VL SiteGroupNodes1,
282: RRS_SITE_GROUP_NODES_VL SiteGroupNodes2,
283: RRS_SITES_VL Sites1,
284: RRS_SITES_VL Sites2
285: WHERE SiteGroupMembers.CHILD_MEMBER_ID = SiteGroupNodes1.SITE_GROUP_NODE_ID(+)
286: AND SiteGroupMembers.CHILD_MEMBER_ID = Sites1.SITE_ID(+)