eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_SEARCHUPDATE_PVT dependencies on IBE_DSP_MSITE_SCT_SECTS

Line 137: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B s

133: -- sytong, bug fix 2550153, remove extra table ibe_msites_b in from clause
134: cursor allTopLevelSections(l_minisite_id in number,
135: l_msite_root_section_id in number) IS
136: SELECT distinct s.section_id
137: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B s
138: WHERE mss.parent_section_id = l_msite_root_section_id
139: AND mss.mini_site_id = l_minisite_id
140: AND s.section_id = mss.child_section_id
141: AND s.section_type_code = 'N'

Line 160: from ibe_dsp_msite_sct_sects s1

156: from ibe_dsp_section_items idsi
157: where section_id IN
158: (
159: select child_section_id
160: from ibe_dsp_msite_sct_sects s1
161: where mini_site_id = l_c_master_msite_id
162: and NOT EXISTS
163: (
164: select child_section_id

Line 165: from ibe_dsp_msite_sct_sects s2

161: where mini_site_id = l_c_master_msite_id
162: and NOT EXISTS
163: (
164: select child_section_id
165: from ibe_dsp_msite_sct_sects s2
166: where mini_site_id = l_c_msite_id
167: and s2.child_section_id=s1.child_section_id
168: )
169: CONNECT BY PRIOR child_section_id = parent_section_id

Line 186: from ibe_dsp_msite_sct_sects s3, ibe_dsp_section_items i2

182: and i1.inventory_item_id = idsi.inventory_item_id
183: )
184: union
185: select /*ordered use_nl(s3,i2) */ section_item_id, i2.inventory_item_id
186: from ibe_dsp_msite_sct_sects s3, ibe_dsp_section_items i2
187: where i2.section_id = s3.child_section_id
188: and s3.mini_site_id = l_c_msite_id
189: and NOT EXISTS
190: (

Line 270: FROM IBE_DSP_MSITE_SCT_SECTS mss

266: and f.start_date_active < sysdate
267: and f.section_id = s.section_id
268: and s.status_code = 'PUBLISHED' and f.section_id in
269: ( SELECT mss.child_section_id
270: FROM IBE_DSP_MSITE_SCT_SECTS mss
271: START WITH mss.child_section_id = l_toplevel_section_tbl(l_count2) --sectionIdData.section_id
272: and mss.mini_site_id = v_CompoundData.MSITE_ID
273: CONNECT BY PRIOR mss.child_section_id = mss.parent_section_id
274: AND mss.mini_site_id = v_CompoundData.MSITE_ID

Line 295: FROM IBE_DSP_MSITE_SCT_SECTS mss

291: and f.section_id = s.section_id
292: and s.status_code = 'PUBLISHED'
293: and f.section_id in
294: ( SELECT mss.child_section_id
295: FROM IBE_DSP_MSITE_SCT_SECTS mss
296: START WITH mss.child_section_id = sectionIdData.section_id
297: and mss.mini_site_id = v_CompoundData.MSITE_ID
298: CONNECT BY PRIOR mss.child_section_id = mss.parent_section_id
299: AND mss.mini_site_id =v_CompoundData.MSITE_ID