[Home] [Help]
68: -- get the max and min unit numbers if the item is MU controlled.
69: if nvl(l_effectivity_control,0) = 2 then
70: select min(unit_number),max(unit_number) into
71: l_unit_number_from,l_unit_number_to
72: from pjm_unit_numbers
73: where master_organization_id = fnd_profile.value('ORG_ID');
74: end if;
75: -- get the maximum explosion level.
76: SELECT MAXIMUM_BOM_LEVEL INTO l_max_level