[Home] [Help]
764: begin
765: select 'Y' into l_exists
766: from mtl_system_items_b
767: where inventory_item_id = p_Item_Orderability_Import_Rec.inventory_item_id
768: and organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id );
769: Exception
770: when no_data_found then
771: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
772: fnd_message.set_token('ATTRIBUTE','INVENTORY_ITEM_ID');
851: mtl_default_category_sets cs,
852: oe_item_orderability oei
853: WHERE ic.category_set_id=cs.category_set_id
854: AND cs.functional_area_id = 7
855: AND ic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id)
856: AND ic.inventory_item_id = p_Item_Orderability_Import_Rec.inventory_item_id
857: AND oei.enable_flag='Y'
858: AND ic.category_id = oei.item_category_id
859: and org_id = p_Item_Orderability_Import_Rec.org_id
913: mtl_default_category_sets cs,
914: oe_item_orderability oei
915: WHERE ic.category_set_id=cs.category_set_id
916: AND cs.functional_area_id = 7
917: AND ic.organization_id=oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id)
918: AND ic.inventory_item_id = oei.inventory_item_id
919: AND oei.enable_flag='Y'
920: AND ic.category_id = p_Item_Orderability_Import_Rec.ITEM_CATEGORY_ID
921: and org_id = p_Item_Orderability_Import_Rec.org_id