DBA Data[Home] [Help]

APPS.RRS_ATTR_PANE dependencies on AR_LOOKUPS

Line 33: FROM RRS_SITE_USES RSU, AR_LOOKUPS LK

29: SITE_ID,
30: SITE_IDENTIFICATION_NUMBER,
31: NAME,
32: (SELECT MEANING
33: FROM RRS_SITE_USES RSU, AR_LOOKUPS LK
34: WHERE RSU.SITE_ID = p_object_id
35: AND RSU.IS_PRIMARY_FLAG = 'Y'
36: AND LK.LOOKUP_TYPE (+) = 'PARTY_SITE_USE_CODE'
37: AND RSU.SITE_USE_TYPE_CODE = LK.LOOKUP_CODE (+)

Line 126: FROM RRS_SITE_USES RSU, AR_LOOKUPS LK

122: GROUP_ID,
123: SITE_IDENTIFICATION_NUMBER,
124: NAME,
125: (SELECT MEANING
126: FROM RRS_SITE_USES RSU, AR_LOOKUPS LK
127: WHERE RSU.SITE_ID = p_object_id
128: AND RSU.IS_PRIMARY_FLAG = 'Y'
129: AND LK.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
130: AND RSU.SITE_USE_TYPE_CODE = LK.LOOKUP_CODE