DBA Data[Home] [Help]

APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 572: from mtl_secondary_inventories

568: and inventory_item_id = l_inventory_item_id;
569:
570: if(p_subinv_ctrl is null or p_subinv_ctrl <> 1) then
571: select secondary_inventory_name into l_subinv
572: from mtl_secondary_inventories
573: where
574: secondary_inventory_name = p_eam_wo_comp_rec.completion_subinventory
575: and organization_id = l_org_id
576: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)

Line 580: from mtl_secondary_inventories

576: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)
577: and Asset_inventory = 2;
578: elsif(p_subinv_ctrl = 1) then
579: select secondary_inventory_name into l_subinv
580: from mtl_secondary_inventories
581: where
582: secondary_inventory_name = p_eam_wo_comp_rec.completion_subinventory
583: and organization_id = l_org_id
584: and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate)