656:
657: Begin
658: if(p_subinv_ctrl is null or p_subinv_ctrl <> 1) then
659: select secondary_inventory_name into l_subinv
660: from mtl_secondary_inventories
661: where
662: secondary_inventory_name = p_subinventory
663: and organization_id = p_org_id
664: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
664: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
665: and Asset_inventory = 2;
666: elsif(p_subinv_ctrl = 1) then
667: select secondary_inventory_name into l_subinv
668: from mtl_secondary_inventories
669: where
670: secondary_inventory_name = p_subinventory
671: and organization_id = p_org_id
672: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)