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: (
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
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