DBA Data[Home] [Help]

APPS.AMS_MINISITE_DENORM_PVT dependencies on IBE_DSP_SECTION_ITEMS

Line 49: FROM ibe_dsp_section_items f

45:
46: CURSOR ItemCur(p_sectionId in NUMBER, p_msite_id in NUMBER)
47: IS
48: SELECT DISTINCT f.inventory_item_id, f.organization_id
49: FROM ibe_dsp_section_items f
50: WHERE f.section_id in
51: (
52: select cs.child_section_id from
53: (

Line 78: -- FROM ibe_dsp_section_items f

74: );
75:
76: -- SELECT DISTINCT f.inventory_item_id, f.organization_id
77: --p_sectionId, p_msite_id
78: -- FROM ibe_dsp_section_items f
79: -- WHERE f.section_id in
80: -- (
81: -- SELECT mss.child_section_id
82: --SELECT mss.parent_section_id

Line 159: from ibe_dsp_section_items f

155: SYSDATE,
156: FND_GLOBAL.user_id,
157: SYSDATE,
158: FND_GLOBAL.conc_login_id
159: from ibe_dsp_section_items f
160: where f.section_id in
161: (
162: SELECT mss.child_section_id
163: --SELECT mss.parent_section_id