APPS.FWK_PORTLET_GEN_UTIL dependencies on JDR_ATTRIBUTES

Line 142: FROM jdr_components COMP, jdr_attributes ATTR, jdr_paths PATH

138: jdr_mds_internal.getdocumentname(COMP.comp_docid) AS document_name,
139: PATH.path_name AS region_name,
140: COMP.comp_element AS region_type,
141: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name
142: FROM jdr_components COMP, jdr_attributes ATTR, jdr_paths PATH
143: WHERE COMP.comp_docid = ATTR.att_comp_docid
144: AND PATH.path_docid = COMP.comp_docid
145: AND ATTR.att_name = 'amDefName'
146: AND ATTR.att_value IS NOT NULL

Line 158: IN ( SELECT att_comp_docid FROM jdr_attributes

154: 'labeledFieldLayout', 'oa:messageComponentLayout', 'oa:query',
155: 'oa:shuttle', 'oa:stackLayout', 'oa:subTabLayout',
156: 'oa:table', 'oa:tableLayout', 'oa:tree')
157: AND COMP.comp_docid
158: IN ( SELECT att_comp_docid FROM jdr_attributes
159: WHERE att_name = 'standalone'
160: AND att_value = 'true'
161: AND att_comp_seq = 0 )
162: UNION ALL

Line 168: FROM jdr_components COMP, jdr_attributes ATTR

164: jdr_mds_internal.getdocumentname(COMP.comp_docid)||'.'||COMP.comp_id AS document_name,
165: COMP.comp_id AS region_name,
166: COMP.comp_element AS region_type ,
167: FWK_PORTLET_GEN_UTIL.getPathName(COMP.comp_docid)AS app_short_name
168: FROM jdr_components COMP, jdr_attributes ATTR
169: WHERE COMP.comp_docid = ATTR.att_comp_docid
170: AND ATTR.att_name = 'amDefName'
171: AND attr.att_value IS NOT NULL
172: AND ATTR.att_comp_seq = COMP.comp_seq

Line 183: IN ( SELECT DISTINCT att_comp_docid FROM jdr_attributes

179: 'labeledFieldLayout', 'oa:messageComponentLayout', 'oa:query',
180: 'oa:shuttle', 'oa:stackLayout', 'oa:subTabLayout',
181: 'oa:table', 'oa:tableLayout', 'oa:tree')
182: AND COMP.comp_docid
183: IN ( SELECT DISTINCT att_comp_docid FROM jdr_attributes
184: WHERE att_name = 'standalone'
185: AND att_value = 'true'
186: AND att_comp_seq = COMP.comp_seq )
187: UNION ALL