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.AMS_MINISITE_DENORM_PVT dependencies on IBE_DSP_MSITE_SCT_SECTS

Line 29: FROM ibe_dsp_msite_sct_sects mss, ibe_dsp_sections_b s

25: -- where END_DATE_ACTIVE > sysdate ;
26:
27: cursor allTopLevelSections(l_minisite_id in number, l_msite_root_section_id in number) IS
28: SELECT distinct s.section_id
29: FROM ibe_dsp_msite_sct_sects mss, ibe_dsp_sections_b s
30: WHERE mss.parent_section_id = l_msite_root_section_id
31: AND mss.mini_site_id = l_minisite_id
32: AND s.section_id = mss.child_section_id
33: AND s.section_type_code = 'N'

Line 55: FROM ibe_DSP_MSITE_SCT_SECTS mss

51: (
52: select cs.child_section_id from
53: (
54: SELECT mss.child_section_id child_section_id
55: FROM ibe_DSP_MSITE_SCT_SECTS mss
56: START WITH mss.child_section_id = p_sectionId
57: and mss.mini_site_id = p_msite_id
58: CONNECT BY PRIOR mss.child_section_id = mss.parent_section_id
59: and mss.mini_site_id = p_msite_id

Line 64: from ibe_DSP_MSITE_SCT_SECTS mss2

60: ) cs
61: where cs.child_section_id not in
62: (
63: select mss2.parent_section_id
64: from ibe_DSP_MSITE_SCT_SECTS mss2
65: where mini_site_id = p_msite_id
66: )
67: and NOT EXISTS
68: (

Line 83: -- FROM ibe_DSP_MSITE_SCT_SECTS mss

79: -- WHERE f.section_id in
80: -- (
81: -- SELECT mss.child_section_id
82: --SELECT mss.parent_section_id
83: -- FROM ibe_DSP_MSITE_SCT_SECTS mss
84: -- START WITH mss.child_section_id = p_sectionId
85: --START WITH mss.parent_section_id = p_sectionId
86: -- and mss.mini_site_id = p_msite_id
87: -- CONNECT BY PRIOR mss.child_section_id = mss.parent_section_id

Line 91: -- FROM ibe_DSP_MSITE_SCT_SECTS mss2

87: -- CONNECT BY PRIOR mss.child_section_id = mss.parent_section_id
88: -- AND mss.mini_site_id = p_msite_id
89: -- MINUS
90: -- (SELECT mss2.parent_section_id
91: -- FROM ibe_DSP_MSITE_SCT_SECTS mss2
92: -- )
93: -- MINUS
94: -- (
95: -- select s.section_id

Line 96: -- from ibe_DSP_MSITE_SCT_SECTS mss3 , ibe_dsp_sections_b s

92: -- )
93: -- MINUS
94: -- (
95: -- select s.section_id
96: -- from ibe_DSP_MSITE_SCT_SECTS mss3 , ibe_dsp_sections_b s
97: -- where mss3.child_section_id = s.section_id
98: -- and s.status_code = 'UNPUBLISHED'
99: -- and mss3.mini_site_id = p_msite_id
100: -- )

Line 164: FROM ibe_DSP_MSITE_SCT_SECTS mss

160: where f.section_id in
161: (
162: SELECT mss.child_section_id
163: --SELECT mss.parent_section_id
164: FROM ibe_DSP_MSITE_SCT_SECTS mss
165: START WITH mss.child_section_id = sectionIdData.section_id
166: --START WITH mss.parent_section_id = sectionIdData.section_id
167: and mss.mini_site_id = v_CompoundData.MSITE_ID
168: CONNECT BY PRIOR mss.child_section_id = mss.parent_section_id

Line 172: FROM ibe_DSP_MSITE_SCT_SECTS mss2

168: CONNECT BY PRIOR mss.child_section_id = mss.parent_section_id
169: AND mss.mini_site_id =v_CompoundData.MSITE_ID
170: MINUS
171: (SELECT mss2.parent_section_id
172: FROM ibe_DSP_MSITE_SCT_SECTS mss2
173: )
174: MINUS
175: (
176: select s.section_id

Line 177: from ibe_DSP_MSITE_SCT_SECTS mss3 , ibe_dsp_sections_b s

173: )
174: MINUS
175: (
176: select s.section_id
177: from ibe_DSP_MSITE_SCT_SECTS mss3 , ibe_dsp_sections_b s
178: where mss3.child_section_id = s.section_id
179: and s.status_code = 'UNPUBLISHED'
180: and mss3.mini_site_id = v_CompoundData.MSITE_ID
181: )