164: c.planner_code planner,
165: build_in_wip_flag build_in_wip,
166: pick_components_flag pick_components
167: FROM mtl_system_items_kfv c,
168: mtl_parameters p
169: WHERE c.concatenated_segments = p_item_Segments
170: AND c.organization_id = p.organization_id
171: AND p.organization_id = p_organization_id;
172:
344:
345: /* get calendar */
346: select p.calendar_code, p.calendar_exception_set_id
347: into l_cal_code, l_exception_set_id
348: from mtl_parameters p
349: where p.organization_id = p_organization_id;
350:
351: /* Validate cat set and MCAT struct */
352: IF (p_cat_set_id is not null and p_catg_struct_id is not null) then