[Home] [Help]
796: if X_wip_repetitive_item IS NOT NULL THEN
797: select count(*) into X_wip_repetitive_item
798: from dual
799: where exists ( select 'x'
800: from WIP_REPETITIVE_ITEMS wri
801: where wri.PRIMARY_ITEM_ID = p_item_id
802: and wri.ORGANIZATION_ID in ( select mp.organization_id
803: from mtl_parameters mp
804: where mp.master_organization_id = p_master_org));