DBA Data[Home] [Help]

APPS.EAM_WORKORDERS_JSP dependencies on MTL_SECONDARY_INVENTORIES

Line 660: from mtl_secondary_inventories

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)

Line 668: from mtl_secondary_inventories

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)