[Home] [Help]
253: -- c_category_set_id NUMBER, c_organization_id NUMBER) IS
254: l_sql VARCHAR2(2000) := 'SELECT mic.inventory_item_id, '||
255: 'msi.concatenated_segments, ms.description '||
256: 'FROM mtl_item_categories mic, mtl_system_items_kfv msi, '||
257: ' mtl_system_items_vl ms ' ||
258: 'WHERE mic.inventory_item_id = ms.inventory_item_id ' ||
259: ' AND mic.organization_id = ms.organization_id ' ||
260: ' AND mic.organization_id = msi.organization_id ' ||
261: ' AND mic.inventory_item_id = msi.inventory_item_id ' ||
614: --04/20/09 amaheshw Bug 8415339
615: TYPE ItemCurType IS REF CURSOR;
616: c_check_item ItemCurType;
617:
618: l_sql VARCHAR2(2000) := 'SELECT 1 FROM mtl_item_categories mic, ibe_ct_relation_rules rule, mtl_system_items_vl ms ' ||
619: ' WHERE mic.category_set_id = :c_category_set_id ' ||
620: ' AND mic.organization_id = :p_organization_id ' ||
621: ' AND mic.inventory_item_id = :c_inventory_item_id ' ||
622: ' AND mic.category_id = rule.dest_object_id ' ||
636: CURSOR c_check_item(c_section_id NUMBER,
637: c_category_set_id NUMBER, c_organization_id NUMBER,
638: c_inventory_item_id NUMBER) IS
639: SELECT 1 FROM mtl_item_categories mic, ibe_ct_relation_rules rule,
640: mtl_system_items_vl ms
641: WHERE mic.category_set_id = c_category_set_id
642: AND mic.organization_id = p_organization_id
643: AND mic.inventory_item_id = c_inventory_item_id
644: AND mic.category_id = rule.dest_object_id
660: c_end_date DATE) IS
661: SELECT si.section_item_id, si.inventory_item_id,
662: msi.concatenated_segments, ms.description
663: FROM ibe_dsp_section_items si, mtl_system_items_kfv msi,
664: mtl_system_items_vl ms
665: WHERE si.inventory_item_id = ms.inventory_item_id
666: AND si.organization_id = ms.organization_id
667: AND si.organization_id = msi.organization_id
668: AND si.inventory_item_id = msi.inventory_item_id