DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on FND_OBJECTS

Line 607: ,fnd_objects fo

603: SELECT ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
604: BULK COLLECT
605: INTO l_attr_grp_name
606: FROM ego_obj_ag_assocs_b eoab
607: ,fnd_objects fo
608: ,EGO_FND_DSC_FLX_CTX_EXT ext
609: WHERE eoab.object_id = fo.object_id
610: AND fo.obj_name in ( 'RRS_SITE')
611: AND eoab.attr_group_id = ext.attr_group_id

Line 626: ,fnd_objects fo

622: SELECT eoab.attr_group_id
623: BULK COLLECT
624: INTO l_attr_grp_id
625: FROM ego_obj_ag_assocs_b eoab
626: ,fnd_objects fo
627: WHERE eoab.object_id = fo.object_id
628: AND fo.obj_name in ( 'RRS_SITE')
629: AND eoab.classification_code IN
630: (

Line 878: ,fnd_objects fo

874: SELECT ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
875: BULK COLLECT
876: INTO l_attr_grp_name
877: FROM ego_obj_ag_assocs_b eoab
878: ,fnd_objects fo
879: ,EGO_FND_DSC_FLX_CTX_EXT ext
880: WHERE eoab.object_id = fo.object_id
881: AND fo.obj_name in ( 'RRS_LOCATION')
882: AND eoab.attr_group_id = ext.attr_group_id

Line 1101: ,fnd_objects fo

1097: SELECT distinct ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
1098: BULK COLLECT
1099: INTO l_attr_grp_name
1100: FROM ego_obj_ag_assocs_b eoab
1101: ,fnd_objects fo
1102: ,EGO_FND_DSC_FLX_CTX_EXT ext
1103: WHERE eoab.object_id = fo.object_id
1104: AND fo.obj_name in ( 'RRS_TRADE_AREA')
1105: AND eoab.attr_group_id = ext.attr_group_id