DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on FND_OBJECTS

Line 589: ,fnd_objects fo

585: SELECT ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
586: BULK COLLECT
587: INTO l_attr_grp_name
588: FROM ego_obj_ag_assocs_b eoab
589: ,fnd_objects fo
590: ,EGO_FND_DSC_FLX_CTX_EXT ext
591: WHERE eoab.object_id = fo.object_id
592: AND fo.obj_name in ( 'RRS_SITE')
593: AND eoab.attr_group_id = ext.attr_group_id

Line 608: ,fnd_objects fo

604: SELECT eoab.attr_group_id
605: BULK COLLECT
606: INTO l_attr_grp_id
607: FROM ego_obj_ag_assocs_b eoab
608: ,fnd_objects fo
609: WHERE eoab.object_id = fo.object_id
610: AND fo.obj_name in ( 'RRS_SITE')
611: AND eoab.classification_code IN
612: (

Line 860: ,fnd_objects fo

856: SELECT ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
857: BULK COLLECT
858: INTO l_attr_grp_name
859: FROM ego_obj_ag_assocs_b eoab
860: ,fnd_objects fo
861: ,EGO_FND_DSC_FLX_CTX_EXT ext
862: WHERE eoab.object_id = fo.object_id
863: AND fo.obj_name in ( 'RRS_LOCATION')
864: AND eoab.attr_group_id = ext.attr_group_id

Line 1083: ,fnd_objects fo

1079: SELECT distinct ext.DESCRIPTIVE_FLEX_CONTEXT_CODE
1080: BULK COLLECT
1081: INTO l_attr_grp_name
1082: FROM ego_obj_ag_assocs_b eoab
1083: ,fnd_objects fo
1084: ,EGO_FND_DSC_FLX_CTX_EXT ext
1085: WHERE eoab.object_id = fo.object_id
1086: AND fo.obj_name in ( 'RRS_TRADE_AREA')
1087: AND eoab.attr_group_id = ext.attr_group_id