4130: else
4131: l_bomItemID := wjsi_row.primary_item_id;
4132: end if;
4133: l_isUnitEffective := l_bomItemID is not null and
4134: pjm_unit_eff.enabled = 'Y' and
4135: pjm_unit_eff.unit_effective_item(l_bomItemID,
4136: wjsi_row.organization_id) = 'Y';
4137:
4138: if( l_isUnitEffective and wjsi_row.end_item_unit_number is not null) then
4131: l_bomItemID := wjsi_row.primary_item_id;
4132: end if;
4133: l_isUnitEffective := l_bomItemID is not null and
4134: pjm_unit_eff.enabled = 'Y' and
4135: pjm_unit_eff.unit_effective_item(l_bomItemID,
4136: wjsi_row.organization_id) = 'Y';
4137:
4138: if( l_isUnitEffective and wjsi_row.end_item_unit_number is not null) then
4139: begin